Re: Oracle RAC TEMP / TEMP GROUP tablespace performance question
From: Kellyn Pot'vin <kellyn.potvin_at_ymail.com>
Date: Mon, 18 Feb 2013 18:13:22 -0800 (PST)
Message-ID: <1361240002.12571.androidMobile_at_web162001.mail.bf1.yahoo.com>
I'm curious to know-
If your environment uses parallel and if so, how is it configured? (Par parameters and any resource groups that may degrade DOP) What is you PGA set to?
What is your current PGA cache hit and what does your PGA cache hit table look like from awr? Thanks,
Kellyn Pot'Vin
Sir Technical Specialist
Enkitec
Date: Mon, 18 Feb 2013 18:13:22 -0800 (PST)
Message-ID: <1361240002.12571.androidMobile_at_web162001.mail.bf1.yahoo.com>
I'm curious to know-
If your environment uses parallel and if so, how is it configured? (Par parameters and any resource groups that may degrade DOP) What is you PGA set to?
What is your current PGA cache hit and what does your PGA cache hit table look like from awr? Thanks,
Kellyn Pot'Vin
Sir Technical Specialist
Enkitec
Sent from Yahoo! Mail on Android
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 19 2013 - 03:13:22 CET