Help - Search - Members - Calendar
Full Version: Oracle partitioning
Oracle DBA Forums > Oracle > Oracle Forum
sarankaran_y@yahoo.co.in
Hi all,

Our production database growth is 30 MB per day.Client need the requirement to show the 6 months transaction data.Remaining will be shown when user demands.

We are using oracle 10g standard edition.Is there any other way to partition the 6 months data for performance tuning.
HelloRavi
You can create the table partition (partition by range). The range can be defined for a 6 month period.
SteveC
You need to license the Enterprise Edition and include the partitioning option. If you have a 4 cpu server, that is 100 (25 users per cpu) seats, and then you need 100 partitioning seats as that is licensed at the same level as the server.
sarankaran_y@yahoo.co.in
QUOTE (HelloRavi @ Jul 30 2008, 07:36 AM) *
You can create the table partition (partition by range). The range can be defined for a 6 month period.



Will oracle 10g standard edition supports partition by range?

QUOTE (SteveC @ Jul 30 2008, 07:41 AM) *
You need to license the Enterprise Edition and include the partitioning option. If you have a 4 cpu server, that is 100 (25 users per cpu) seats, and then you need 100 partitioning seats as that is licensed at the same level as the server.



Client will not agree to spend on this.Any other alternate?

Parttion is needed for this size of database?When the parttion will be useful?
burleson
>> Will oracle 10g standard edition supports partition by range?

No, you need EE to get partitioning:

http://www.dba-oracle.com/art_so_oracle_st...ise_edition.htm

***********************************************************************
>> Parttion is needed for this size of database?

You tell me. Is full-scan performance suffering?

***********************************************************************

>> Client will not agree to spend on this.

I would find another job. If they won't spend to do the job right, why would anybody want to work there?

***********************************************************************
>> Any other alternate?

Sure you can do manual partitioning, the old-fashioned way like we did in Oracle7. It's done by spreading files across spindles and giving your "partitions" unique names. You can also cache your data with SSD, but that costs money too. Read the chapter in my book on I/O load balancing:

http://www.rampant-books.com/book_2005_1_a...tive_tuning.htm
sarankaran_y@yahoo.co.in
QUOTE (burleson @ Jul 30 2008, 11:17 AM) *
Sure you can do manual partitioning, the old-fashioned way like we did in Oracle7. It's done by spreading files across spindles and giving your "partitions" unique names. You can also cache your data with SSD, but that costs money too. Read the chapter in my book on I/O load balancing:

http://www.rampant-books.com/book_2005_1_a...tive_tuning.htm


materialized view ?

I read from one of your article in http://www.dba-oracle.com/art_9i_mv.htm

Without materialized views you may see unnecessary repeating large-table full-table scans, as summaries are computed, over and over:
SteveC
Materialized views are also available only at the Enterprise Edition level of licensing.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.