set it up under cron to run hourly and be done with it.....
----- Original Message -----
From: "jayaprakash"
<oracledba-ezmlmshield-x78159523.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 31, 2006 10:35 AM
Subject: RE: Statspack?????????????????????????


>
> Fine,
>
> Its asking for the snapshot begin id and snap shot end id...........
>
> And iam able to generate the statspack report now...
>
> But I want to execute this in hourly basis in shedular task...
>
> How it will get the snap id's now..............................
>
>
>
>
>
>
> Thanks & Regards,
> S.jaya
> Database Management
> Wipro Infotech | 146-147, Metagalli Industrial Area, Metagalli, Mysore
> 570016 | Tel: +91 0821- 3983026
>
>
> -----Original Message-----
> From: Hans
> [mailto:oracledba-ezmlmshield-x28654601.[Email address protected]
> Sent: Tuesday, October 31, 2006 6:54 PM
> To: LazyDBA Discussion
> Subject: RE: Statspack?????????????????????????
>
>
>
> 1. Install statspack in the database (as INTERNAL run
> $ORACLE_HOME/rdbms/admin/spcreate.sql)
>
> 2. Execute a snapshot and an hour later another snapshot
>
> 3. run spreport
>
>
> Hans
>
>
> -----Original Message-----
> From: jayaprakash
> [mailto:oracledba-ezmlmshield-x81366731.[Email address protected]
> Sent: dinsdag 31 oktober 2006 13:11
> To: LazyDBA Discussion
> Subject: Statspack?????????????????????????
>
>
>
> Can any body tell that how to generate the statspack report ....an
> hourly basis(scheduled)
>
>
>
> Thanks & Regards,
> S.Jay
> Database Management
>
>
>
> -----Original Message-----
> From: B Robertson (HPIT) [mailto:oracledba-ezmlmshield-x22363355.[Email
> address protected]
>
> Sent: Tuesday, October 31, 2006 5:15 PM
> To: LazyDBA Discussion
> Subject: To check tablespace is Temp Tablespace or Not !
>
>
> select tablespace_name, contents from dba_tablespaces;
>
> If the contents column shows 'TEMPORARY' then those are Temp tablespace.
>
> Regards
> Robertson
>
> -----Original Message-----
> From: jayaprakash
> [mailto:oracledba-ezmlmshield-x4132282.[Email address protected]
>
> Sent: Tuesday, October 31, 2006 3:33 PM
> To: LazyDBA Discussion
> Subject: RE: Dropping the tables
>
>
> How to find how many temp tablespace are ther in database?
>
> Thanks in advance,
>
> Thanks & Regards,
> S.Jayaprakash,
> Database Management
>
>
>
> -----Original Message-----
> From: Ezekiel Filane [mailto:oracledba-ezmlmshield-x7955895.[Email
> address protected]
> Sent: Tuesday, October 31, 2006 3:20 PM
> To: LazyDBA Discussion
> Subject: RE: Dropping the tables
>
>
> Hi Raj
>
> Create a script
>
> Set lines 1200 pages 1200
>
> Spool drop_tables.lst
>
> Select 'drop table '|| owner || '.' || table_name || ';'
> from user_tables
> WHERE owner=XYZ
> /
> @drop_tables.lst
>
>
> Thanks
> Ezekiel
>
>
> -----Original Message-----
> From: Raj
> [mailto:oracledba-ezmlmshield-x93527208.[Email address protected]
> Sent: 31 October 2006 08:49 AM
> To: LazyDBA Discussion
> Subject: Dropping the tables
>
>
>
> Hello All,
>
> Kindly let me know how can we drop all the tables owned by a user
> without dropping the user.
>
>
> Kind regards,
> Raj
>
>
> ---------------------------------------------------------------------
> 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
>
> ------------------------------------------------------------------------
> --------
> Please note: This e-mail and its contents are subject to a disclaimer
> which can be viewed at http://www.woolworths.co.za/disclaimer. Should
> you be unable to access the link please e-mail [Email address protected]
>
> and a copy of the disclaimer will be e-mailed to 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
>
>
>
>
> The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s)
> and may contain proprietary, confidential or privileged information. If
> you are not the intended recipient, you should not disseminate,
> distribute or copy this e-mail. Please notify the sender immediately and
> destroy all copies of this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
> www.wipro.com
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
> The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s)
> and may contain proprietary, confidential or privileged information. If
> you are not the intended recipient, you should not disseminate,
> distribute or copy this e-mail. Please notify the sender immediately and
> destroy all copies of this message and any attachments.
>
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
>
> www.wipro.com
>
>
> ---------------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> ATTENTION:
> The information in this electronic mail message is private and
> confidential, and only intended for the addressee. Should you
> receive this message by mistake, you are hereby notified that
> any disclosure, reproduction, distribution or use of this
> message is strictly prohibited. Please inform the sender by
> reply transmission and delete the message without copying or
> opening it.
>
> Messages and attachments are scanned for all viruses known.
> If this message contains password-protected attachments, the
> files have NOT been scanned for viruses by the ING mail domain.
> Always scan attachments before opening them.
> -----------------------------------------------------------------
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
> The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s) and
> may contain proprietary, confidential or privileged information. If you
> are not the intended recipient, you should not disseminate, distribute or
> copy this e-mail. Please notify the sender immediately and destroy all
> copies of this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email.
>
> www.wipro.com
>
>
> ---------------------------------------------------------------------
> 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