Re: Performance tuning of a system
Date: Wed, 5 Sep 2012 06:30:27 -0700
Message-ID: <CAENwkM6cMmCjxfc-FmWw=DjT5vnsArJCburaXHJj=Mdt9W+EUg_at_mail.gmail.com>
Hello Stefano,
I was facing same issues when starting at new company. However, without any metrics, it's hard to measure improvements. If you are not licensed for DIAG/TUNE pack, then statspack will do the trick. Might also considering downloading FREE version of http://www.confio.com/performance/oracle/ignite/
I have not used the FREE version but am using the licensed version.
-Michael.
On Mon, Sep 3, 2012 at 12:55 PM, Stefano Cislaghi <s.cislaghi_at_gmail.com>wrote:
> Hi all,
>
> I'm facing with a nice (at least for me) exercise of performance and
> tuning. I have an OLTP system must process each transaction in no more
> than 2 seconds. A transaction is not a single query but consists of
> some query and store procedure run from an application server. Almost
> 98% of this complete in less than 2 second.
> The main concern is that the system is accessed also by third parties
> application, mainly for enquiries but also for updates. The DBA has
> never been involved in the evaluation of DML done by third parties
> applications and there is
>
> Now I would like, as starting point, to trace for 24hrs all queries
> done by user THIRDPARTYAPP1 and THIRDPARTYAPP2 and its duration in
> order to understand if some query run by these application might in
> some case impact the performance of the database; also this may offer
> an opportunity of review cause there is no complete list of which
> queries are done by other external applications.
> Moreover any other hints is well accepted.
>
> Database is 11.2.0.2 under Linux.
>
> Thanks
> Ste
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 05 2012 - 08:30:27 CDT