Auto Defragmentaion is done by SMON only if when the PCTINCREASE for a
table is more than the value 0.

Here, i am talking about the row CHAINING and MIGRATION

Thanks and Regards,
Navendu Badal Mohanty
IBS (Petroleum), Reliance Industries Ltd,
Petroleum House, 'A' wing, 2nd Floor, DAKC,
Navi Mumbai-400709
Ph(O) : 022-67270507
Mob(O): 09867687986



"Thiyagaraj "
<oracledba-ezmlms
hield-x78719588.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
01/02/2007 03:44
PM 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





Oracle LazyDBA home page