方法一:
SQL> show parameter background_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace
方法二:
SQL> select value from v$parameter where name='background_dump_dest';