-
Alertlog
Which functionality of a database creates alert log?
-
Recovery Catalog
How will you find out if your database is using recovery catalog or not?
-
Power Failure
What is the effect on database at the time of total power failure when an UPDATE query is under execution in Oracle 9i?
-
Redo Log
If we are running in NOARCHIVELOG mode and my all redo log files are full and data is still not committed by the current session. What activity will Oracle perform and what will happen with the un-comitted data?
-
Enterprise Linux OS Block Size
My platform is Enterprise Linux (RHEL AS4) How to find BLOCK SIZE.
-
-
-
How to DROP an Oracle Database?
You can do it at the OS level by deleting all the files of the database. The files to be deleted can be found using: 1) select * from dba_data_files; 2) select * from v$logfile; 3) select * from v$controlfile; 4) archive log list 5) initSID.ora 6) In addition you can clean the UDUMP, BDUMP, scripts etc Clean up the listener.ora and the tnsnames.ora. make sure that the oratab entry is also removed.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-