What are the different scenarios for rebuilding indexes...
As a Oracle DBA what are all the UNIX file you should be familar with?
When the developer trying to compile the package. But the database gets hanged? What will you check?
When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?
Latest Answer: we have to take the sql trace. but it cannot be read by us. so we have to take the tkprof of this file which can be read by us. to take the sql trace fire the below commandSQL>alter session set sql_trace=true;then fire that sql statementSQL>select ...
How will you rectify if one of the rollback segments gets corrupted
Latest Answer: You have to restore and recover the corrupted rollback segment.Tauseef A. ...
When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?
Three users at a time giving the following command: alter database backup controlfile to trace; How can you differentiate the file using the filename itself?
When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?
Latest Answer: It freezes the headers of the file, when its in the backup mode.Tauseef A. ...
What are the differences between database designing and database modeling?
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
