Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011

    Question Unanswered: number of connections to DB from the application

    Hi All,

    There are 13 linux machines that run a particular application, and all the instances of that application connect to a single db. Is there any way to know how much percentage of the database does each of those application instances are using??

    i.e, can we say,

    app_instance a is using x percentage of the db
    app_instance b is using y percentage of the db and the like.

    please help me.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >please help me.
    At the database level, Oracle RDBMS does not know or care about which client is issuing SQL.
    If this is going to be tracked, it needs to be done at the application level.

    Does application utilize connection pooling?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2011


    Yes the application uses connection pooling.

  4. #4
    Join Date
    Jun 2003
    West Palm Beach, FL


    Quote Originally Posted by javaguy View Post
    Yes the application uses connection pooling.
    Install Enterprise Manager if you haven't, check out the "Performance" tabs and/or generate AWR/AHS reports.

    PS: You could also generate those reports manually.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Tags for this 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