OraFAQ Forum: Performance Tuning » Regarding the sizing of disk for a database

Home » RDBMS Server » Performance Tuning » Regarding the sizing of disk for a database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regarding the sizing of disk for a database [message #130111]

Thu, 28 July 2005 03:59

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 .

Report message to a moderator

Re: Regarding the sizing of disk for a database [message #130125 is a reply to message #130111]

Thu, 28 July 2005 05:49

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

Report message to a moderator

Re: Regarding the sizing of disk for a database [message #130148 is a reply to message #130111]

Thu, 28 July 2005 07:51

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

Report message to a moderator

Previous Topic:	How to better write this query to improved performance
Next Topic:	High privileged% usage in Oracle on win2k server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 16:17:07 CST 2024