blockheading的博客

-- Oracle Data Types Each column has a data type, which is associated with a specific storage format, constraints, and valid range of values. The data type of a value associates a fixed set of propert

SYS@prod1> select * from v$version; --查询当前版本，不同版本所拥有后台进程不一样 BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2

--SGA和PGA浅析 --SGA SYS@PROD1> select pool,sum(bytes) from v$sgastat group by pool; POOL SUM(BYTES) ------------ ---------- 384225152 java pool 4194304 streams pool 8388608 shared poo