Cache buffer chain CBC latch simple query to investigate
For deep understanding on CBC,please refer to below links:- http://www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB. I am just going to mention some useful queries to investigate or identify CBC latch Step 1:-You as user fire a sql query from client. select * from cbctest; Step 2:-Now oracle will search metadata… Continue Reading Cache buffer chain CBC latch simple query to investigate
- Posted on:
-
Author:
debasis maity
- Categories: General Performance tuning, Technology
- Tags: CBC latch
- Leave a comment: Cache buffer chain CBC latch simple query to investigate