Paypal DBA Saibabu mentioned an interesting undocumented parameter to bypass buffer cache for full table scans in his blog http://sai-oracle.blogspot.com/
alter session set "_serial_direct_read" = true;
I found it's particular useful in OLTP environment where you need to occasionally run a FTS query against a large table.
No comments:
Post a Comment