Monday, March 9, 2015

PGA size check

Select x.ksppinm name, y.ksppstvl value from x$ksppi x, x$ksppcv y where x.ksppinm = '_pga_max_size' and y.indx = x.indx and x.inst_id = USERENV('Instance') and y.inst_id = USERENV('Instance')
/

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...