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

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  


the process of adding a cpu in sql server is called..?

2 Answers   TCS,


How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  






what is the difference between db2start command and start database manager command?

1 Answers  


If we issue alter database begin backup. What happens to database?

2 Answers  


What the different topologies in which replication can be configured? : sql server DBA

0 Answers  


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  


how do see how much space is used and free in a tablespace

2 Answers   Genpact,


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  


Categories