What are the steps you will take to improve performance of
a poor performing query?
No Answer is Posted For this Question
Be the First to Post Answer
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
Give two examples of how you might determine the structure of the table DEPT.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What's the benefit of "dbms_stats" over "analyze"?
What are the steps you will take to improve performance of a poor performing query?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how to restore files with rman?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the use of ocr?
What is the importance of a recovery model? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)