DBA Hub

📋Steps in this guide1/1

Run shared pool advisory

SELECT shared_pool_size_for_estimate "Size of Shared Pool in MB", shared_pool_size_factor "Size Factor", estd_lc_time_saved "Time Saved in sec" FROM v$shared_pool_advice;

oracle configurationintermediate
by OracleDba
14 views
1

Run shared pool advisory

Code/Command (click line numbers to comment):

1
2
3
SELECT shared_pool_size_for_estimate "Size of Shared Pool in MB",
shared_pool_size_factor "Size Factor",
estd_lc_time_saved "Time Saved in sec" FROM v$shared_pool_advice;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!