ORACLE杂乱小东西配置查看-优快云博客

本文介绍了Oracle数据库中监控PGA的方法及视图使用、如何查看数据文件的SCN号、客户端监听配置示例以及数据库恢复到特定时间点的具体操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、监控PGA的视图：v$sql_workarea_active、v$sql_workarea、v$sesstat、v$process、v$sysstat、v$sql_workarea_histogram等。
使用下面的视图查看Oracle建议的评估设置:
Select pga_target_for_estimate/1024/1024 ||'M' "Estimate PGA Target"
       ,estd_pga_cache_hit_percentage "Cache Hit(%)"
       ,estd_extra_bytes_rw/1024/1024 ||'M' "Extra Read/Write"
       ,estd_overalloc_count "Over alloc count"
From v$pga_target_advice

2、查看数据文件的SCN号： select file#, status, fuzzy, checkpoint_change# from v$datafile_header;
3、在客户端添加非集群的监听
TNSNAME:
HD06 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hd_06)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = hd06.domain)
    )
)

INST1_HTTP =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hd_06)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)
4、SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SQL> recover database until time '2005-01-17 11:49:35';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10129726/viewspace-707998/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10129726/viewspace-707998/