Tell me about standby database? What are some of the configurations of it? What should we watch out for?
543Explain 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?)
758What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
571Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
578Post New Oracle DBA (Database Administration) Questions
I am getting error "no communication channel" after changing the domain name? What is the solution?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
If you see statistics that deal with "undo" what are they really talking about?
What file will give you oracle instance status information? Where is it located?
How can you find dead processes?
What do you understand by the term 'normalization'?
What is the advantage of using rman?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What do you understand by the term 'system change number (scn)'?
What are the requirements of simple database?
What are some indications that you need to increase the shared_pool_size parameter?
What is dba in sound level?
What is the difference between internal & external schema?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What do you mean by oracle database?