RE: SQL Help

RE: SQL Help

 

  

Run $ORACLE_HOME/rdbms/admin/sppurge

-----Mensaje original-----
De: hen.ngo [mailto:oracledba-ezmlmshield-x14271376.[Email address protected]
Enviado el: jueves, 29 de mayo de 2008 16:52
Para: LazyDBA Discussion
Asunto: RE: SQL Help

I need to know how to purge STATPACK snapshots that is older than a month.
Can you help ? Thanks

-----Original Message-----
From: Michael Peel
[mailto:oracledba-ezmlmshield-x98527945.[Email address protected]
Sent: Thursday, May 29, 2008 10:22 AM
To: LazyDBA Discussion
Subject: RE: SQL Help

Could it be the space in v.last_update_d ate, or is that just the way your
code's copied in?

Michael Peel


-----Original Message-----
From: Nellakanti Sunitha
[mailto:oracledba-ezmlmshield-x19441856.[Email address protected]
Sent: 29 May 2008 15:18
To: LazyDBA Discussion
Subject: SQL Help

Hi,

Is there something wrong with this SQL, I get message 'Keyword not
found'

select z.USER_PROFILE_OPTION_NAME Profile,
nvl(v.PROFILE_OPTION_VALUE,'Replace with non-virtual URL') Value,
v.last_update_d ate Updated
from fnd_profile_options t, fnd_profile_option_values v,
fnd_profile_options_tl z
where (v.PROFILE_OPTION_ID (+) = t.PROFILE_OPTION_ID)
and (z.PROFILE_OPTION_NAME = t.PROFILE_OPTION_NAME)
and (t.PROFILE_OPTION_NAME in
('APPS_FRAMEWORK_AGENT','WF_MAIL_WEB_AGENT'));

Thanks
Sunitha


***
This electronic mail message, including attachments, is intended only for
the person or entity to which it is addressed and may contain confidential
and/or privileged material. Any unauthorized use, review, disclosure,
distribution, or actions taken in reliance on the contents of this
information, is prohibited. If you received this e-mail in error and are not
the intended recipient, please notify me immediately by telephone or reply
e-mail and destroy all copies of the original message.
***



---------------------------------------------------------------------
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


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************



---------------------------------------------------------------------
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 message is intended for the named addressee only and may not be disclosed to or used by anyone else, nor may it be copied in any way.

The contents of this message and its attachments are confidential and may also be subject to legal privilege. If you are not the named addressee and/or have received this message in error, please advise us by e-mailing [Email address protected] and delete the message and any attachments without retaining any copies.

Internet communications are not secure and COLT does not accept responsibility for this message, its contents nor responsibility for any viruses.

No contracts can be created or varied on behalf of COLT Telecommunications, its subsidiaries or affiliates ("COLT") and any other party by email Communications unless expressly agreed in writing with such other party.

Please note that incoming emails will be automatically scanned to eliminate potential viruses and unsolicited promotional emails. For more information refer to www.colt.net or contact us on +44(0)20 7390 3900.


Oracle LazyDBA home page