Re: set table or index unlimited or not

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Fri, 29 Dec 2000 07:08:37 -0800 (PST)
Message-Id: <10725.125449@fatcity.com>

The maximum size of a segment is initial extent * maxextents (except if using partitions) .

With or without maxextent unlimited, you should verify the number of extents periodically, check in dba_segments.

If managing a high availability db then you should use unlimited extent or a big maxextent and monitor the number of extents. You do not want a transaction to fail because the segment has reached its maxextent.

• Mitchell <mitchell_at_comnet.ca> a écrit : > Hi DBAs
  >
  > Any suggestion for following questions?
  >
  > 1. Maxextents: total no of extents
  > when you set the maxextents, How do you know
  > that byte in size? is it defined by Inital ( in
  > bytes of the objects' first extent)?
  >
  > 2. is there anyway to monitor the situation like if
  > setting for Next is 10m, but Maxextents space
  > reached over.
  >
  >
  > Mitchell
  >
  >
  >
  >
  

  ---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

---

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! Received on Fri Dec 29 2000 - 09:08:37 CST