Re: How do I read This ?!@#

[This followup was posted to comp.databases.oracle.server and a copy was sent to the cited author.]

In article <5jqldd$b60_at_ds2.acs.ucalgary.ca>, nisenson_at_acs.ucalgary.ca says...
>
> *** SESSION ID:(30.51)
> Now how do I decyfer it ?
> What is the meaning of the exception 11 and
> where do I find information about other exceptions.
> It does tell me the session.id.
> How do I tie it to a real user, espacialy if I got this infromation
> on the following day.
> And then how do I know what was this user up to ?
> TIA.
>

Well, to make that trace file readable, send it through tkprof. You will have the SQL and all that other jazz in nice readable format. You will find everything out about that session, but as for finding out what else was going on in the database at that time, you will be kinda lost. --n

-- 
Neil Greene			Senior System Engineer / Oracle DBA	
MCI Systemhouse, Inc. 		<mailto:ngreene_at_laoc.SHL.com>

-----BEGIN PGP SIGNATURE-----
Version: 2.6.2

mQCNAzNWiBwAAAEEALmJ2Zho8BRcFc6vOHuUJp1TJ4+fZsmDgvi57DfDcnVCIcEv
e//qQ185dRN03821V7+MwfdKT51KOFcKRnHKFe8xGdDgMCB73ZFUn6X0acn3dVKn
K7kSTLpjcqlwGcEQb5MsH2oPz2ejUZ4+BghTN66nrZsEptkZOI+PVZH4HYSBAAUR
tCJOZWlsIEdyZWVuZSA8bmdyZWVuZUBsYW9jLlNITC5jb20+
=kEst
-----END PGP SIGNATURE---------------