Home » RDBMS Server » Server Administration » Historiacal connections on DataBase ? URGENT
Historiacal connections on DataBase ? URGENT [message #369566] Wed, 25 October 2000 02:48 Go to next message
lotfi
Messages: 4
Registered: October 2000
Junior Member
Hi,

Is there any some one who nows how get the historical connections on ORACLE Database V7.3.4 ?

(I tried the V$session_connect_info, but the informations are not explicit i.e NO DATABASE NAME OR Name of tools as DataBrowser !!!, i head the same thing with those views :
select * from DBA_2PC_NEIGHBORS;
select * from DBA_AUDIT_SESSION;)

Some help please ?

Best regard's

Report message to a moderator

Re: Historiacal connections on DataBase ? URGENT [message #369570 is a reply to message #369566] Thu, 26 October 2000 11:56 Go to previous message
Salman Khan
Messages: 51
Registered: September 2000
Member
Hi,

Enable Audit in Oracle, and only audit connections.

and use "USER_AUDIT_SESSION", it will tell you
all audit trail records concerning CONNECT and DISCONNECT.

Report message to a moderator

Previous Topic: Defuncts on aolserver and Oracle.
Next Topic: new user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 01:31:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.