Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> size of free blocks in data cache (v$bh)?

size of free blocks in data cache (v$bh)?

From: Ibrahim DOGAN <idogan_tech_at_yahoo.com>
Date: 23 Dec 2003 11:11:17 -0800
Message-ID: <6bf58828.0312231111.24b654b2@posting.google.com>


i'm trying to figure out the block size of free blocks in data cache (v$bh[status='free']).

as all know, one can create data caches with different block sizes. but there's no block size column in v$bh...

i'm already hearing some say ts# can be used to get size of the block in v$bh which sounds reasonable for used blocks may not apply to free block because it leaves the question open: how come a "free" block can belong to a tablespace? so tablespace association doesn't make sense...

thanks
i.d. Received on Tue Dec 23 2003 - 13:11:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US