How do you prevent oracle from giving you informational messages during and after a sql statement execution?
524What happens when the default and temp tablespace clauses are left out from create user statements?
534When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
553What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
547How can you find out how many users are currently logged into the database? How can you find their operating system id?
474You 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?
554I am getting error "no communication channel" after changing the domain name? What is the solution?
540Post New Oracle DBA (Database Administration) Questions
What is explain plan and how is it used?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
Who is a database user?
What is dba software?
What does dba stand for database?
System tablespace cant be exported from one database and imported into another why?
What is difference between logical standby database and physical standby database?
Explain procedure to change characterset of a database.
How can you find dead processes?
How do I become a database administrator?
If you are not sure what command does a particular unix function what is the best way to determine the command?
How do you set up your tablespace on installation level: low?
How can you find out how many users are currently logged into the database?
What is oracle archived redo log?