Topic : Initialization Parameters

You have installed Oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish; what should you check first to determine if there is a problem?


Answer :

Check to make sure that the archiver isn?t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.

Show Answer Discuss

The order in which Oracle processes a single SQL statement is ?


  • Execute; parse; fetch
  • Execute; fetch; parse
  • Parse; execute; fetch
  • Parse; fetch; execute

Answer :

Parse; execute; fetch

Show Answer Discuss

Two processes waiting to update the rows of a table; which are locked by other processes then deadlock arises.


Answer :

How do you see how many instances are running?

Show Answer Discuss

How do you see how many instances are running?


Answer :

$ps -ef | grep ora_smon

Show Answer Discuss

How do you automate starting and shutting down of databases in Unix?


Answer :

By using dbstart and dbshut scripts.

Show Answer Discuss