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
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: 25050
Registered: January 2009
Location: SoCal
Senior Member
what do you see & UNDERSTAND after doing
SQL> DESC DBA_EXTENTS
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: 64151
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 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.
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: 64151
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
Previous Topic: Query execution estimation
Next Topic: Disk I/O started behaving differently when loading data
Goto Forum:
  


Current Time: Fri Dec 09 19:31:47 CST 2016

Total time taken to generate the page: 0.17890 seconds