Easy Life,Easy Way

High-water Mark

This is a term used with table segments stored in the database. If you envision a table, for example, as a ‘flat’ structure or as a series of blocks laid one after the other in a line from left to right, the high-water mark (HWM) would be the rightmost block that ever contained data, [...]

SQL Plus Instant Client 是一个具有SQL Plus 命令行所有功能的独立产品.它不需要安装Oracle客户端,可以直接连接远端的数据库.

1.SQL Plus Instant Client 安装
安装SQL Plus Instant Client, 你需要下面两个包.
可以在OTN下载,也可以从Oracle Client 的安装介质上拷贝相应的文件,拷贝的文件必须是同数据库版本的文件.

(1).SQL*Plus Instant Client package.
(2).Basic OCI Instant Client package, or the lightweight OCI Instant Client package.

A doc from Metalink:

Preferred and easiest way of monitoring and setting pga_aggregate_target parameter (PGA) is section ‘PGA Memory Advisory’ in the AWR and Statspack reports.

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)
Size Factr
W/A MB Processed
Estd Extra [...]

NUM_LCPUS
Probably 0 because LPARs not set up

NUM_VCPUS
Same thing

AVG_BUSY_TIME
BUSY_TIME/NUM_CPUS

AVG_IDLE_TIME
IDLE_TIME/NUM_CPUS

AVG_IOWAIT_TIME
IOWAIT_TIME/NUM_CPUS

AVG_SYS_TIME
SYS_TIME/NUM_CPUS

AVG_USER_TIME
USER_TIME/NUM_CPUS

BUSY_TIME
Time equiv of %usr+%sys in sar output

IDLE_TIME
Time equiv of %idle in sar

IOWAIT_TIME
Time equiv of %wio in sar

SYS_TIME
Time equiv of %sys in sar

USER_TIME
Time equiv of %usr in sar

LOAD
 

OS_CPU_WAIT_TIME
Supposedly time waiting on run queues

RSRC_MGR_CPU_WAIT_TIME
Time waited coz of resource manager

PHYSICAL_MEMORY_BYTES
Total memory in use supposedly

NUM_CPUS
Number of CPUs reported by OS

NUM_CPU_CORES
Number [...]