Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

database slow after Index compute statistics

442562Nov 29 2006 — edited Nov 29 2006

Dear All,

Since 2 days back after executing Analyze Index compute objects to increase the response time some programs from my application have become very slow.
After seeing this behaviour I went ahead and did a Analyze table compute statistic again . Even after doing this the behaviour has remained the same . Some users have been complaining (becoz the slowness has effected only some tables and not the whole database).
I checked sys.v_$session_longops and got this output

OPNAME TARGET ELAPSED_SECONDS
NULL 53 596792483
NULL 53 596793670
¥Á 3248826740 596793669
NULL 53 596793624
NULL NULL 596800369
NULL 1 596796740
NULL 1732526816 596472777
Table Scan PO8.ACC_LEDGER 9
Table Scan PO8.INVENTORY_LEDGER 26
Sort Output NULL 7
Sort/Merge NULL 15
Sort/Merge NULL 66
Table Scan PO8.INVENTORY_LEDGER 12
Table Scan PO8.ACC_LEDGER 9
NULL 1725513472 0
NULL 3361240696 0
NULL 3361796632 0
NULL 22 596792484
NULL 1730819772 596800386
NBIAAT56020010ä (stale) obj# 3363169460 596800605
ýÐ 3506279036 596799303
NULL NULL 596800634

What could have happened.
In the ini I have set
optimizer mode = Choose
db_file_multiblock_read_count= 8

Sapna

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2006

Added on Nov 29 2006

#general-database-discussions

18 comments

824 views