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