Answer Posted / braj123
--> use VMSTAT to check the cpu enqueues.
--> also use top and sar commands for cpu load.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how can you schedule a job in database?
How can you control the amount of free space in your index pages? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
how can you enable flashback feature?
what is grd?
Explain materialized views and how they are used.
What is dbcc? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the recovery models for a database? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA