Professional Web Applications Themes

billing cpu usage of a monthly basis - Oracle Server

Hi, We're planning to consolidate a large amount of our production database into one database. Our customers will be charged based on their use of the central machine's resources (other suggestions are very welcome). I saw a method of keeping track of resource usage, by means of the auditing mechanisms in Oracle: - drop the sys.aud$ table - create a new audit table in another schema - provide sys with a synonym or view for that newly created aud$ - build a trigger which recognises logon and logoff. I assume that'll work just fine. However, I'm not sure how to ...

  1. #1

    Default billing cpu usage of a monthly basis

    Hi,

    We're planning to consolidate a large amount of our production
    database into one database. Our customers will be charged based on
    their use of the central machine's resources (other suggestions are
    very welcome). I saw a method of keeping track of resource usage, by
    means of the auditing mechanisms in Oracle:
    - drop the sys.aud$ table
    - create a new audit table in another schema
    - provide sys with a synonym or view for that newly created aud$
    - build a trigger which recognises logon and logoff.

    I assume that'll work just fine. However, I'm not sure how to charge
    our customer for aborted sessions.

    Any suggestions are very welcome.

    HTH,
    Hans de Git
    Hans de Git Guest

  2. #2

    Default Re: billing cpu usage of a monthly basis

    Hi Hans

    I am sure that if you create the aud$ table under another schema and
    point at it with a synonym you might invalidate your support contract.
    Oracle no longer supports moving aud$ to another tablespace than system
    let alone another schema. This was due to some customer not being able
    to perform a recovery.

    You do not need to do what you suggest as the system triggers allow you
    to capture logon/logoff providing you have the right version?

    hth

    kind regards

    Pete
    --
    Pete Finnigan
    email:petepetefinnigan.com
    Web site: [url]http://www.petefinnigan.com[/url] - Oracle security audit specialists
    Book:Oracle security step-by-step Guide - see [url]http://store.sans.org[/url] for details.
    Pete Finnigan Guest

  3. #3

    Default Re: billing cpu usage of a monthly basis

    On Tue, 8 Jul 2003 16:33:46 +0200, Hans de Git wrote
    (in message <72383d4a.0307080633.e065a27posting.google.com> ):
    > Hi,
    >
    > We're planning to consolidate a large amount of our production
    > database into one database. Our customers will be charged based on
    > their use of the central machine's resources (other suggestions are
    > very welcome). I saw a method of keeping track of resource usage, by
    > means of the auditing mechanisms in Oracle:
    > - drop the sys.aud$ table
    > - create a new audit table in another schema
    > - provide sys with a synonym or view for that newly created aud$
    > - build a trigger which recognises logon and logoff.
    >
    > I assume that'll work just fine. However, I'm not sure how to charge
    > our customer for aborted sessions.
    >
    > Any suggestions are very welcome.
    >
    > HTH,
    > Hans de Git
    Hi Hans,

    I am not sure if this kind of billing is smart to introduce here. There are
    quite some fluctuations between oracle server versions running the same
    applications. Some queries could easily use double cpu, otheres less than in
    older versions. How would you cope with that ? Besides that, if you are paid
    for cpu usage, you'd better quit tuning the apps ... ;-)



    --
    met vriendelijke groeten,
    Ronald
    [url]http://ronr.nl/unix-dba[/url]

    Ronald Rood Guest

  4. #4

    Default Re: billing cpu usage of a monthly basis

    Hi Roon,
    > I am not sure if this kind of billing is smart to introduce here. There are
    > quite some fluctuations between oracle server versions running the same
    > applications. Some queries could easily use double cpu, otheres less than in
    > older versions. How would you cope with that ? Besides that, if you are paid
    > for cpu usage, you'd better quit tuning the apps ... ;-)
    Because we all use the same instance, our customers will sometimes
    have to deal with a larger amount of cpu on their invoice, because of
    upgrades. However, their overall benefit will outweigh that issue.
    Just like in the mainframe world.

    Now, about the billing itself. How about building a system trigger
    (thanks Pete, the suggestion about the aud$ tables was an oldie
    (before system triggers were introduced)) that queries v$sesstat
    before logoff? Seems quite easy. Again, that does not solve the
    problem of abended sessions.

    Ronald, I agree that tuning would have a serious impact on our
    revenues. However, those 'customers' work for the same company as I
    do. I try to stay with the big picture....

    Now the challenge is to map the cpu per session to resource manager
    consumer groups.....

    Regards,
    Hans
    Hans de Git Guest

  5. #5

    Default Re: billing cpu usage of a monthly basis

    Instead of billing by CPU cycles, have you thought about billing by
    other statistics, such as 'user calls' or I/O rates? Not all db
    transactions are created equally and some will consume more CPU than
    others. But then again, not all db transactions will consume I/O rates
    equally.

    HTH,
    Brian

    Hans de Git wrote:
    >
    > Hi,
    >
    > We're planning to consolidate a large amount of our production
    > database into one database. Our customers will be charged based on
    > their use of the central machine's resources (other suggestions are
    > very welcome). I saw a method of keeping track of resource usage, by
    > means of the auditing mechanisms in Oracle:
    > - drop the sys.aud$ table
    > - create a new audit table in another schema
    > - provide sys with a synonym or view for that newly created aud$
    > - build a trigger which recognises logon and logoff.
    >
    > I assume that'll work just fine. However, I'm not sure how to charge
    > our customer for aborted sessions.
    >
    > Any suggestions are very welcome.
    >
    > HTH,
    > Hans de Git
    --
    ================================================== =================

    Brian Peasland
    [email]dbaremove_spam.peasland.com[/email]

    Remove the "remove_spam." from the email address to email me.


    "I can give it to you cheap, quick, and good. Now pick two out of
    the three"
    Brian Peasland Guest

  6. #6

    Default Re: billing cpu usage of a monthly basis

    Hi,

    Instead of calculating each session CPU time, you can use Resource
    Manager to see the amount of CPU consumed by a group of users. This
    suppose that you can assign each user connected to the db, to a group.

    The followwing query gives the CPU consumed by the defined groups:

    select name, active_sessions, consumed_cpu_time
    from v$rsrc_consumer_group;

    Dias

    [email]hansdegithotmail.com[/email] (Hans de Git) wrote in message news:<72383d4a.0307080633.e065a27posting.google.c om>...
    > Hi,
    >
    > We're planning to consolidate a large amount of our production
    > database into one database. Our customers will be charged based on
    > their use of the central machine's resources (other suggestions are
    > very welcome). I saw a method of keeping track of resource usage, by
    > means of the auditing mechanisms in Oracle:
    > - drop the sys.aud$ table
    > - create a new audit table in another schema
    > - provide sys with a synonym or view for that newly created aud$
    > - build a trigger which recognises logon and logoff.
    >
    > I assume that'll work just fine. However, I'm not sure how to charge
    > our customer for aborted sessions.
    >
    > Any suggestions are very welcome.
    >
    > HTH,
    > Hans de Git
    dias Guest

Similar Threads

  1. Registration / recurring billing
    By bgc104 in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 22nd, 06:46 PM
  2. Setting Billing Address to Delivery
    By Gubbins in forum Dreamweaver AppDev
    Replies: 3
    Last Post: February 22nd, 09:26 AM
  3. OT: Time Billing software for OS X?
    By Allen_Wicks@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 2
    Last Post: March 3rd, 08:50 PM
  4. php script billing receipt
    By Duncan in forum PHP Development
    Replies: 1
    Last Post: July 14th, 10:38 PM
  5. Billing / Invoice scripts?
    By Butch in forum PERL Miscellaneous
    Replies: 0
    Last Post: July 11th, 09:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139