Home » RDBMS Server » Performance Tuning » What it suggests? (Oracle9i/10g)
What it suggests? [message #340376] Tue, 12 August 2008 09:06 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 02:06:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.