The ORACLE db is running with session audit and the audit table is full. What happens to new sessions? Nothing, They are not audited New Connections are Not Allowed Session allowed, with audit to alert.log
Latest Answer : What is this ? Please post individually ...
At the time of hot backup lot of redo will be generated how to reduce that redo generations
How to recover current, active, inactive redo log file in Oracle 9.2.0.4?
In which format redo log files stores the changes ?
Latest Answer : Good Question. They are not stored in binary format , but in sql. ...
How many redo log group are there in Oracle 10g database? What are they?
Latest Answer : At Least 2 groups. To protect against a failure involving the redo log itself, Oracle Database allows a multiplexed redo log, meaning that two or more identical copies of the redo log can be automatically maintained in separate locations. For the most ...
What is the purpose of redo log files?
Latest Answer : The purpose of redo log file is to record all changes made to the data during the recovery of database.It always advisable to have two or more redo log files and keep them in a seperate disk, So you can recover the data during the system crash. ...