Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locked Gather Stats Jobs

Status
Not open for further replies.
tekpr00

tekpr00

IS-IT--Management
Jan 22, 2008
186
CA
Hello,

Is there a select statement that will check the lock status of the gather statistics job in the non-system tables?
Please let me know where I can get an example.

Cheers.
 
Sort by date Sort by votes
Please note that I am using Oracle 11g.
 
Upvote 0 Downvote
select table_name, OBJECT_TYPE, stattype_locked from user_tab_statistics where table_name != '%sys%'

no rows selected
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

billo102
  • Locked
  • Question
stats collection on DG affects standby database
Replies
0
Views
141
billo102
billo102
sa0309
  • Locked
  • Question
Tables Stats not updating
Replies
5
Views
137
garani
garani
tekpr00
  • Locked
  • Question
Locked Gather Stats Jobs
Replies
1
Views
33
karluk
karluk
dpafumi
  • Locked
  • Question
Table Collect Stats
Replies
1
Views
43
carp
carp
mwolf00
  • Locked
  • Question
Fixing Jobs with Time 1
Replies
10
Views
79
carp
carp

Part and Inventory Search

Sponsor

Back
Top