Re: SQL *Plus

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 6 Apr 2000 18:53:36 +0200
Message-ID: <955043352.6182.0.pluto.d4ee154e@news.demon.nl>

No,
Guessing: someone ANALYZED your tables, and now you are using the cost based optimizer instead of the rule based optimizer. To check whether statistics are present run a select on user_tables and check for columns like
num_rows, empty_blocks, average_row_len etc. If they are non null your table has been analyzed.
To delete the statistics
issue exec dbms_utility.analyze_schema('<schemaname>','DELETE')

Hth,

Sybrand Bakker, Oracle DBA

Jerry <jpsowell_at_bellsouth.net> wrote in message news:Ff2H4.713$tk.1756_at_news1.mco...
> What would casuse an SQL script to run very slowly with
> SQL *Plus. Ran this script before and it ran fine, now it is
> taking five or six times longer. Could environment variables
> have changed.
>
>
Received on Thu Apr 06 2000 - 11:53:36 CDT