<div>
Hi slightwv:<br />
Cool, I got this file.<br />
we have a possible security breach, and want to see all the oracle logs for unusual connections<br />
and activities. What are other log/alert/trace files that can be useful?<br />
Thanks,<br />
<br />
Luchuan
</div>


Hi slightwv:
Cool, I got this file.
we have a possible security breach, and want to see all the oracle logs for unusual connections
and activities. What are other log/alert/trace files that can be useful?
Thanks,

Luchuan

<div>
- you can query to v$session view for user connection activity.
</div>


- you can query to v$session view for user connection activity.

<div>
&gt;&gt;you can query to v$session view for user connection activity. <br />
<br />
v$session will only show 'current' connections not 'past activity'.<br />
<br />
&gt;&gt;What are other log/alert/trace files that can be useful?<br />
<br />
Nothing really out of the box from an Oracle standpoint. &nbsp;In the future you could turn on auditing.<br />
<br />
You might check with your network/system folk to see what logging they might be doing.<br />

</div>


>>you can query to v$session view for user connection activity.

v$session will only show 'current' connections not 'past activity'.

>>What are other log/alert/trace files that can be useful?

Nothing really out of the box from an Oracle standpoint.  In the future you could turn on auditing.

You might check with your network/system folk to see what logging they might be doing.


<div>
Hi slightwv:<br />
This listener log file seems good enough for our investigation right now.<br />
Thanks a lot for your help.<br />
<br />
Luchuan
</div>


Hi slightwv:
This listener log file seems good enough for our investigation right now.
Thanks a lot for your help.

Luchuan

<div>
<div class="content wysiwyg-content">
Hi,<br />
In Oracle 11gR2, how to find the log files that shows all the connections to the databas<br />
I will appreciate for a quick reslonse.<br />
Thanks,<br />
Luchuan<br />

</div>
</div>


Hi,
In Oracle 11gR2, how to find the log files that shows all the connections to the databas
I will appreciate for a quick reslonse.
Thanks,
Luchuan


Find Oracle log files for database connection

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.