Re: proper database sizing ?
This is a complex and long thing to explain . You must read documents of oracle's own. And I can give you some links. www.searchdatabase.com http://ora.dbasupport.com www.geocities.com/csbabu/ www.orafans.com www.oraclenotes.com If you search these sites , you can find docs related to your problem I think. Bunyamin Karadeniz Database Support Engineer / Oracle,SQL Server HAVELSAN A.S. / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 23, 2001 12:15 PM Hello all, I've been pointed by the boss, to design our database application. I've a bit oracle background, it's just that I wanted to know what are the things that we need to notice when we do database sizing, and how to do the right calculation. Is there a documentation in the web site how to do that ? or someone can share his/her experience when sizing the database ? thanks a lot regards Herman Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: proper database sizing ?
Herman , Hope this helps some. first decide sizes of tables and indexes. avg_numberofrows*numberofrows*1.5(tables and clusters) avg_key_len*num_keys*1.5(indexes) then sum them to decide on tablespaces size. * always size for 1 year as a minimum.. Bunyamin K. Karadeniz / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 23, 2001 12:15 PM Hello all, I've been pointed by the boss, to design our database application. I've a bit oracle background, it's just that I wanted to know what are the things that we need to notice when we do database sizing, and how to do the right calculation. Is there a documentation in the web site how to do that ? or someone can share his/her experience when sizing the database ? thanks a lot regards Herman Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: proper database sizing ?
Hi, do you have any idea about how to reduce the space occupied by indexes on a large partitioned table. I have 8 indexes which occupy twice the space of data. -Original Message- From: Bunyamin K.Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: proper database sizing ? Herman , Hope this helps some. first decide sizes of tables and indexes. avg_numberofrows*numberofrows*1.5(tables and clusters) avg_key_len*num_keys*1.5(indexes) then sum them to decide on tablespaces size. * always size for 1 year as a minimum.. Bunyamin K. Karadeniz / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 23, 2001 12:15 PM Hello all, I've been pointed by the boss, to design our database application. I've a bit oracle background, it's just that I wanted to know what are the things that we need to notice when we do database sizing, and how to do the right calculation. Is there a documentation in the web site how to do that ? or someone can share his/her experience when sizing the database ? thanks a lot regards Herman Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Berindei Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: proper database sizing ?
try compress option. i have seen good results with multi column concateneated indexes. -- Tony JohnsonEmail : [EMAIL PROTECTED] Senior Database Administrator Voice : ( 480 ) 682 - 0849 GRID DATA, INC. Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Alex Sent: Friday, February 23, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, do you have any idea about how to reduce the space occupied by indexes on a large partitioned table. I have 8 indexes which occupy twice the space of data. -Original Message- From: Bunyamin K.Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: proper database sizing ? Herman , Hope this helps some. first decide sizes of tables and indexes. avg_numberofrows*numberofrows*1.5(tables and clusters) avg_key_len*num_keys*1.5(indexes) then sum them to decide on tablespaces size. * always size for 1 year as a minimum.. Bunyamin K. Karadeniz / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 23, 2001 12:15 PM Hello all, I've been pointed by the boss, to design our database application. I've a bit oracle background, it's just that I wanted to know what are the things that we need to notice when we do database sizing, and how to do the right calculation. Is there a documentation in the web site how to do that ? or someone can share his/her experience when sizing the database ? thanks a lot regards Herman Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Berindei Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tony Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).