OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » What it suggests? (Oracle9i/10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What it suggests? [message #340376]

Tue, 12 August 2008 09:06

Olivia
Messages: 519
Registered: June 2008

Senior Member

select * from dba_extents
where file_id=1
and 12345 between block_id and block_id + blocks -1

Want to know what is the significance of

block_id + blocks -1

Thanks in advance,

Regards,
Oli

Report message to a moderator

Re: What it suggests? [message #340381 is a reply to message #340376]

Tue, 12 August 2008 09:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what do you see & UNDERSTAND after doing
SQL> DESC DBA_EXTENTS

Report message to a moderator

Re: What it suggests? [message #340392 is a reply to message #340376]

Tue, 12 August 2008 10:20

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Want to know what is the significance of block_id + blocks -1

What is your opinion?
What is block_id?
What is blocks?

Regards
Michel

[Updated on: Tue, 12 August 2008 10:20]

Report message to a moderator

Re: What it suggests? [message #340400 is a reply to message #340376]

Tue, 12 August 2008 11:19

huiyi
Messages: 3
Registered: August 2008
Location: china

Junior Member

BLOCK_ID Starting block number of the extent.
BLOCKS Size of the extent in Oracle blocks.

Report message to a moderator

Re: What it suggests? [message #340407 is a reply to message #340400]

Tue, 12 August 2008 11:42

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The questions were for OP not for an answer and we are able to read the documentation.

By the way, when you quote documentation then say it is a quote and post a link.

Regards
Michel

Report message to a moderator

Previous Topic:	Query execution estimation
Next Topic:	Disk I/O started behaving differently when loading data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 16:44:33 CDT 2024