| shikhu |
Posted: Oct 05, 2007 12:52:50 AM |
Total Post: 61
Joined: Jul, 2006
|
Hi All,
How can I find out which schema is frequently used by the users in my database.
- Thanx.
Shikha Rani |
|
|
 krish |
| Posted: Oct 05, 2007 10:10:55 AM |  |
|
Total Post: 4
Joined: May, 2007
|
|
|
|
|
| suri |
| Posted: Oct 08, 2007 12:31:36 AM | |
|
Total Post: 20
Joined: Sep, 2006
|
you can query the v$session. It shows how many session are opened for that particular database.
|
|
|
|
|
| parthokonar |
| Posted: Oct 11, 2007 10:57:16 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
You can also make a script which validates v$session and put it in a crontab entry.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
