 Related Questions 1.How do you calculate SGA?2.What happens to dbf`s if the high water mark is large?3.How to avoid error ora 01555 in Oracle 9i? Read Answers (1) | Asked by : Mohammed Abdul Afroze 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 ... Read Answers (1) | Asked by : KUMAR My database size is 80GB Latest Answer : Setting of SGASGA 55% of Physical RAMShared_Pool_size 45% of SGADb_buffer_cahe 45% of SGALog_buffer 10% of SGA ... Read Answers (1) | Asked by : sunitha 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 ... How to set the oracle from "Dedicated" to "Shared" server? What are all parameters needs to set to change the Oracle from "Dedicated" Server to "Shared" Server? Latest Answer : 1.To change from dedicated server to shared server add the following initialization parameters in the parameter file.dispatchers='(protocol=TCP)(disp=5)' max_dispatchers=150 shared_servers=5 max_shared_servers=1002.shutdown and restart the ... How to recover current, active, inactive redo log file in Oracle 9.2.0.4? How can we create control file, when it is lost? Latest Answer : If other files like datafile and log files are intact then take the back up
of the control file to trace directory as follows.
1. Open the database in nomount mode i.e. startup nomount;
2. Take the backup of control file i.e.
ALTER DATABASE BACKUP ... When we trace the control file how many datafiles are created? Latest Answer : No data files are created when we trace a control file. Tracing will create a word format of control file with all the information of data base (datafiles, log switching etc). ... How to restore the control file by using RMAN backup?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
