What file will give you oracle instance status information? Where is it located?
- 1 Answers
- 698 Views
- I also Faced
- E-Mail Answers
Answer / Mukesh Chandra Pandey
"The Oracle alert log file (ORACLE_SID.log) provides status information about the database instances. By default, it is located in the $ORACLE_BASE/admin/$ORACLE_SID/bdump directory for Linux/Unix based systems and ORACLE_HOMEadmin$ORACLE_SIDbdump for Windows-based systems."
| Is This Answer Correct ? | 0 Yes | 0 No |
What is main function of database administrator?
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.
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What are the goals of dba?
Is oracle dba in demand?
How can you find your id on a system?
How do you prevent output from coming to the screen?
What is oracle dba role?
How do you install statspack?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
What happens when the default and temp tablespace clauses are left out from create user statements?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
Oracle General 
