table cache clarification
query 2:why I am able to cache the table of 104m even though my Instance DB_CACHE_SIZE=96m
Tablesize is 104m and its lob size is 2gb
db_cache_size-->i reduced to 2m for just my testing but still i am able to cache the table of size 104m and also its lob of size 2gb.
-->whenever we cache the table it will be in DB_cache_size or any other memory component?
-->whether the oracle with internal hidden parameter already setted some db_cache_size value?
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Tablesize is 104m and its lob size is 2gb
db_cache_size-->i reduced to 2m for just my testing but still i am able to cache the table of size 104m and also its lob of size 2gb.
-->whenever we cache the table it will be in DB_cache_size or any other memory component?
-->whether the oracle with internal hidden parameter already setted some db_cache_size value?
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
0