Friday, August 13, 2021

Review some Init Parameters

 sqlplus / as sysdba

COLUMN name FORMAT a35 HEADING 'Parameter Name'

COLUMN value FORMAT a110 HEADING 'Value'

SET PAGESIZE 50000 LINES 200

select distinct name,value

from gv$parameter

where name in

('service_names',

'resource_manager_plan',

'shared_pool_size',

'shared_pool_reserved_size',

'job_queue_processes',

'utl_file_dir',

'timed_statistics')

order by 1;

No comments:

Post a Comment