Baskar .. you GEEK!!
That was very cool... geeky, but cool. THANKS!
Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]
-----Original Message-----
From: Baskar
[mailto:oracledba-ezmlmshield-x81334403.[Email address protected]
Sent: Tuesday, January 02, 2007 5:58 AM
To: LazyDBA Discussion
Subject: Try this one ...
Try this in SQL....
SELECT
TRANSLATE('?&[^:"\>::~::<#}"::^~||"::~+@::|}\[|#}\>[::+#?::"#~}::','~`!@
#$%^&*()=+\|]}[{><?/";:,','ABCDEFGHIJKLMNOPQRSTUVWXYZ
-') AS SURPRISE
FROM dual
-- Baskar
----- Original Message -----
From: "Chamberlain John "
<oracledba-ezmlmshield-x18203929.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, January 02, 2007 3:48 PM
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
>
>
DISCLAIMER
"The information contained in this e-mail message and/or attachments to
it may contain confidential or privileged information. If you are not
the intended recipient, any dissemination, use, review, distribution,
printing or copying of the information contained in this e-mail message
and/or attachments to it are strictly prohibited. If you have received
this communication in error, please notify us by reply e-mail or
telephone and immediately and permanently delete the message and any
attachments. Thank you"
---------------------------------------------------------------------
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