Where can you check the state of the database after the STARTUP command.

Showing Answers 1 - 4 of 4 Answers

Wildy

  • Jul 18th, 2011
 

select instance_name, status, database_status, startup_time from v$instance;

  Was this answer useful?  Yes

venu

  • Sep 1st, 2012
 

Code
  1. SELECT STATUS FROM v$instance
will give the required result.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions