Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: wait events and v$session_event
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 5/18 Edison NJ, 6/22 Pittsburgh, 7/20 =
Boston
- SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of ryan.gaffuri_at_cox.net
Sent: Tuesday, May 11, 2004 11:23 AM
To: oracle-l_at_freelists.org
Subject: Re: RE: wait events and v$session_event
Cary,
Could you be a little more specific, I don't quite understand this? I am
using one node right now for everything in my ETL process. However, we =
have
load_balancing turned on.=20
Also, why would I get file read waits if I just have one session = running?=20
One note worth
mentioning here is that even the famous "I'll do TP on one RAC node and
query-only on the other" strategy is prone to lots of "global cache *"
activity.
Why? Because of the undo blocks that are used by both nodes.
-- 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 -----------------------------------------------------------------Received on Tue May 11 2004 - 11:55:06 CDT
![]() |
![]() |