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

Thread: Instances

  1. 09-01-2001, 10:48 AM #1
    Jani
    Jani is offline Member
    Join Date
    Aug 2001
    Posts
    134

    Hi

    I m working in a company at One Server and 20 Clients,
    Oracle database install on win2000 server all users connect with
    user/pw@server
    How many instances are created when all users connect with server ?
    Thanx
    Reply With Quote Reply With Quote
  2. 09-01-2001, 11:04 AM #2
    drain surgeon
    drain surgeon is offline Junior Member
    Join Date
    Jun 2001
    Posts
    87

    Not too sure what you mean

    An instance has a lot to do with the database, SGA and background processes. It has nothing to do with the number of connections whatsoever.

    I take it you have only one instance running on your server. You will still have one instance if you have a single connection or 100 connections. Even if you have several people using the same account.

    Anyway to have all users logging on using the same account is a serious security risk. You need to make everyone accountable by giving them their own account.

    The Drain Surgeon.
    Reply With Quote Reply With Quote
  3. 09-01-2001, 11:28 AM #3
    irehman
    irehman is offline Senior Member
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Are you talking about how many connections are created?
    Reply With Quote Reply With Quote
  4. 09-01-2001, 11:51 AM #4
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    I m working in a company at One Server and 20 Clients,
    Oracle database install on win2000 server all users connect with user/pw@server How many instances are created when all users connect with server ?
    0 instances. You should suggest this question for OCP exams :-)

    Reply With Quote Reply With Quote
  5. 09-03-2001, 08:56 AM #5
    Jani
    Jani is offline Member
    Join Date
    Aug 2001
    Posts
    134

    Hi julian
    Why 0 instance at server ? or 0 instances at clients ?
    Thanx
    Reply With Quote Reply With Quote
  6. 09-03-2001, 09:16 AM #6
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Jani
    Why 0 instance at server ? or 0 instances at clients ?
    When a user connects to the server, no instances are created.

    All Oracle components, memory structures, processes, disk resources, etc. running together are called an instance.



    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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