>
archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Current log sequence 5
>
SELECT LOG_MODE,flashback_on,force_logging, supplemental_log_data_min min,
supplemental_log_data_pk pk,
supplemental_log_data_ui ui,
supplemental_log_data_fk fk,
supplemental_log_data_all allc
FROM v$database;
LOG_MODE FLASHBACK_ON FORCE_LOGGING MIN PK UI FK ALL
------------ ------------------ --------------------------------------- -------- --- --- --- ---
NOARCHIVELOG NO NO NO NO NO NO NO
Parameter Existing Value New Value
Remove: sga_max_size 80G
Change: sga_target 16G 140G
Change: pga_aggregate_target 15G 60G
Add: parallel_force_local TRUE
Add: parallel_max_servers 128
Add: streams_pool_size 2G
Add: heat_map ON
Change: open_cursors 300 1000
Change: global_names FALSE TRUE
Add: parallel_force_local TRUE
Add: parallel_max_servers 128
Add: streams_pool_size 2G
Add: heat_map ON
Remove cursor_sharing=FORCE
select p.name, sp.name, sp.value
from v$system_parameter sp, v$pdbs p
where sp.con_id = p.con_id
and sp.isdefault = 'FALSE'
order by 1, 2;
select sp.name, sp.value
from v$parameter sp
where sp.isdefault = 'FALSE'
order by 1;
col name for a26