Re: Reading sequences is much slower in AIX 6.1 than Linux
Date: Mon, 10 Oct 2011 23:34:22 +0200
Message-ID: <CAJ2-Qb9bUg3UTqcJJLDws_Fsv_J_=gwLfhSP2b+U7pXgY0T_cg_at_mail.gmail.com>
oracle support opened a bug but not AIX related, it is a RAC bug, gettings sequences are much much slower in 11.2.0.2 RAC currently under development investigation!
On Thu, Sep 29, 2011 at 8:34 AM, Chitale, Hemant Krishnarao < Hemant.Chitale_at_sc.com> wrote:
> ** **
>
> Can you check to see if the cached values are being “lost” frequently (i.e.
> the sequence is not pinned and is getting aged-out) ?****
>
> ** **
>
>
> Hemant K Chitale
>
> ****
>
> ** **
>
> *From:* LS Cheng [mailto:exriscer_at_gmail.com]
> *Sent:* Thursday, September 29, 2011 2:31 PM
> *To:* Chitale, Hemant Krishnarao
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Reading sequences is much slower in AIX 6.1 than Linux****
>
> ** **
>
> ops forgot to mention that, cache size is 500000 and noorder
>
> Thanks****
>
> On Thu, Sep 29, 2011 at 7:30 AM, Chitale, Hemant Krishnarao <
> Hemant.Chitale_at_sc.com> wrote:****
>
> What are the CACHE_SIZE and ORDER_FLAG (sometimes used in RAC) for the
> SEQUENCE_S1 sequence in the two environments ?
>
>
> Hemant K Chitale****
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of LS Cheng
> Sent: Thursday, September 29, 2011 1:17 PM
> To: Oracle Mailinglist
> Subject: Reading sequences is much slower in AIX 6.1 than Linux
>
> Hi all
> We have some batch processes which need to meet some SLA, the execution
> time
> should exceed certaint threshold of time. The processes are mainly
> insert.... select sequence, ... from table.****
>
> ...deleted......
>
>
>
> ****
>
> ** **
>
> This email and any attachments are confidential and may also be privileged.
> If you are not the addressee, do not disclose, copy, circulate or in any
> other way use or rely on the information contained in this email or any
> attachments. If received in error, notify the sender immediately and delete
> this email and any attachments from your system. Emails cannot be guaranteed
> to be secure or error free as the message and any attachments could be
> intercepted, corrupted, lost, delayed, incomplete or amended. Standard
> Chartered PLC and its subsidiaries do not accept liability for damage caused
> by this email or any attachments and may monitor email traffic.
>
> Standard Chartered PLC is incorporated in England with limited liability
> under company number 966425 and has its registered office at 1 Aldermanbury
> Square, London, EC2V 7SB.
>
> Standard Chartered Bank ("SCB") is incorporated in England with limited
> liability by Royal Charter 1853, under reference ZC18. The Principal Office
> of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In
> the United Kingdom, SCB is authorised and regulated by the Financial
> Services Authority under FSA register number 114276.
>
> If you are receiving this email from SCB outside the UK, please click
> http://www.standardchartered.com/global/email_disclaimer.html to refer to
> the information on other jurisdictions.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 10 2011 - 16:34:22 CDT