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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
the process of adding a cpu in sql server is called..?
How would you determine what sessions are connected and what resources they are waiting for?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
what is the difference between db2start command and start database manager command?
If we issue alter database begin backup. What happens to database?
What the different topologies in which replication can be configured? : sql server DBA
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?
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..........
how do see how much space is used and free in a tablespace
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?