Re: Slow prod DB

From: <michael_bialik_at_my-deja.com>
Date: Wed, 01 Sep 1999 22:33:38 GMT
Message-ID: <7qk9k1$ak2$1@nnrp1.deja.com>

Hi.

1. Did you imported the whole schema ( definitions and data ) or data rows only?
2. Post EXPLAIN of your statement.
3. Post tables and indexes definitions.
4. Are you using CBO or RBO? If RBO - EXPORT/IMPORT performs ANALYZE for tables. It may insert some incorrect data and CBO is going to use it. Try : SELECT * FROM USER_TABLES WHERE NUM_ROWS IS NOT NULL;

 Good luck. Michael.

In article <7qj6s0$f39$1_at_nnrp1.deja.com>,   John <jabliese_at_my-deja.com> wrote:
> We exported the data from production to test, and now the test db also
> takes forever.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 01 1999 - 17:33:38 CDT