| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How can i change the MAXEXTENTS ??
A copy of this was sent to ashesh48_at_my-dejanews.com
(if that email address didn't require changing)
On Thu, 06 Aug 1998 17:17:33 GMT, you wrote:
>Hi All, I got into the problem with the MAXEXTENTS of the table. It has
>reached to its maxlevel of the 121/121. How can I increase it?? Has anybody
>know the syntex for it ? How it affects to performace? And what is the
>recommanded number oof extents for a table??
>
>Thanx for any help in advance.
>Ashesh
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
What version of Oracle? Try:
SQL> alter table <TNAME> storage ( maxextents unlimited );
or use some other number in place of unlimited.
As long as your extent size is a multiple of your db_file_multiblock_read_count, having 1, 100 or 1000 (or more) extents is pretty much the same.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Aug 06 1998 - 13:46:05 CDT
 |
 |