How do you prevent oracle from giving you informational messages during and after a sql statement execution?
571What happens when the default and temp tablespace clauses are left out from create user statements?
564When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
594What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
587How can you find out how many users are currently logged into the database? How can you find their operating system id?
527You 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?
597I am getting error "no communication channel" after changing the domain name? What is the solution?
593Post New Oracle DBA (Database Administration) Questions
What are the possible ways to gain information regarding the control file?
What are dba privileges?
What is the use of the drop option in the alter table command?
How can you find your id on a system?
What does >> do?
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?
Explain the wait events in statspack report 'db scattered read'?
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.
If you see contention for library caches how you can fix it?
How do you set up your tablespace on installation level: low?
What is the finger command?
What are bind variables and why are they important?
How do you set up tablespaces during an oracle installation?
Why are recursive relationships bad? How do you resolve them?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?