Home » RDBMS Server » Performance Tuning » Regarding the sizing of disk for a database
Regarding the sizing of disk for a database [message #130111] Thu, 28 July 2005 03:59 Go to next message
hafeez_splendid
Messages: 15
Registered: June 2005
Location: india
Junior Member

hi xperts,

Can anyone tell me

1. Is there any formula to find out the total disk space needed for single database in oracle i.e., space for all the components including data, control file,redo logs, oracle s/w,system tablespaces,indexes etc.".

2 . How can we calculate the the sizes of each and every component .

Please suggest some document for this ASAP .
Re: Regarding the sizing of disk for a database [message #130125 is a reply to message #130111] Thu, 28 July 2005 05:49 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Hi, too much of a 'piece of string' question. There is no check list. If you download the documentation (check out tahiti.oracle.com), google, search AskTom.oracle, and search these forums, there's plenty of similar questions, all come up with pretty much the same answer i.e. "It all depends" Tom suggests benchmarking (testing)
Here is 1 such discussion @ AskTom
http://asktom.oracle.com/pls/ask/f?p=4950:8:2252818716744344253::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1229636448671
HTH
Jim
Re: Regarding the sizing of disk for a database [message #130148 is a reply to message #130111] Thu, 28 July 2005 07:51 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I agree with Jim. Here are some other links to check out:

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/design.htm#3488

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/build_db.htm#16369

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/dba.htm#sthref22

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/intro.htm#i68236
Previous Topic: How to better write this query to improved performance
Next Topic: High privileged% usage in Oracle on win2k server
Goto Forum:
  


Current Time: Fri May 27 17:00:39 CDT 2022