| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cost
David,
No, I don't think so. I would interpret that to mean that statistics, such as those available in V$SYSSTAT/V$SESSTAT, like "CPU used by this session", are what's updated more frequently.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"
-----Original Message-----
From: thump604_at_comcast.net [mailto:thump604_at_comcast.net]=20
Sent: Monday, April 05, 2004 1:51 PM
To: oracle-l_at_freelists.org
Subject: RE: cost
Does anyone have any idea or knowledge regarding resource_limit and if
that=20
paramter plays any role whatsoever in costing?
The reason I ask is the following blurb: Support and Historical Notes for "RESOURCE_LIMIT" Related:
=20
As a side effect this causes CPU based statistics to be updated
more frequently than usual in order to ensure CPU resource limits
are not exceeded.
-- - David=20Received on Mon Apr 05 2004 - 13:03:40 CDT
> Yep, "bug" is where we're going with it... But we haven't had time yet
> to go into detail.
>=20 >=20
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> * Nullius in verba *
>=20
> Upcoming events:
> - Performance Diagnosis 101: 4/6 Seattle, 5/7 Dallas, 5/18 New Jersey
> - SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego
> - Hotsos Symposium 2005: March 6-10 Dallas
> - Visit www.hotsos.com for schedule details...
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
 |
 |