-
Start Up Information
In which file we can see start up information?
-
Instance Startup Time
How to find the startup time of instance?
-
TableSpace Space
How to find out how much space a tablespace has remaining?
-
Control File Restore
How to restore the control file by using RMAN backup?
-
Number of Databases Running
How do you verify the number of Databases running on a Host?
-
Database size
How to see the Database size and version and RMAN size and version?
-
Drop a Datafile
How to drop or delete a datafile which has been miskenly added to a tablespace?
-
Dump Destination
What is dump destination? What are bdump, cdump and udump? Explain in detail.
-
DB Server Performance Bottlenecks
What are four performance bottlenecks that can occur in a database server and How are they detected?
-
Alert log files
What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?
-
DML operations on standby database
Can you perform DML operations when the standby database is in read only in Standby Database?
-