How do you prevent oracle from giving you informational messages during and after a sql statement execution?
627What happens when the default and temp tablespace clauses are left out from create user statements?
607When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
635What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
628How can you find out how many users are currently logged into the database? How can you find their operating system id?
576You 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?
631I am getting error "no communication channel" after changing the domain name? What is the solution?
631Post New Oracle DBA (Database Administration) Questions
When should the default values for oracle initialization parameters be used as is?
How many control files should you have? Where should they be located?
What is the difference between internal & external schema?
What do you understand by recovery catalog?
What is dba training?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
What do you understand by the term 'normalization'?
How do I become a database administrator?
How do you use automatic pga memory management with oracle 9i and above?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What is dba and functionalities of dba?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What are the main functions of dba?
What is the difference between cold backup and hot backup?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?