1.使用命令 show parameter dump
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string f:appadministratordiagrdbm
sorclorcltrace
core_dump_dest string f:appadministratordiagrdbm
sorclorclcdump
max_dump_file_size string unlimited
shadow_core_dump string none
user_dump_dest string f:appadministratordiagrdbm
sorclorcltrace
SQL>