11gR2 DB Flash Cache

Well, it's been better than Christmas! We've been marveling at the HUGE overall performance improvement we see. The main App hitting one of the DBs is a COTS Student Information System, hit by all of our 12,000 or so teachers and staff. There were a bunch of Selects in the App's code that would drive load averages to 200 - 400% periodically during the day. Now we rarely see load averages approaching 100%, usually staying around 25%. StatsPac reports show the dramatic differences in waits, as well as the SQLs found to be hogs.

My question ... Is there a way to get visibility into the flash cache to see what's in there? Since this is 11g, the 12c-only V$FlashFileStat view is not available and V$Sess_IO only has the session level Optimized_Physical_Reads column. None of the SGA-related views that I've found have info. about the flash cache. Mr. Google and MOS haven't helped either.

Any way to see what's going on in the Flash Cache?

Thanks.

--

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk)

I can't help about the shape I'm in,
I can't sing, I ain't pretty and my legs are thin. But ... -- "Oh Well" F.M.

Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student and/or employee information. Unauthorized use of disclosure is prohibited under the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov't Code 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please call the sender immediately or reply by email and destroy all copies of the original message, including attachments.