When the developer trying to compile the package. But the database gets hanged? What will you check?
Latest Answer: We check the alert log file in bdump destination ...
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: Have a look into the following tables :DBA_HIST_SQLSTATdba_hist_snapshotby doing natural joins on these views for the SQL_ID, you will know about any plan changes happened. Do corrective actions as per the findings. ...
How will you rectify if one of the rollback segments gets corrupted
Latest Answer: The only option available is to restore and recover the database followed by opening the database with resetlogs. ...
When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?
Latest Answer: When Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name specified by the FILE parameter, and continues until complete or the maximum value of FILESIZE ...
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?
Latest Answer: When you issue the command "alter database backup controlfile to trace ; " a trace file will be created in the user_dump destination.The default name of the trace file would look something similar to dbname_ora_5175.trc. The number 5175 is the unix process ...
When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?
Latest Answer: select * from v$backup; == in this view you can check for status,if it is ACTIVE that file is still in backup mode.Hope this helps you.ThanksKumar ...
What are the differences between database designing and database modeling?
Latest Answer: Effective database design can help the development team reduce overall development time and costs. Undertaking the process of database design and creating a data model helps the team better understand the user's requirements and thus enables them ...
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
Latest Answer: To improve the performance we have to go for index searching. ...
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
Latest Answer: Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table . ...
How to check to memory gap once the SGA is started in Restricted mode?
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
