is it ever a good idea to multiplex the system tablespace?

From: <rgaffuri_at_cox.net>
Date: Thu, 24 Jul 2003 12:56:11 -0400
Message-Id: <26007.339466@fatcity.com>

This is a multi-part message in MIME format.

------=____1059065771298_dqNa6=k)rU
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

Would you ever want to use multiple data files for the system tablespace?

------=____1059065771298_dqNa6=k)rU
Content-Type: text/html;

name="reply"
Content-Disposition: inline;

filename="reply"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>Computing resource consumption</TITLE>
</HEAD>
<BODY>

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 !


</BODY>
</HTML>

------=____1059065771298_dqNa6=k)rU-- Received on Thu Jul 24 2003 - 11:56:11 CDT