Re: Physical Database Layout

Hi Naveen,

Thanks for taking the time out to reply. Yes I agree most of the programmers do not bother even to optimize the queries they write, but things get a tad complicated when you are responsible for an enterprise application and you are concerned with each aspect of the system.

I understand optimization is an iterative process, but unless the physical layout of the DB itself is not right, the iterative cycle of optimization will not result in too much of an improvement.

What i am looking for is a set of directives that need to be considered during the physical design, such as whether to use local tablespaces, the number of rollback segments, db block size, etc..

Thanks,
Manav.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, August 09, 2002 10:58 AM

> Hi Manav,
>
> I'm not a guru, but a programmer turned DBA. I appreciate your concern for
> optimum DB design, because most of the programmers don't even care for the
> optimization of SQL Queries they write.
>
> Oracle gives you a lot of control over the way you want to optimize your
DB,
> but that also means that you have to learn a lot of things(a lot!).
>
> The gurus in this list are so experienced that they know the Paramemters
and
> other things like people like you and me remember our friends' phone
numbers.
> It all comes with experience.
>
> As for you, I'll suggest that if you can't get a DBA and want to do a few
> things yourself(which a DBA should be doing), you read some material on
> Oracle Architecture and basics.
>
> As a programmer, all you can do is
>
> 1. Have a good normalized design
> 2. Write your SQL queries properly
>
> Apart from that, most of the optimization is a DBAs job and you should
stick
> to whatever programming language you work on and learn more about that.
>
> There is lots of tuning material available on the net also. Just read it
and
> skip whatever you don't understand(you'll not understand most of them, and
so
> do I !!!!)
>
> Good Luck,
> Naveen
>
> -----Original Message-----
> Sent: Friday, August 09, 2002 6:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> Unlike the gurus on the list, I'm just a programmer who happens to ensure
> the DB structure is correct/valid, should hold its ground if an external
> (read customer's) DBA goes through it with a microscope. Its not always
> possible to have a full time DBA suggesting the layout, and moreover, most
> of the programmers are expected to 'know' RBDMS anyway!
>
> I was hoping if the gurus here can provide me a list of parameters to be
> taken into consideration (while doing the database design) to ensure that
> the phsycial database layout itself is optimized for performance. Or if
> anyone can just point me in the right direction, it'll help me a lot.
>
> Btw, Oracle has more than 200 initialization parameters, all affecting its
> working in some or the other way. Do the gurus keep all of them at their
> finger-tips?
>
> TIA,
> Manav.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Manavendra Gupta
> INET: manav_at_zycus.com
>
> 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: ListGuru_at_fatcity.com (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: Naveen Nahata
> INET: naveen_nahata_at_mindtree.com
>
> 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: ListGuru_at_fatcity.com (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: Manavendra Gupta
  INET: manav_at_zycus.com

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: ListGuru_at_fatcity.com (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).