Re: Database screaching to a halt and cant figure it out. Any advice??

In SQL*Plus you can use the command show parameters to see what the init.ora parameters are set to. That way you'll know whether you're using cost-based optimization, what the size of your SGA is, etc. etc.

Van

"The NiteFrog.-" <nitefrog_at_yahoo.com> wrote in message news:397f4c72.833479219_at_news.mindspring.com...
> Hello Niall,
>
> Thank you for the advice. NOw I have an idea of what I need to do.
> I am new to this so it is kinda a rough go.
>
> Thanks again,
>
> Kev.-
>
> On Wed, 26 Jul 2000 18:44:48 +0100, "Niall Litchfield"
> <niall.litchfield_at_doial.pipex.com> wrote:
>
> >"The NiteFrog.-" <nitefrog_at_yahoo.com> wrote in message
> >news:397ee14e.806050839_at_news.mindspring.com...
> >> Hello Sybrand,
> >>
> >> Thank you for your response. The problem is that the DBA we are
> >> working with is not very helpful and it is hard to get an answer
> >> from him.
> >>
> >> The version of oracle for production is:
> >> Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> >> running on NT platform.
> >>
> >> Any query that I run either simple or complex takes forever and
> >> a day to come back in the production enviroment.
> >>
> >
> >Hi
> >
> >One reason the DBA maybe 'not very helpful' might be that you are not
 giving
> >enough information. In the first message you posted an example query
 which
> >took 15 seconds and said that the environments were the same. However
 your
> >followup message has two different explain plans utilising different
 indexes
> >and is for a new select statement.
> >
> >I conclude
> >
> >1) The two environments are different.
> >
> >2) Your problem definition is somewhat loose.
> >
> >For message one it seemed to me that you perhaps had an opportunity to
 use
> >bitmap indexes, since you were on 8i and has column names isX with
 values
> >of 0 & 1 suggesting boolean fields. If you have a frequently queried
 columns
> >with low cardinality which is never (or rarely) updated then you should
> >definitely consider the use of bitmap indexes.
> >
> >However, having now read message two it is clear that different execution
> >plans are being chosen for the same query and therefore the environments
 are
> >not the same. At the very least an analyze may need to be done if the
 cost
> >based optimiser is being used.
> >
> >I'd therefore look at getting the dev environment as close as poss to
 live
> >as a first step.
> >
> >HTH
> >
> >
> >--
> >Niall Litchfield
> >Oracle DBA
> >Audit Commission UK
> >
> >
>
Received on Thu Jul 27 2000 - 00:00:00 CDT