Unfortunately, no, at least not in 11.2.0.4. Maybe in 12c?
Using the V$BH view we see another curiosity in that we allocated the max 192G
to each database, which would seem to make over 25 million 8K buffer blocks
available in each. However, this query always returns a count of about 10
million in each DB.
Select Count(*) From V$BH Where Lower(Status) Like '%flash%' ;
As I said originally, these are very busy DBs containing several multi tens of
GB tables which are hit constantly. We expected the Flash Cache to fill up
pretty quickly, but it's been since Sunday morning and it seems to have settled
around 40% full. Any ideas why?
BTW, the Buffer Cache in each DB is around 30G.
Thanks for all your guidance.
--
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.
________________________________
From: tanel@xxxxxxxxxx <tanel@xxxxxxxxxx> on behalf of Tanel Poder
<tanel@xxxxxxxxxxxxxx>
Sent: Tuesday, February 7, 2017 11:35 PM
To: Jack Applewhite
Cc: Franky Weber Faust; oracle-l@xxxxxxxxxxxxx
Subject: Re: 11gR2 DB Flash Cache
If I recall correctly, the local-flash-backed "alternative buffer cache" also
shows up in v$buffer_pool and v$buffer_pool_statistics ?
On Tue, Feb 7, 2017 at 2:41 PM, Jack Applewhite
<jack.applewhite@xxxxxxxxxxxxx<mailto:jack.applewhite@xxxxxxxxxxxxx>> wrote:
Franky,
Thanks a bunch! That is really helpful info. I'm glad you pointed out the v$bh
query - the 11gR2 Reference doesn't list any kind of %flash% possibility for
Status, so I wouldn't have known to look.
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.