Re: PeopleSoft Adhoc Queries in Oralce
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 27 Nov 2002 21:55:15 -0000
Message-ID: <3de53f49$0$9446$cc9e4d1f_at_news.dial.pipex.com>
Date: Wed, 27 Nov 2002 21:55:15 -0000
Message-ID: <3de53f49$0$9446$cc9e4d1f_at_news.dial.pipex.com>
usual stuff would be useful, namely the slow query, its explain plan, do you have adequate up to date stats.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "psivakumar" <psivakumar_at_rogers.com> wrote in message news:6ldE9.158865$oRV.83948_at_news04.bloor.is.net.cable.rogers.com...Received on Wed Nov 27 2002 - 22:55:15 CET
> Recently upgraded to PeopleSoft 8.3 running in Oracle 8.1.7 (Windows
2000).
> Some of the queries worked in fine 7.5 in Oracle 8.1.6 (HPUX). (Please do
> not ask why we migarted from UNIX to Windows. (management decision?) )
>
> We did retrofit the queries for new table structures and views. However,
the
> performance is HORRIBLE. I would like to hear some experience from the
field
> where somebody went through the same pain.
>
> Any suggesstions and/or hints
>
>