Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Who executed this command
<nowfal_at_gmail.com> wrote in message
news:1148394943.900837.114470_at_u72g2000cwu.googlegroups.com...
> I found the following line in the database ALRT log file. Is there any
> way to find out who executed the command (eg, which program, IP
> address, user, etc)?
>
> Tue May 23 09:12:41 2006
> /* OracleOEM */ DROP TABLESPACE "PRINTREQUEST"INCLUDING CONTENTS
> CASCADE CONSTRAINTS
>
> The database is 8.1.7 running on Windows 2000.
>
> Thanks
>
You could use log miner. I don't think you would be able to extract
v$session information (where the ip address is, and what program.) I
suspect someone used Oracle's OEM to execute the statement. (because the
"hint" OracleOEM in the comment)
Jim
Received on Tue May 23 2006 - 09:42:09 CDT