Would you ever want to use multiple data files for the system tablespace?Title: Computing resource consumption
Does anyone know any papers or techniques to compute resource consumption by users in a DB systems? This may or may not be for computing charge-back to the client, but my questions are
1. What do you compute?
2. are there any standard methods and or standard formula?I am collecting v$sesstat when a session exits, but is data alone from session stats sufficient? How about the work done by background processes on user's behalf?
Do you do anything like this at your workplace? This is something that might be coming down the line, so I have been asked to start looking for related stuff.
Thanks in advance
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
