| parveez |
Posted: Sep 12, 2007 01:49:50 PM |
Total Post: 22
Joined: Aug, 2007
|
| I want to check which computer is inserting how many datas in the DB. Kindly give a detailed procedure. |
|
|
 Ramesh Joyisa |
| Posted: Sep 13, 2007 05:47:22 AM |  |
|
Total Post: 245
Joined: Aug, 2007
|
use this for getting IP and then u can insert into table
select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual;
|
|
|
|
|
| parveez |
| Posted: Sep 13, 2007 12:16:56 PM | |
|
Total Post: 22
Joined: Aug, 2007
|
I know this part.I want to check which machine is making how many inserts from the front end into the DB
|
|
|
|
|
| parveez |
| Posted: Sep 13, 2007 12:17:21 PM | |
|
Total Post: 22
Joined: Aug, 2007
|
I know this part.I want to check which machine is making how many inserts from the front end into the DB
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Sep 17, 2007 07:51:59 AM | |
|
Total Post: 245
Joined: Aug, 2007
|
from the above you can get the ip of the user insert into along with the data and then count it.
|
|
|
|
|
| parthokonar |
| Posted: Sep 21, 2007 01:28:10 PM | |
|
Total Post: 27
Joined: Sep, 2007
|
There is a procedure through which you can also see the queries of the user
The GET_HOST_ADDRESS function returns the IP address of the specified host name.
1. SELECT UTL_INADDR.get_host_address('partho') FROM dual;
gives ip address
2. SELECT UTL_INADDR.get_host_name('195.148.6.3') FROM dual;
gives hostname
through which you can also get all the clients connected to the server.
After that you can go for v$session and v$sqlarea what ever you like
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:12:59 PM | |
|
Total Post: 418
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
