Mas Ujang, ini hasil awr report nya, kalau melihat awar nya tidak ada problem thp cache fusion, so saya masih bingung apa yang menyebabkan kelambatan thp aplikasi saya, btw untuk mengetahui ful table scan apa tidak itu dari mana dan bagaimana cara menghindarkan pemakaian full table scan beserta pemakaian index yang efektif.
thx atas segala bantuan dan pencerahan nya. -- Tks & Best regards, Andi EP IT Engineer mailto:[EMAIL PROTECTED] Thursday, March 15, 2007, 9:29:31 AM, you wrote: > X-Spam-Checker-Version: SpamAssassin 3.1.0 (2005-09-13) on pop3.ogs-id.com > X-Spam-Level: *** > X-Spam-Status: No, score=3.3 required=5.0 > tests=HTML_MESSAGE,HTML_TINY_FONT, > INVALID_DATE,TW_RR autolearn=no version=3.1.0 > Received: (qmail 18211 invoked by uid 1009); 15 Mar 2007 02:38:59 -0000 > Received: from unknown (HELO tiger) (172.26.5.53) > by puma.ogs-id.com with SMTP; 15 Mar 2007 02:38:59 -0000 > Received: from tiger (localhost.localdomain [127.0.0.1]) > by tiger (Postfix) with ESMTP id 942AA1EFD > for <[EMAIL PROTECTED]>; Thu, 15 Mar 2007 10:23:26 +0700 (WIT) > Received: from n5c.bullet.sp1.yahoo.com (n5c.bullet.sp1.yahoo.com > [69.147.64.187]) > by tiger (Postfix) with SMTP id 8A4517FA > for <[EMAIL PROTECTED]>; Thu, 15 Mar 2007 10:23:20 +0700 (WIT) > Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys > DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lima; d=yahoogroups.com; > > b=tZdyXylgDC27JyEfVWFcECc4FASJdyrwxkxgqApb4wGTLuBCjHPvfZhaxg4tl5N81H1YdXZUBp4wEk5FfHeABvfM+iqnFz1Eoro+dgQGCaFajF3njqEivvZfvlVN5zoB; > Received: from [216.252.122.217] by n5.bullet.sp1.yahoo.com with > NNFMP; 15 Mar 2007 02:29:34 -0000 > Date: 14 Mar 2007 19:29:34 -0700 > Received: from [66.218.69.4] by t2.bullet.sp1.yahoo.com with > NNFMP; 15 Mar 2007 02:29:34 -0000 > Received: from [66.218.67.115] by t4.bullet.scd.yahoo.com with > NNFMP; 15 Mar 2007 02:29:34 -0000 > X-Yahoo-Newman-Id: 3213225-m13884 > X-Sender: [EMAIL PROTECTED] > X-Apparently-To: [email protected] > Received: (qmail 14196 invoked from network); 15 Mar 2007 02:29:32 -0000 > Received: from unknown (66.218.66.68) > by m47.grp.scd.yahoo.com with QMQP; 15 Mar 2007 02:29:32 -0000 > Received: from unknown (HELO ug-out-1314.google.com) (66.249.92.169) > by mta11.grp.scd.yahoo.com with SMTP; 15 Mar 2007 02:29:32 -0000 > Received: by ug-out-1314.google.com with SMTP id 80so185778ugb > for <[email protected]>; Wed, 14 Mar 2007 19:29:31 -0700 > (PDT) > DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; > d=gmail.com; s=beta; > > h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; > > b=I7pxeGCY3xZCl2wBn3Wh81djv9aPqa+u7B/b5QIApxOlWxJ2TWKcb8oc5djiQ2O5U0b0W1ukLnRhDdMab9IQN4AHqOQ2PF/CfFUQQHPM8NfrACIy9RKIAEpDSVvgic6GALpCaPnlg9ZJBPE1v3Tj8Qacx9jUhA4w8MiUmiQfUHA= > Received: by 10.67.119.9 with SMTP id w9mr2043690ugm.1173925771066; > Wed, 14 Mar 2007 19:29:31 -0700 (PDT) > Received: by 10.67.40.2 with HTTP; Wed, 14 Mar 2007 19:29:31 -0700 (PDT) > Message-ID: > <[EMAIL PROTECTED]> > To: [email protected] > In-Reply-To: <[EMAIL PROTECTED]> > References: <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]> > X-Originating-IP: 66.249.92.169 > X-eGroups-Msg-Info: 1:0:0:0 > From: "Ujang Jaenudin" <[EMAIL PROTECTED]> > Sender: [email protected] > MIME-Version: 1.0 > Mailing-List: list [email protected]; contact > [EMAIL PROTECTED] > Delivered-To: mailing list [email protected] > List-Id: <indo-oracle.yahoogroups.com> > Precedence: bulk > List-Unsubscribe: <mailto:[EMAIL PROTECTED]> > Date: Thu, 15 Mar 2007 09:29:31 +0700 > Subject: Re: Re[4]: [indo-oracle] Real Application Cluster > Reply-To: [email protected] > X-Yahoo-Newman-Property: groups-email-ff > Content-Type: multipart/alternative; > boundary="qihAq2FWfQAL5xwUUKE6EblRWlvLAtWvyI310m3" > X-AV-Checked: ClamAV using ClamSMTP > On 3/14/07, Andi EP <[EMAIL PROTECTED]> wrote: >> Pak Tomi, >> >> Yang dimaksud dengan Application Partitioning itu bagaimana? ada URL >> yang bisa saya baca, > di oracle docs, cari aja managing oracle services, dan mengenai load > balancing and transparent application failover (TAF). > logically kita bisa buat application partitioning by using services > ataukah manual di sisi TNS. >> terus untu aplikasi, aplikasi tsb bisa berjalan dengan sangat cepat di >> non-rac (konfigurasi HW sama dengan HW RAC) dan saya sudah test. dan itu >> berjalan tanpa hambatan sama >> sekal > kalau asumsi sql tuning nya bagus, ya tinggal check & perform tuning > di sisi RAC nya. > kalau bisa sih paste kan hasil snapshot or awrrpt top5 consumer dan > wait event detailnya... > ujang > [Non-text portions of this message have been removed]
