Oracle supports large number of extents in a segment
The performance of DML operations is independent of number of extents in
segment
some DDL operations like droping and truncating show some restriction in
performance
upto 4096 extents can be maximised



Majid Yousuf
4





"Omar Achandair "
<oracledba-ezmlmshield-x15239080.[Email address protected]
29/09/2006 03:09 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Number of extents-performance-






Hi all,

I m wondering if performance of oracle are decresed if segments have a
big number of extents?
Thkx for help


Omar ACHANDAIR



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information. If you are
not the intended recipient, please contact the sender by reply e-mail and destroy
all copies and the original message. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken
in reliance on this e-mail is strictly prohibited and may be unlawful.The recipient
acknowledges that Bharti Airtel Limited or its subsidiaries and associated companies(collectively "Bharti Airtel Limited"), are unable to exercise control or ensure or guarantee the integrity of/overthe contents
of the information contained in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no binding nature of the
message shall be implied or assumed unless the sender does so expressly with due authority of Bharti Airtel Limited.Before opening any attachments please check them for viruses and defects.

Oracle LazyDBA home page