How do you prevent oracle from giving you informational messages during and after a sql statement execution?
586What happens when the default and temp tablespace clauses are left out from create user statements?
579When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
603What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
595How can you find out how many users are currently logged into the database? How can you find their operating system id?
548You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
607I am getting error "no communication channel" after changing the domain name? What is the solution?
602Post New Oracle DBA (Database Administration) Questions
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What are the different types of database users?
What exactly does a dba do?
What are the steps involved in instance recovery in oracle?
What should a dba know?
How do you set up your tablespace on installation level: low?
How to drop an oracle database?
Do you need a commit after ddl statements?
How do you use automatic pga memory management with oracle 9i and above?
What is the difference between a database and instance?
What are the functions of administration?
How many dba can you have?
How can you determine if an index needs to be dropped and rebuilt?