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 ...