Originally posted by jmodic Nope. At least not without trace-dumping all the blocks belonging to the particular segment and inspecting those dumps.
Why not...and why do u wana go for dumping all blocks to know which extent has how many rows.. crazy idea.. when it can be done in a single query ...
Dbms_Rowid.Rowid_Relative_Fno(Rowid) = My_Extent's_Relative_File_Number
Dbms_Rowid.Rowid_Relative_Fno(Rowid) RFN ,
Segment_Name = 'My_Table' And
RELATIVE_FNO = A.RFN
Ofcourse this will eat up CPU.
Hope i am correct in reading the requirement.
Last edited by abhaysk; 02-18-2004 at 08:54 AM.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Originally posted by abhaysk
[BWhy not...and why do u wana go for dumping all blocks to know which extent has how many rows.. crazy idea.. [/B]
Khm, not so crazy. In fact, as I said, it's the only way to find out if the block contains any data or not (for tables, anyway; indexes are even more complicated).
Neither of your queries will display correct result with 100% accuracy, some blocks that actually contain data might not be encountered by your queries.
Speaking about crazy ideas - the only crazy idea in this thread was the requirement to find which blocks contain any data and which do not. I mean, even if it can be done, what would the result tell you anyway?
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?