-
Hello friends,
Even our database server is shared one ,you can still connect to any database from your client dedicatedtly.
Is that correct?
But suppose 10 users are connecting to one shared server through dispatchers and one (1) user connecting as dedicated user to that same database. From which Data Dictionary view I will come to know , which user logged in as dedicated user or who else are through dispatchers?
Thanks
sumit
-
Even our database server is shared one ,you can still connect to any database from your client dedicatedtly.
Is that correct?
Yes, it is. All that is needed is a small change in the clients TNSNAMES.ORA, namely in CONNECT_DATA you add SERVER = DEDICATED.
From which Data Dictionary view I will come to know , which user logged in as dedicated user or who else are through dispatchers?
V$SESSION, look for the value in the SERVER column.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|