Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I set PCTUSED and PCTFREE in Warehouse databases?

570355Apr 22 2011 — edited Apr 22 2011

Hi,

There are many Schemas in our database and some are used for OLTP and some others are used for Warehouse. Also our tablespaces are Local Managed.

Could you help me please how can I set PCTUSED and PCTFREE for Warehouses and OLTP.

What are your suggestions? What should be optimum?
DB version is 9.2.0.8.

thanks & regards

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2011

Added on Apr 22 2011

#9i, #data, #database, #dba, #export, #general-database-discussions, #installation, #oracle, #performance, #table

5 comments

965 views