Oracle Architecture
文章平均质量分 77
blockheading
Oracle rookie
展开
-
Oracle数据类型
-- Oracle Data TypesEach 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转载 2016-10-08 22:32:39 · 417 阅读 · 0 评论 -
通过v$bgprocess查看后台进程
SYS@prod1> select * from v$version; --查询当前版本,不同版本所拥有后台进程不一样BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2原创 2016-10-11 20:14:09 · 1754 阅读 · 0 评论 -
SGA和PGA浅析
--SGA和PGA浅析--SGASYS@PROD1> select pool,sum(bytes) from v$sgastat group by pool;POOL SUM(BYTES)------------ ---------- 384225152java pool 4194304streams pool 8388608shared poo原创 2016-12-30 19:53:19 · 703 阅读 · 0 评论