Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> set table or index unlimited or not

set table or index unlimited or not

From: Mitchell <mitchell_at_comnet.ca>
Date: Fri, 29 Dec 2000 09:24:43 -0500
Message-Id: <10725.125447@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_014B_01C07179.2D9C1880 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_014B_01C07179.2D9C1880 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>Hi=20
DBAs</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman"=20
size=3D3></FONT></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestion&nbsp; for following=20
questions?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>1. Maxextents: total no of =
extents</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; when you&nbsp;set =
&nbsp;the=20
maxextents, How do you know that byte in size?&nbsp; &nbsp;is it defined = by=20
Inital ( in bytes of the objects' first extent)?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>2. is there anyway to monitor the =
situation like=20
if&nbsp;setting for Next is 10m, but Maxextents&nbsp;space reached=20 over.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman"=20
size=3D3><BR><BR>Mitchell</FONT><BR><BR><BR></DIV></FONT></BODY></HTML> Received on Fri Dec 29 2000 - 08:24:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US