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...
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: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Enable auditing; you should be able to see all in there.
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..?
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: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is described here; check the documentation.
Previous Topic: Listener not starting automatically.
Next Topic: emctl configuration error
Goto Forum:
  


Current Time: Thu Dec 08 04:10:24 CST 2016

Total time taken to generate the page: 0.16042 seconds