Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
connect.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  


how can you record information about current session?

0 Answers   Oracle,


how can you process messages in order asynchronously?

0 Answers   Oracle,


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  


Why would you call update statistics? : sql server DBA

0 Answers  






what is difference between user managed backup and rman backup?

1 Answers   CTS,


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,


what is incremental checkpoint?

1 Answers   CTS,


what is a user-defined lock?

0 Answers   Oracle,


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  


If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  


Give two methods you could use to determine what DDL changes have been made.

2 Answers  


Categories