-
DUAL table in Oracle
Can you explain What is DUAL table in Oracle?
ashish88
- Jun 11th, 2008
hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc...
parthokonar
- Apr 19th, 2006
Hi,Actually what happens when we issue create database command, Oracle automatically creates the tablespace and tables using the sql.bsq script found in the $oracle_home/rdbms/admin directory this scripts the dual table and is owned by the sys and has one column and one row.
-
What is Shared Pool ?
Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.
Mohammed Abdul Afroze
- Oct 16th, 2007
Shared Pool compromises of Library Cache and Dictionary Cache.Library Cache stores and shares sql stmts where as plsql stmts in memory.Dictionary Cache: Oracle continously request and update informati...
parthokonar
- Apr 19th, 2006
Hi,Actually Shared pool is composed of two parts one is Library Cache and another Data Dictionary cache The Library cache contains the shared sql areas, private sql areas, PL/SQL procedures and packag...
