Home » RDBMS Server » Server Administration » concurrent users accessing the table ...?
concurrent users accessing the table ...? [message #184404] Wed, 26 July 2006 07:44 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
Hi,

let us consider the emp table be accessed by many programs/users.

how to find the list of programs or users accessing the emp table at the point of time...?

I was asked the question in an interview.

Plz clear out...

Report message to a moderator

Re: concurrent users accessing the table ...? [message #184407 is a reply to message #184404] Wed, 26 July 2006 07:50 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Enable auditing; you should be able to see all in there.

Report message to a moderator

Re: concurrent users accessing the table ...? [message #184409 is a reply to message #184407] Wed, 26 July 2006 08:05 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
can u plz let me know how to enable auditing and how to see the concurrent access..?

Report message to a moderator

Re: concurrent users accessing the table ...? [message #184459 is a reply to message #184409] Wed, 26 July 2006 10:53 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is described here; check the documentation.

Report message to a moderator

Previous Topic: Listener not starting automatically.
Next Topic: emctl configuration error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 22:39:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.