| doubt in database [message #51711] |
Sun, 09 June 2002 22:32  |
Gurunathan
Messages: 3
Registered: June 2002
|
Junior Member |
|
|
Sir,
1) how to calculate database size in excisting datbase
2) how to set rollback segment(size) any calculations
3) if i suppose to create new database and i have to create one crore of data then how many datafile and user i have to set
4) how to set the temporary (size) and sga size
|
|
|
|
| Re: doubt in database [message #51716 is a reply to message #51711] |
Mon, 10 June 2002 08:03  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
1. Already created scripts to find out this information could be found Here
2. Some ideas and script are Here
3. Users are unlimited, datafiles could be limited to 2Gb each to make it easy for administrating.
4. SORT_AREA_SIZE & SORT_AREA_RETAINED_SIZE
SGA = (db_block_buffers*db_block_size) + log_buffer + shared_pool_size
Hope that helps,
clio_usa
OCP DBA 8/8i/9i
visit our web site Click Here
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
