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 ...
When a Oracle instance is up, How can we find which parameter file (pfile or spfile) the oracle is using?
Latest Answer : The command given below will display 3 colums NAME, TYPE, VALUESQL> show parameter spfile NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string E:ORACLEPRODUCT10.1.0DB_1 DATABASESPFILEORCL.ORAIf ...
What is PGA_AGGREGRATE_TARGET parameter?