oracle presentation = ro,ORACLE杂乱小东西配置查看

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 = )

)

)

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';