How do you prevent oracle from giving you informational messages during and after a sql statement execution?
286What happens when the default and temp tablespace clauses are left out from create user statements?
306When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
290What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
324How can you find out how many users are currently logged into the database? How can you find their operating system id?
262You 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?
286I am getting error "no communication channel" after changing the domain name? What is the solution?
297Post New Oracle DBA (Database Administration) Questions
System tablespace cant be exported from one database and imported into another why?
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?
What is dba training?
What does a dba stand for?
What is da in database?
How can you find all the processes on your system?
What command is used to type files to the screen?
How do you put database is archivelog mode, explain procedure?
What are types of data model?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
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?
If you have an example table, what is the best way to get sizing data for the production table implementation?
What is explain plan and how is it used?
As an oracle dba what are the entire unix file you should be familiar with?
What is oracle archived redo log?