Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re:Query Tuning - Need Some Clarifiations

Re: Re:Query Tuning - Need Some Clarifiations

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Mon, 13 Aug 2001 23:41:27 -0700
Message-ID: <F001.00369603.20010813233521@fatcity.com>

Hi,As per your statement and the volume of transaction u have mentioned, I feel the db which I tuned is peanuts when compared to yours. But it was the requirement of the customer, I did what the customer wanted, that's it buddy.

Regards
venkat

--

On Mon, 13 Aug 2001 07:15:37  
 dgoulet wrote:

>The frequency at which you rebuild indexes and/or analyze the database is
>somewhat of a black art. My first question is what do you mean by "there are
>huge inserts,updates and deletes"? Our operational data store for our testers
>goes through something line 6 million inserts/updates/deletes per day and the
>maintenance is being done every 6 months without any performance degradation in
>between.
>
>Dick Goulet
>
>____________________Reply Separator____________________
>Author: "C.S.Venkata Subramanian" <csvenkata_at_lycos.com>
>Date: 8/10/2001 11:45 PM
>
>Dear Listers,
>My manager called me asked to look into the database problems in an IVR appln.
>The size of the database is around 1 gigs. The db stores information about
>customers, their phone nos and the relevant details. The mail problem was delay
>in playing a welcome prompt when the call connects to IVR, 6 queries are
>executed before playing the welcome message and there was a major delay when the
>customer needed some info. Basically it has to query the database and pass on
>the info the person who had called.
>
>First I got all the queries and checked the plan,time taken for each query. I
>found all the queries did a full table scan and after creating necessary indexes
>and analyzing the tables, I hit the right thing. Now the welcome message is
>played moment the call is connected to IVR and there is no time lag susequent
>queries.
>
>Using tkprof I checked the usage of indexes,CPU usage, time taken for
>parse,execution. All showing 0. The customer is happy now and also the manager.
>
>I have few doubts. It is an OLTP kind of scenario, there are huge
>inserts,updates and deletes, in what frequency I have to rebuild indexes and
>analyze the tables after rebuilding indexes.
>
>Since the db is in noarchivelog mode, it is advisible to put the same in
>archivelog mode.
>
>Any advices/suggestions are welcome.
>
>Regards
>C.S.Venkata Subramanian
>
>
>Get 250 color business cards for FREE!
>http://businesscards.lycos.com/vp/fastpath/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: C.S.Venkata Subramanian
> INET: csvenkata_at_lycos.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:
> INET: dgoulet_at_vicr.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).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_lycos.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).
Received on Tue Aug 14 2001 - 01:41:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US