DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SERVER PROCESS

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Exclamation

    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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
  •  


Click Here to Expand Forum to Full Width