>>The DBMS_STATS job will only pick up tables which have the MONITORING
flag set to "YES".
If the above statement is true,the statistics analyzed tables status of
monitoring should show "yes".But it is not showing "yes",its showing
"NO".Why?
-----Original Message-----
From: Chamberlain John
[mailto:oracledba-ezmlmshield-x18203929.[Email address protected]
Sent: Tuesday, January 02, 2007 3:48 PM
To: LazyDBA Discussion
Subject: RE: DBMS_STATS on Schema
The DBMS_STATS job will only pick up tables which have the MONITORING
flag set to "YES".
To identify un-monitored tables:
Select owner,table_name,monitoring from dba_tables
Where monitoring != 'YES';
To set monitoring:
Alter table owner.table_name monitoring;
HTH
John.
-----Original Message-----
From: Thiyagaraj
[mailto:oracledba-ezmlmshield-x78719588.[Email address protected]
Sent: 02 January 2007 10:14
To: LazyDBA Discussion
Subject: RE: DBMS_STATS on Schema
How do I find whether the tables or indexes are fragmented.And also this
defragmentation is belongs to 8i not 9i.Because,is is auto defrag in
9i.I hope so.
-----Original Message-----
From: Navendu
[mailto:oracledba-ezmlmshield-x12164111.[Email address protected]
Sent: Tuesday, January 02, 2007 3:29 PM
To: LazyDBA Discussion
Subject: Re: DBMS_STATS on Schema
This may be possibly beacuse there are tables or indexes which might be
fragmented. It is found that if there is fragmentation in the table or
indexes you wont be able to analyze the table or indexes untill you
defragment it or rebuild it....
"Thiyagaraj "
<oracledba-ezmlms
hield-x98072122.x
To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
01/02/2007 03:23
PM
Subject
DBMS_STATS on Schema
Hi,
I have enabled the automatic statistics gathering for all the schemas in
production database(oracle9.2)running on solaris10 using the dbms_stats
package and schedulled it through dbms_job. After the stats gathring job
is over , i used to check the last_analyzed column of dba_indexes for
all the tables and indexes of the schema.While doing so, i noticed that
the stats gathering was not executed on all the tables and indexes for
the schema.For an example,I have 300 tables and 333 indexes on a
schema,but while i query the dba_indexes for last_analyzed it lists only
288 tables and indexes only. Can any one tell me waht is happening and
why all the tables and indexes are not executed for the dbms_stats?
Thanks
-Raaj
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
Information in this email including any attachments may be privileged,
confidential and is intended exclusively for the addressee. The views
expressed may not be official policy, but the personal views of the
originator. If you have received it in error, please notify the sender
by return e-mail and delete it from your system. You should not
reproduce, distribute, store, retransmit, use or disclose its contents
to anyone.
Please note we reserve the right to monitor all e-mail communication
through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting Group
plc and are used under licence. British Sky Broadcasting Limited
(Registration No. 2906991), Sky Interactive Limited (Registration No.
3554332), Sky-In-Home Service Limited (Registration No. 2067075) and Sky
Subscribers Services Limited (Registration No. 2340150) are direct or
indirect subsidiaries of British Sky Broadcasting Group plc
(Registration No. 2247735). All of the companies mentioned in this
paragraph are incorporated in England and Wales and share the same
registered office at Grant Way, Isleworth, Middlesex TW7 5QD.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page