-
How to implement the multiple control files for an existing database ?
Shutdown the databaseCopy one of the existing control file to new locationEdit Config ora file by adding new control file. nameRestart the database.
nitanjandial
- Jan 30th, 2007
+Before to insert new control files,we should verify the existing control files location+these are the ways to find it=======================================================1.show parameter control_fi...
-
What is Log Switch ?
The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
nitanjandial
- Dec 8th, 2007
log switch occurs when current redo logfile gets full and lgwr writes redo to next redo logfile.Even we can perform log switch with the command alsobefore we execute the sql execute following statemen...
Mohammed Abdul Afroze
- Sep 28th, 2007
The point at which oracle ends writing from one redo log and begins writing to another is called as a log switch.
-
What are the components of SGA ?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
Nagaraj OCP
- Dec 27th, 2011
SGA has six parts on it
Shared pool
JAVA POOL
Stream Pool
Large Pool
Data Buffer cache - MRU, LRU
Redo log buffersaihaan
- Jul 2nd, 2009
Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache.
-
What constitute an ORACLE Instance ?
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
dj_dj_dj
- Jun 22nd, 2009
Oracle Instance is an combination of background process and memory structures.
nareshkumarmca
- Jun 19th, 2009
Oracle instance is the combination of SGA and
background processes. When user sends a connection request server process starts and it starts instance.
