| rollback segment allocation problem [message #51732] |
Tue, 11 June 2002 01:55  |
Gurunathan
Messages: 3
Registered: June 2002
|
Junior Member |
|
|
Dear sir,
1) i have 10GB database i want to create rollback segment how many rollback segment i have to create and how many users can set with that any calculations - to set appropriate size of database
2)Also i want to create Temporary tablespace how much
space allocate (sort_area) how much % to allocate
for 10Gb database
3) How much space i have initiallize in SGA for 10GB
DATABASE..(WHAT IS THE SIZE SHOULD BE THERE ANY CALCULATIONS)
4) HOW MANY USERS CAN CREATE AND HOW MUCH TABLESPACE CAN CREATE FOR 10GB DATABASE
|
|
|
|
| Re: rollback segment allocation problem [message #51747 is a reply to message #51732] |
Tue, 11 June 2002 15:27  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
1. Sizing giudelines are described in details Here and Here
2. It depends of your queries. Queries performing sorts, ORDER BY, UNION, MINUS needs more temp tablespace. Also every user will need as least 5Mb for PGA. Start with 1Mb SORT_AREA_SIZE and monitor to see if sorts memory/disk ratio is increasing.
3. For 64-bit Oracle there is no limit, for 32-bit not more than 2.1 Gb. Again you have to tune start with 450 Mb and monitor.
4. Users and Roles - Maximum - 2,147,483,638
Tablespaces - Maximum - 64,000
Hope that helps,
clio_usa
OCP DBA 8/8i/9i
Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
