Solved

Uniform Size in Local Extent Management

Posted on 2001-08-12
2
2,293 Views
Last Modified: 2008-10-13
I want to create two tablespaces, one for big tables (can grow upto 10G of data a year), and one small tables.

Which uniform extent sizes are appropriate for those tablespaces if I use local extent management?

Here are my two sample SQLs.

CREATE TABLESPACE SMALL_DATA
DATAFILE 'SMALL_DATA.dbf' SIZE 1024M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K;

CREATE TABLESPACE BIG_DATA
DATAFILE 'SMALL_DATA.dbf' SIZE 2056M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128M;

Thanks
0
Comment
Question by:winzaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
p_yaroslav earned 40 total points
ID: 6378760
Hello!

Both statements appopriate,but....

If all big tables may increase in size up to 10 Gb,  extent size must be bigger (for example 1Gb). But if in this tablespace may appear tables with lower size, of course you need decrease uniform size to most small table in tablespace.

Also and for small tablespace.

AFAIK.. the best is 8-12 extents for every table.

Best regards!
Yaroslav.
0
 

Expert Comment

by:rcs2010
ID: 6379406
do you mean 1 table can grow up to 10gb a year, if so have you considered partitioning the table and using multiple tablespaces for it.

If you want a 10gb+ tablespace are you using multiple datafiles if so the extent size should fit into the datafile size as near as possilbe an even multiple of times
eg extent 128mb datafile size 2100mb. minimising the wasted space.

you may also need to consider recovery times for a tablespace this large.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question