Oracle-L: RE: Physical Database Layout

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Fri, 09 Aug 2002 09:58:28 -0800
Message-ID: <F001.004B0BE0.20020809095828@fatcity.com>

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

Have a good normalized design
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
--------------------------------------------------------------------