Hai pals, my doubt is that how to size a database in Oracle app for better storage and performance.<br>
The database is a very large production system.<br>
Can anybody give the approximate Parameter settings,<br>
Rollback seg settings, Redo log settings, Datafile settings,<br>
Tablespace settings etc.<br>
<br>
Suppose a table name MASTER which has high inserts, updates<br>
and some deletes which comprisises massive data in it.<br>
What would be the PCTFREE, PCTUSED, INITIAL, NEXT, PCTINCREASE for this table.<br>
<br>
Also if different scenarious for managing tables, indexes,<br>
rollback segments given with examples will be good.<br>
<br>
Awaiting for reply.<br>
<br>
The database is a very large production system.<br>
Can anybody give the approximate Parameter settings,<br>
Rollback seg settings, Redo log settings, Datafile settings,<br>
Tablespace settings etc.<br>
<br>
Suppose a table name MASTER which has high inserts, updates<br>
and some deletes which comprisises massive data in it.<br>
What would be the PCTFREE, PCTUSED, INITIAL, NEXT, PCTINCREASE for this table.<br>
<br>
Also if different scenarious for managing tables, indexes,<br>
rollback segments given with examples will be good.<br>
<br>
Awaiting for reply.<br>
<br>