Home » RDBMS Server » Server Administration » Location of a DB Block (oracle 10.2.0.1.0 - windows XP)
Location of a DB Block [message #493238] Mon, 07 February 2011 00:41 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Can any one tell me:
1) How to find out, whether my Query return the output from the block of BUFFER CACHE or from DATAFILES?
2) How to calculate the no of data blocks were used to return a single output.

Regards:
Muktha

Report message to a moderator

Re: Location of a DB Block [message #493242 is a reply to message #493238] Mon, 07 February 2011 00:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Location of a DB Block [message #493245 is a reply to message #493242] Mon, 07 February 2011 01:19 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$mystat (with a join on v$statname) to get statistics on "block" and "read".

Regards
Michel

Report message to a moderator

Previous Topic: TNS-01150 The address of the specified listener name is incorrect (2 Merged)
Next Topic: Manual DB creation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 08 07:44:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.