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.

You can create the table partition (partition by range). The range can be defined for a 6 month period.

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.

Will oracle 10g standard edition supports partition by range?




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?

>> 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

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:

Materialized views are also available only at the Enterprise Edition level of licensing.