Pular para o conteúdo

Fóruns Banco de dados Oracle Parametros do Banco Parametros do Banco

#83699
rgmatias
Participante

    O retorno do primeiro select estava errado.

    select NAME , VALUE from v$parameter
    where name in (‘sga_target’,’shared_pool_size’,’java_pool_size’,’large_pool_size’,
    ‘pga_aggregate_target’,’shared_pool_reserved_size’,
    ‘workarea_size_policy’);

    [quote=”rgmatias”:ksm1dcns]Os dados são:

    1 shared_pool_size 0
    2 large_pool_size 0
    3 java_pool_size 0
    4 shared_pool_reserved_size 25165824
    5 sga_target 2483027968
    6 pga_aggregate_target 826277888
    7 workarea_size_policy AUTO[/quote]