Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
551Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
770What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
580Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
589Post New Oracle DBA (Database Administration) Questions
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What are the types of locks in database?
What happens when the default and temp tablespace clauses are left out from create user statements?
Explain the wait events in statspack report 'enqueue'?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
What is a dba programmer?
Which date function is used to find the difference between two dates?
When should you increase copy latches?
How do you install statspack?
What is a dba why is this position necessary?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What is the easiest method to create a file on unix?
What is a database instance?
What is the difference between a database and instance?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
