Home » RDBMS Server » Performance Tuning » Detrimental effect of many extents
Detrimental effect of many extents [message #65930] Tue, 01 February 2005 14:55 Go to next message
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
Re: Detrimental effect of many extents [message #65932 is a reply to message #65930] Tue, 01 February 2005 20:25 Go to previous messageGo to next message
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
Slow user session [message #65933 is a reply to message #65932] Tue, 01 February 2005 21:20 Go to previous messageGo to next message
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
Re: Slow user session [message #65934 is a reply to message #65933] Tue, 01 February 2005 21:32 Go to previous messageGo to next message
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...
Re: Detrimental effect of many extents [message #65936 is a reply to message #65930] Wed, 02 February 2005 05:15 Go to previous message
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.
Previous Topic: please help me interpret this tkprof
Next Topic: Oracle join problem (full table scan)
Goto Forum:
  


Current Time: Thu Oct 01 02:57:31 CDT 2020