SQL>
SQL>
SQL> spool db_parameters.log
SQL> select name, value
2 from v$parameter order by name;
NAME
------------------------------------------------------
VALUE
------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY
FALSE
active_instance_count
aq_tm_processes
0
archive_lag_target
0
asm_diskgroups
asm_diskstring
asm_power_limit
1
audit_file_dest
Page: 2
NAME
------------------------------------------------------
VALUE
------------------------------------------------------
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
audit_sys_operations
FALSE
audit_trail
NONE
background_core_dump
partial
background_dump_dest
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
backup_tape_io_slaves
FALSE
bitmap_merge_area_size
1048576
blank_trimming
FALSE
257 rows selected.
SQL> spool off
SQL>
|