OraFAQ Forum: Performance Tuning » Detrimental effect of many extents

Home » RDBMS Server » Performance Tuning » Detrimental effect of many extents

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

Detrimental effect of many extents [message #65930]

Tue, 01 February 2005 14:55

helen
Messages: 13
Registered: September 2000

Junior Member

Is there going to be a detrimental effect to performance if tables are created in thousands of extents with very small (0.1MB) extent sizes.

Also how do you tell of a table has statistics created and when they were updated?

Thanks

Report message to a moderator

Re: Detrimental effect of many extents [message #65932 is a reply to message #65930]

Tue, 01 February 2005 20:25

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

Try using DBA_EXTENTS

select segment_name,tablespace_name,count(segment_name) "No of Extents",
sum(bytes)/1024/1024 "Size MB" from dba_extents
group by segment_name,tablespace_name

Report message to a moderator

Slow user session [message #65933 is a reply to message #65932]

Tue, 01 February 2005 21:20

Dhriti Ranjan Sil
Messages: 1
Registered: February 2005

Junior Member

I have completed server tuning and found everything
ok but I am getting the complaint that the users in
some/All terminals in general is having there session
to be slow ? The system here is Oracle 8 on Unix

Report message to a moderator

Re: Slow user session [message #65934 is a reply to message #65933]

Tue, 01 February 2005 21:32

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

Collect the stats for that particualr sessiions...
or trace the SQL Statements from V$sql_area for that particular sessiion and find the bottelnecks and
take apporpriate steps ...by creating indexes...

Report message to a moderator

Re: Detrimental effect of many extents [message #65936 is a reply to message #65930]

Wed, 02 February 2005 05:15

Madonna ofthe Wasps
Messages: 15
Registered: September 2004

Junior Member

As long as you are using LMT, thousands of extents will not have a detrimental effect.

USER_TABLES view has the information on the statistics for a table.

Report message to a moderator

Previous Topic:	please help me interpret this tkprof
Next Topic:	Oracle join problem (full table scan)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 17:29:31 CDT 2025