I worked recently on the problem and it worked...Code:SQL> show sga Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 100663296 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes SQL> show parameter db_cache_size NAME TYPE VALUE ------------------------------------ ----------- ------------------- db_cache_size big integer 20971520 SQL> show parameter shared_pool_size NAME TYPE VALUE ------------------------------------ ----------- ------------------- shared_pool_size big integer 33554432 SQL> show parameter large NAME TYPE VALUE ------------------------------------ ----------- ------------------- large_pool_size big integer 8388608 SQL> show parameter db_16K NAME TYPE VALUE ------------------------------------ ----------- ------------------- db_16k_cache_size big integer 12582912 SQL>
Thanks




Reply With Quote