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!

Table Scan in stats$user_log

user10999742Feb 1 2012 — edited Feb 1 2012

Hi,

My database is making much table scans on stats$user_log, this is normal?
I see in the Oracle EM Console - Dabase - SID - Instance - Sessions - Double click in SID, open an "Long Operations" tab a progress bar with this table stats$user_log.
Is many users is doing this scan.

P.S.:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
OEL 5: Linux db01 2.6.32-100.0.19.el5 #1 SMP Fri Sep 17 17:51:41 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 29 2012

Added on Feb 1 2012

#general-database-discussions

14 comments

980 views