Wednesday, 12 June 2019

How to flush shared Pool and buffer Cache??

Below command has no Harm to production systems,Can be used in case of performance degradation as this can help in refreshing Shared Pool and Buffer Cache and Database will reload both of these with new stats.


alter system flush buffer_cache;


alter system flush shared_pool; 

How to login on Oracle Cloud Console?

Login Steps for Oracle Cloud Console To sign in to Oracle Cloud Console, We need to open up the corresponding region console URL for Free Ti...