Re: orasrp SQL*Net message to client as non-idle event

begin
....
dbms_monitor.session_trace_enable()
end;
/

or alternatively

exec dbms_monitor.serv_mod_act_trace_enable('stuff to identify','future interesting sessions ','goes here');

On Mon, Feb 8, 2010 at 9:40 AM, Dunbar, Norman < norman.dunbar_at_environment-agency.gov.uk> wrote:

> Morning Karl,
>
> >> Thanks for clarifying that Mark :) yeah it could be possible, better
> >> if I have put a logon trigger
>
> Or even something like:
>
> begin
> dbms_support.start_trace(true, true);
> end;
> /
>
> -- SQL HERE
>
> begin
> dbms_support.stop_trace;
> end;
> /
>
> But this depends on having the DBMS_SUPPORT package created (start
> ?/rdbms/admin/dbmssupp.sql as sys) and execute access granted to your
> user.
>
>
> Cheers,
> Norman.
>
>
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else. We have
> checked this email and its attachments for viruses. But you should still
> check any attachment before opening it. We may have to make this message and
> any reply to it public if asked to under the Freedom of Information Act,
> Data Protection Act or for litigation. Email messages and attachments sent
> to or from any Environment Agency address may also be accessed by someone
> other than the sender or recipient, for business purposes. If we have sent
> you information and you wish to use it please read our terms and conditions
> which you can get by calling us on 08708 506 506. Find out more about the
> Environment Agency at www.environment-agency.gov.uk
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for litigation.
> Email messages and attachments sent to or from any Environment Agency
> address may also be accessed by someone other than the sender or recipient,
> for business purposes.
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506. Find
> out more about the Environment Agency at www.environment-agency.gov.uk
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l