Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sizing a database in Oracle

Sizing a database in Oracle

Sizing a database in Oracle

Hai pals, my doubt is that how to size a database in Oracle app for better storage and performance.
The database is a very large production system.
Can anybody give the approximate Parameter settings,
Rollback seg settings, Redo log settings, Datafile settings,
Tablespace settings etc.

Suppose a table name MASTER which has high inserts, updates
and some deletes which comprisises massive data in it.
What would be the PCTFREE, PCTUSED, INITIAL, NEXT, PCTINCREASE for this table.

Also if different scenarious for managing tables, indexes,
rollback segments given with examples will be good.

Awaiting for reply.

RE: Sizing a database in Oracle

Go to the Oracle Metalink site and look up a note in their tech support system.
The note's name is Space the Final Frontier and the number is Note 10640.1.
Anyone can get account there that has a CSI that you should have gotten when you purchased your Oracle software.

RE: Sizing a database in Oracle

Please ,
if you got this note (Note 10640.1), send it to me  (my e-mail:ramdani1@mpsa.com).

RE: Sizing a database in Oracle

you can find all detail in oracle administrator's guide in the table creation part.One can not say what should be the parameter values it depends on how many rows there will be how many update how many deletes , what is the siez of the block DB_BLOCK_SIZE in init(sdi).ora. How many initial transactions and max transactions should be allowed on the block. How ever u can find a example in the oracle administrator's guide go for it.

RE: Sizing a database in Oracle

What about backgroung process.................?
what about memery......................

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close