RE: cost
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Apr 2004 14:07:07 -0400
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@xxxxxxxxxxx [mailto:thump604@xxxxxxxxxxx]=20
Sent: Monday, April 05, 2004 1:51 PM
To: oracle-l@xxxxxxxxxxxxx
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=20
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
