Re: High "cursor: pin S" wait in BATCH Transaction Type on NON-RAC Database

Hi,

What cursor_sharing parameter is set to ? Did you try to play with it ? Also - check out bug#6623947 - unfortunately it's unpublished so you need to work through customer support.

--romas

On 2/24/08, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
>
> Folks
>
> During a Benchmark Run of a BATCH Transaction Type, High "cursor: pin S"
> wait is seen on INSERTs (some info below) on a NON-RAC Database
>
> Respective Table has 64 Hash partitions. It has 2 indexes only, both of
> which are LOCALLY Prefixed Parrtitioned with 64 hash partitions too.
>
> Qs. How is this issue to be approached?
>
> Oracle 10.2.0.3
> Solaris 10
>
> Cheers & Thanks
>
> Vivek
>
>

--
http://www.freelists.org/webpage/oracle-l