oracle之 sga（一）
来源：互联网 发布：2016非农数据行情回顾 编辑：程序博客网 时间：2024/05/22 01:49
oracle之 sga（一）
今天是2013-07-30，前段时间一直研究dg，内存这块一直拖着，没有继续研究，从今天开始继续按照我的oracle学习步伐前进。
这是今天进行看书的时候练习的笔记，在此记录一下。
查看版本。
SYS@orcl#select banner from v$version;
这是今天进行看书的时候练习的笔记，在此记录一下。
查看版本。
SYS@orcl#select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
在oraclesga中有一个fixed sga可以通过x$ksmmem和x$ksmsvf进行查看（不建议在生产库进行研究，影响性能）
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
在oraclesga中有一个fixed sga可以通过x$ksmmem和x$ksmsvf进行查看（不建议在生产库进行研究，影响性能）
SYS@orcl#select count(*) from x$ksmmem;
COUNT(*)
----------
65242112
----------
65242112
SYS@orcl#show sga
Total System Global Area 521936896 bytes
Fixed Size 2145984 bytes
Variable Size 432013632 bytes
Database Buffers 83886080 bytes
Redo Buffers 3891200 bytes
SYS@orcl#select 521936896/65242112 from dual;
Fixed Size 2145984 bytes
Variable Size 432013632 bytes
Database Buffers 83886080 bytes
Redo Buffers 3891200 bytes
SYS@orcl#select 521936896/65242112 from dual;
521936896/65242112
------------------
8
可以看出每个oracle内存条目在内存中每一个占用8byte。
------------------
8
可以看出每个oracle内存条目在内存中每一个占用8byte。
SYS@orcl#desc x$ksmmem;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
KSMMMVAL RAW(8)
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
KSMMMVAL RAW(8)
SYS@orcl#desc X$ksmfsv;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
KSMFSNAM VARCHAR2(64)
KSMFSTYP VARCHAR2(64)
KSMFSADR RAW(8)
KSMFSSIZ NUMBER
在这个两个视图中记录了内存中的相关参数变量的内部参数value。如下。
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
KSMFSNAM VARCHAR2(64)
KSMFSTYP VARCHAR2(64)
KSMFSADR RAW(8)
KSMFSSIZ NUMBER
在这个两个视图中记录了内存中的相关参数变量的内部参数value。如下。
SYS@orcl#select a.ksmfsnam,b.ksmmmval,a.ksmfssiz,a.ksmfsadr from x$ksmmem b,x$ksmfsv a
2 where a.addr=b.addr and ksmfsnam like '%sgaflg_%';
2 where a.addr=b.addr and ksmfsnam like '%sgaflg_%';
未选定行
SYS@orcl#select a.ksmfsnam,b.ksmmmval,a.ksmfssiz,a.ksmfsadr from x$ksmmem b,x$ksmfsv a
2 where a.addr=b.addr and a.ksmfsnam like 'sgaflg%';
2 where a.addr=b.addr and a.ksmfsnam like 'sgaflg%';
未选定行
SYS@orcl#select a.ksmfsnam,b.ksmmmval,a.ksmfssiz,a.ksmfsadr from x$ksmmem b,x$ksmfsv a
2 where a.ksmfsadr=b.addr and a.ksmfsnam like 'sgaflg%';
2 where a.ksmfsadr=b.addr and a.ksmfsnam like 'sgaflg%';
KSMFSNAM
--------------------------------------------------------------------------------
KSMMMVAL KSMFSSIZ KSMFSADR
---------------- ---------- ----------------
sgaflg_
000000000070021A 4 0000000060034D08
--------------------------------------------------------------------------------
KSMMMVAL KSMFSSIZ KSMFSADR
---------------- ---------- ----------------
sgaflg_
000000000070021A 4 0000000060034D08
SYS@orcl#alter system disable distributed recovery;
系统已更改。
SYS@orcl#select a.ksmfsnam,b.ksmmmval,a.ksmfssiz,a.ksmfsadr from x$ksmmem b,x$ksmfsv a
2 where a.ksmfsadr=b.addr and a.ksmfsnam like '%sgaflg%';
2 where a.ksmfsadr=b.addr and a.ksmfsnam like '%sgaflg%';
KSMFSNAM
--------------------------------------------------------------------------------
KSMMMVAL KSMFSSIZ KSMFSADR
---------------- ---------- ----------------
sgaflg_
0000000000700212 4 0000000060034D08
--------------------------------------------------------------------------------
KSMMMVAL KSMFSSIZ KSMFSADR
---------------- ---------- ----------------
sgaflg_
0000000000700212 4 0000000060034D08
SYS@orcl#alter system enable distributed recovery;
系统已更改。
SYS@orcl#select a.ksmfsnam,b.ksmmmval,a.ksmfssiz,a.ksmfsadr from x$ksmmem b,x$ksmfsv a
2 where a.ksmfsadr=b.addr and a.ksmfsnam like '%sgaflg%';
2 where a.ksmfsadr=b.addr and a.ksmfsnam like '%sgaflg%';
KSMFSNAM
--------------------------------------------------------------------------------
KSMMMVAL KSMFSSIZ KSMFSADR
---------------- ---------- ----------------
sgaflg_
000000000070021A 4 0000000060034D08
--------------------------------------------------------------------------------
KSMMMVAL KSMFSSIZ KSMFSADR
---------------- ---------- ----------------
sgaflg_
000000000070021A 4 0000000060034D08
另外，我们可以使用dumpva进行pga、vga、uga的变量
eg：
SYS@orcl#oradebug setmypid
已处理的语句
SYS@orcl#oradebug dumpvar sga sgaflg_
ub4 sgaflg_ [060034D08, 060034D0C) = 0070021A
SYS@orcl#alter system disable distributed recovery;
eg：
SYS@orcl#oradebug setmypid
已处理的语句
SYS@orcl#oradebug dumpvar sga sgaflg_
ub4 sgaflg_ [060034D08, 060034D0C) = 0070021A
SYS@orcl#alter system disable distributed recovery;
系统已更改。
SYS@orcl#oradebug dumpvar sga sgaflg_
ub4 sgaflg_ [060034D08, 060034D0C) = 00700212
SYS@orcl#alter system enable distributed recovery;
ub4 sgaflg_ [060034D08, 060034D0C) = 00700212
SYS@orcl#alter system enable distributed recovery;
系统已更改。
SYS@orcl#oradebug dumpvar sga sgaflg_
ub4 sgaflg_ [060034D08, 060034D0C) = 0070021A
SYS@orcl#show parameter db_cache
ub4 sgaflg_ [060034D08, 060034D0C) = 0070021A
SYS@orcl#show parameter db_cache
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_cache_advice string
ON
db_cache_size big integer
0
SYS@orcl#set linesize 200
SYS@orcl#r
1* alter system enable distributed recovery
------------------------------------ ----------------------
VALUE
------------------------------
db_cache_advice string
ON
db_cache_size big integer
0
SYS@orcl#set linesize 200
SYS@orcl#r
1* alter system enable distributed recovery
系统已更改。
SYS@orcl#show parameter db_cache
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_cache_advice string ON
db_cache_size big integer 0
SYS@orcl#show parameter db_
------------------------------------ ---------------------- ------------------------------
db_cache_advice string ON
db_cache_size big integer 0
SYS@orcl#show parameter db_
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_16k_cache_size big integer 0
db_2k_cache_size big integer 16M
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
------------------------------------ ---------------------- ------------------------------
db_16k_cache_size big integer 0
db_2k_cache_size big integer 16M
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_create_file_dest string /opt/oracle/oradata
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_domain string
db_file_multiblock_read_count integer 77
db_file_name_convert string
db_files integer 200
db_flashback_retention_target integer 1440
------------------------------------ ---------------------- ------------------------------
db_create_file_dest string /opt/oracle/oradata
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_domain string
db_file_multiblock_read_count integer 77
db_file_name_convert string
db_files integer 200
db_flashback_retention_target integer 1440
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_keep_cache_size big integer 8M
db_lost_write_protect string NONE
db_name string orcl
db_recovery_file_dest string /opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer 6G
db_recycle_cache_size big integer 8M
db_securefile string PERMITTED
db_ultra_safe string OFF
db_unique_name string orcl
db_writer_processes integer 1
------------------------------------ ---------------------- ------------------------------
db_keep_cache_size big integer 8M
db_lost_write_protect string NONE
db_name string orcl
db_recovery_file_dest string /opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer 6G
db_recycle_cache_size big integer 8M
db_securefile string PERMITTED
db_ultra_safe string OFF
db_unique_name string orcl
db_writer_processes integer 1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
dbwr_io_slaves integer 0
rdbms_server_dn string
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
xml_db_events string enable
SYS@orcl#select 8192/1024 from dual;
------------------------------------ ---------------------- ------------------------------
dbwr_io_slaves integer 0
rdbms_server_dn string
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
xml_db_events string enable
SYS@orcl#select 8192/1024 from dual;
8192/1024
----------
8
----------
8
SYS@orcl#show parameter db_block_size
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_block_size integer 8192
SYS@orcl#!
oracle@oracle:~/test> ls
full.dmp getsp.sql IPSPKG_20130528214539_COM_2.zip ORA4031_20130528220545_COM_1.zip point.sql test2.sql test3.sql test.sql
------------------------------------ ---------------------- ------------------------------
db_block_size integer 8192
SYS@orcl#!
oracle@oracle:~/test> ls
full.dmp getsp.sql IPSPKG_20130528214539_COM_2.zip ORA4031_20130528220545_COM_1.zip point.sql test2.sql test3.sql test.sql
对于sga中内部components的大小都是有一个granule（粒度）大小的，每个组件的大小只能是该granule的整数倍。（redo buffer除外）
eg：
oracle@oracle:~/test> sqlplus / as sysdba
oracle@oracle:~/test> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 7月 30 20:42:32 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl#@getsp.sql
输入 par 的值: ksmg_granule
原值 2: where x.indx=y.indx and x.ksppinm like '%&par%'
新值 2: where x.indx=y.indx and x.ksppinm like '%ksmg_granule%'
输入 par 的值: ksmg_granule
原值 2: where x.indx=y.indx and x.ksppinm like '%&par%'
新值 2: where x.indx=y.indx and x.ksppinm like '%ksmg_granule%'
NAME VALUE PDESC
------------------------------ -------------------- --------------------------------------------------
_ksmg_granule_size 4194304 granule size in bytes
_ksmg_granule_locking_status 1 granule locking status
------------------------------ -------------------- --------------------------------------------------
_ksmg_granule_size 4194304 granule size in bytes
_ksmg_granule_locking_status 1 granule locking status
SYS@orcl#select 4194304/1024/1024 M from dual;
M
----------
4
----------
4
SYS@orcl#desc v$sga_dynamic_components;
名称 是否为空? 类型
----------------------------------------------------------------- -------- --------------------------------------------
COMPONENT VARCHAR2(64)
CURRENT_SIZE NUMBER
MIN_SIZE NUMBER
MAX_SIZE NUMBER
USER_SPECIFIED_SIZE NUMBER
OPER_COUNT NUMBER
LAST_OPER_TYPE VARCHAR2(13)
LAST_OPER_MODE VARCHAR2(9)
LAST_OPER_TIME DATE
GRANULE_SIZE NUMBER
名称 是否为空? 类型
----------------------------------------------------------------- -------- --------------------------------------------
COMPONENT VARCHAR2(64)
CURRENT_SIZE NUMBER
MIN_SIZE NUMBER
MAX_SIZE NUMBER
USER_SPECIFIED_SIZE NUMBER
OPER_COUNT NUMBER
LAST_OPER_TYPE VARCHAR2(13)
LAST_OPER_MODE VARCHAR2(9)
LAST_OPER_TIME DATE
GRANULE_SIZE NUMBER
SYS@orcl#col component for a50
SYS@orcl#r
1* select granule_size,oper_count,component from v$sga_dynamic_components
GRANULE_SIZE OPER_COUNT COMPONENT
------------ ---------- --------------------------------------------------
4194304 1 shared pool
4194304 0 large pool
4194304 0 java pool
4194304 0 streams pool
4194304 1 DEFAULT buffer cache
4194304 0 KEEP buffer cache
4194304 0 RECYCLE buffer cache
4194304 0 DEFAULT 2K buffer cache
4194304 0 DEFAULT 4K buffer cache
4194304 0 DEFAULT 8K buffer cache
4194304 0 DEFAULT 16K buffer cache
------------ ---------- --------------------------------------------------
4194304 1 shared pool
4194304 0 large pool
4194304 0 java pool
4194304 0 streams pool
4194304 1 DEFAULT buffer cache
4194304 0 KEEP buffer cache
4194304 0 RECYCLE buffer cache
4194304 0 DEFAULT 2K buffer cache
4194304 0 DEFAULT 4K buffer cache
4194304 0 DEFAULT 8K buffer cache
4194304 0 DEFAULT 16K buffer cache
GRANULE_SIZE OPER_COUNT COMPONENT
------------ ---------- --------------------------------------------------
4194304 0 DEFAULT 32K buffer cache
4194304 0 Shared IO Pool
4194304 0 ASM Buffer Cache
------------ ---------- --------------------------------------------------
4194304 0 DEFAULT 32K buffer cache
4194304 0 Shared IO Pool
4194304 0 ASM Buffer Cache
已选择14行。
SYS@orcl#set verify off
SYS@orcl#@getsp.sql
输入 par 的值: ksmg_
SYS@orcl#@getsp.sql
输入 par 的值: ksmg_
NAME VALUE PDESC
------------------------------ -------------------- --------------------------------------------------
_ksmg_granule_size 4194304 granule size in bytes
_ksmg_granule_locking_status 1 granule locking status
_ksmg_lock_check_interval timeout action interval in minutes
_ksmg_lock_reacquire_count 5 repeat count for acquisition of locks
------------------------------ -------------------- --------------------------------------------------
_ksmg_granule_size 4194304 granule size in bytes
_ksmg_granule_locking_status 1 granule locking status
_ksmg_lock_check_interval timeout action interval in minutes
_ksmg_lock_reacquire_count 5 repeat count for acquisition of locks
SYS@orcl#show parameter db_keep
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_keep_cache_size big integer 8M
SYS@orcl#show parameter db_recyc
------------------------------------ ---------------------- ------------------------------
db_keep_cache_size big integer 8M
SYS@orcl#show parameter db_recyc
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_recycle_cache_size big integer 8M
SYS@orcl#show parameter db_buffer
SYS@orcl#show parameter db_cache
------------------------------------ ---------------------- ------------------------------
db_recycle_cache_size big integer 8M
SYS@orcl#show parameter db_buffer
SYS@orcl#show parameter db_cache
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_cache_advice string ON
db_cache_size big integer 0
SYS@orcl#show parameter cache
------------------------------------ ---------------------- ------------------------------
db_cache_advice string ON
db_cache_size big integer 0
SYS@orcl#show parameter cache
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 16M
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_advice string ON
db_cache_size big integer 0
db_keep_cache_size big integer 8M
db_recycle_cache_size big integer 8M
------------------------------------ ---------------------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 16M
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_advice string ON
db_cache_size big integer 0
db_keep_cache_size big integer 8M
db_recycle_cache_size big integer 8M
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
result_cache_max_result integer 5
result_cache_max_size big integer 2624K
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
session_cached_cursors integer 600
SYS@orcl#show parameter buffer
------------------------------------ ---------------------- ------------------------------
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
result_cache_max_result integer 5
result_cache_max_size big integer 2624K
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
session_cached_cursors integer 600
SYS@orcl#show parameter buffer
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
db_block_buffers integer 0
log_buffer integer 3620864
use_indirect_data_buffers boolean FALSE
SYS@orcl#desc v$buffer_pool
名称 是否为空? 类型
----------------------------------------------------------------- -------- --------------------------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
RESIZE_STATE VARCHAR2(10)
CURRENT_SIZE NUMBER
BUFFERS NUMBER
TARGET_SIZE NUMBER
TARGET_BUFFERS NUMBER
PREV_SIZE NUMBER
PREV_BUFFERS NUMBER
LO_BNUM NUMBER
HI_BNUM NUMBER
LO_SETID NUMBER
HI_SETID NUMBER
SET_COUNT NUMBER
------------------------------------ ---------------------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
db_block_buffers integer 0
log_buffer integer 3620864
use_indirect_data_buffers boolean FALSE
SYS@orcl#desc v$buffer_pool
名称 是否为空? 类型
----------------------------------------------------------------- -------- --------------------------------------------
ID NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
RESIZE_STATE VARCHAR2(10)
CURRENT_SIZE NUMBER
BUFFERS NUMBER
TARGET_SIZE NUMBER
TARGET_BUFFERS NUMBER
PREV_SIZE NUMBER
PREV_BUFFERS NUMBER
LO_BNUM NUMBER
HI_BNUM NUMBER
LO_SETID NUMBER
HI_SETID NUMBER
SET_COUNT NUMBER
SYS@orcl#select id,name,block_size,buffers from v$buffer_pool;
ID NAME BLOCK_SIZE BUFFERS
---------- ------------------------------ ---------- ----------
1 KEEP 8192 984
2 RECYCLE 8192 984
3 DEFAULT 8192 5904
4 DEFAULT 2048 7104
当我们创建表的时候，可以根据需要使用storage（buffer_pool default) or storage (buffer_pool recycle) or storage (buffer_pool keep)进行选择该表是在什么类型的buffer cache 中。
---------- ------------------------------ ---------- ----------
1 KEEP 8192 984
2 RECYCLE 8192 984
3 DEFAULT 8192 5904
4 DEFAULT 2048 7104
当我们创建表的时候，可以根据需要使用storage（buffer_pool default) or storage (buffer_pool recycle) or storage (buffer_pool keep)进行选择该表是在什么类型的buffer cache 中。
SYS@orcl#show parameter shared_pool
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
shared_pool_reserved_size big integer 10905190
shared_pool_size big integer 0
SYS@orcl#show parameter log_buffer
------------------------------------ ---------------------- ------------------------------
shared_pool_reserved_size big integer 10905190
shared_pool_size big integer 0
SYS@orcl#show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
log_buffer integer 3620864
SYS@orcl#show parameter memory
------------------------------------ ---------------------- ------------------------------
log_buffer integer 3620864
SYS@orcl#show parameter memory
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SYS@orcl#show parameter sga
------------------------------------ ---------------------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
SYS@orcl#show parameter sga
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 500M
sga_target big integer 400M
SYS@orcl#show parameter large_pool
------------------------------------ ---------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 500M
sga_target big integer 400M
SYS@orcl#show parameter large_pool
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
large_pool_size big integer 100M
SYS@orcl#show parameter java_pool
------------------------------------ ---------------------- ------------------------------
large_pool_size big integer 100M
SYS@orcl#show parameter java_pool
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
java_pool_size big integer 0
SYS@orcl#show parameter streams
------------------------------------ ---------------------- ------------------------------
java_pool_size big integer 0
SYS@orcl#show parameter streams
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
streams_pool_size big integer 0
SYS@orcl#show sga
------------------------------------ ---------------------- ------------------------------
streams_pool_size big integer 0
SYS@orcl#show sga
Total System Global Area 521936896 bytes
Fixed Size 2145984 bytes
Variable Size 432013632 bytes
Database Buffers 83886080 bytes
Redo Buffers 3891200 bytes
SYS@orcl# 未知命令 "
SYS@orcl#select * from v$sgainfo;
Fixed Size 2145984 bytes
Variable Size 432013632 bytes
Database Buffers 83886080 bytes
Redo Buffers 3891200 bytes
SYS@orcl# 未知命令 "
SYS@orcl#select * from v$sgainfo;
NAME BYTES RESIZE
------------------------------ ---------- ------
Fixed SGA Size 2145984 No
Redo Buffers 3891200 No
Buffer Cache Size 75497472 Yes
Shared Pool Size 218103808 Yes
Large Pool Size 104857600 Yes
Java Pool Size 12582912 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 521936896 No
Startup overhead in Shared Poo 54525952 No
------------------------------ ---------- ------
Fixed SGA Size 2145984 No
Redo Buffers 3891200 No
Buffer Cache Size 75497472 Yes
Shared Pool Size 218103808 Yes
Large Pool Size 104857600 Yes
Java Pool Size 12582912 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 521936896 No
Startup overhead in Shared Poo 54525952 No
NAME BYTES RESIZE
------------------------------ ---------- ------
l
------------------------------ ---------- ------
l
Free SGA Memory Available 104857600
已选择12行。
SYS@orcl#show parameter java_pool
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
java_pool_size big integer 0
SYS@orcl#show parameter streams_pool
------------------------------------ ---------------------- ------------------------------
java_pool_size big integer 0
SYS@orcl#show parameter streams_pool
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
streams_pool_size big integer 0
SYS@orcl#show parameter large
------------------------------------ ---------------------- ------------------------------
streams_pool_size big integer 0
SYS@orcl#show parameter large
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
large_pool_size big integer 100M
SYS@orcl#alter system set large_pool_size=0;
------------------------------------ ---------------------- ------------------------------
large_pool_size big integer 100M
SYS@orcl#alter system set large_pool_size=0;
系统已更改。
SYS@orcl#show parameter large_pool
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
large_pool_size big integer 0
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~/test> exit
exit
------------------------------------ ---------------------- ------------------------------
large_pool_size big integer 0
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~/test> exit
exit
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~>
oracle@oracle:~>
oracle@oracle:~>
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~>
oracle@oracle:~>
oracle@oracle:~>
sga与共享内存。
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x62b091ac 131074 oracle 660 526385152 35
key shmid owner perms bytes nattch status
0x62b091ac 131074 oracle 660 526385152 35
------ Semaphore Arrays --------
key semid owner perms nsems
0x1497e4d8 131073 oracle 660 164
key semid owner perms nsems
0x1497e4d8 131073 oracle 660 164
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 7月 30 21:05:56 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl#select 526385152/1024/1024 from dual;
526385152/1024/1024
-------------------
502
-------------------
502
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> exit
logout
oracle:~ # more /etc/sysctl.conf
fs.file-max = 6815744
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmall = 2097152
kernel.shmall = 5242880
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmmax = 536870911
kernel.shmmax = 21474836480
kernel.shmmni = 4096
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.sem = 250 32000 100 128
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> exit
logout
oracle:~ # more /etc/sysctl.conf
fs.file-max = 6815744
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmall = 2097152
kernel.shmall = 5242880
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmmax = 536870911
kernel.shmmax = 21474836480
kernel.shmmni = 4096
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.sem = 250 32000 100 128
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.max_map_count = 300000
oracle:~ # vi /etc/sysctl.conf
fs.file-max = 6815744
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmall = 2097152
kernel.shmall = 5242880
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmmax = 536870911
kernel.shmmax = 21474836480
kernel.shmmni = 4096
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.sem = 250 32000 100 128
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
oracle:~ # vi /etc/sysctl.conf
fs.file-max = 6815744
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmall = 2097152
kernel.shmall = 5242880
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmmax = 536870911
kernel.shmmax = 21474836480
kernel.shmmni = 4096
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.sem = 250 32000 100 128
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.max_map_count = 300000
~
~
~
~
~
~
~
~
~
~
~
"/etc/sysctl.conf" 18L, 536C written
oracle:~ # su - oracle
~
~
~
~
~
~
~
~
~
~
~
"/etc/sysctl.conf" 18L, 536C written
oracle:~ # su - oracle
oracle:~ # sysctl -;
error: Unknown parameter "-"
usage: sysctl [-n] [-e] variable ...
sysctl [-n] [-e] [-q] -w variable=value ...
sysctl [-n] [-e] -a
sysctl [-n] [-e] [-q] -p <file> (default /etc/sysctl.conf)
sysctl [-n] [-e] -A
oracle:~ # sysctl -p
fs.file-max = 6815744
kernel.shmall = 5242880
kernel.shmmax = 134217728
kernel.shmmni = 4096
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.max_map_count = 300000
oracle:~ # su - oracle
oracle@oracle:~> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 7月 30 21:13:31 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl#!
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x62b091ac 196610 oracle 660 526385152 37
key shmid owner perms bytes nattch status
0x62b091ac 196610 oracle 660 526385152 37
------ Semaphore Arrays --------
key semid owner perms nsems
0x1497e4d8 262145 oracle 660 164
key semid owner perms nsems
0x1497e4d8 262145 oracle 660 164
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> exit
exit
exit
SYS@orcl#shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SYS@orcl#!
oracle@oracle:~> ipcs -sa
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SYS@orcl#!
oracle@oracle:~> ipcs -sa
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
key shmid owner perms bytes nattch status
------ Semaphore Arrays --------
key semid owner perms nsems
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
key shmid owner perms bytes nattch status
------ Semaphore Arrays --------
key semid owner perms nsems
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> exit
exit
exit
SYS@orcl#startup
ORACLE 例程已经启动。
ORACLE 例程已经启动。
Total System Global Area 521936896 bytes
Fixed Size 2145984 bytes
Variable Size 352321856 bytes
Database Buffers 163577856 bytes
Redo Buffers 3891200 bytes
数据库装载完毕。
数据库已经打开。
SYS@orcl#!
oracle@oracle:~>
oracle@oracle:~>
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
Fixed Size 2145984 bytes
Variable Size 352321856 bytes
Database Buffers 163577856 bytes
Redo Buffers 3891200 bytes
数据库装载完毕。
数据库已经打开。
SYS@orcl#!
oracle@oracle:~>
oracle@oracle:~>
oracle@oracle:~> ipcs -ia
usage : ipcs -asmq -tclup
ipcs [-s -m -q] -i id
ipcs -h for help.
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 262146 oracle 660 8388608 34
0x00000000 294915 oracle 660 134217728 34
0x00000000 327684 oracle 660 134217728 34
0x00000000 360453 oracle 660 134217728 34
0x62b091ac 393222 oracle 660 115343360 34
key shmid owner perms bytes nattch status
0x00000000 262146 oracle 660 8388608 34
0x00000000 294915 oracle 660 134217728 34
0x00000000 327684 oracle 660 134217728 34
0x00000000 360453 oracle 660 134217728 34
0x62b091ac 393222 oracle 660 115343360 34
------ Semaphore Arrays --------
key semid owner perms nsems
0x1497e4d8 393217 oracle 660 164
key semid owner perms nsems
0x1497e4d8 393217 oracle 660 164
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> exit
exit
exit
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> exit
logout
oracle:~ # vi /etc/sysctl.conf
fs.file-max = 6815744
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmall = 2097152
kernel.shmall = 5242880
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmmax = 536870911
kernel.shmmax = 134217728
kernel.shmmni = 4096
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.sem = 250 32000 100 128
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> exit
logout
oracle:~ # vi /etc/sysctl.conf
fs.file-max = 6815744
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmall = 2097152
kernel.shmall = 5242880
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.shmmax = 536870911
kernel.shmmax = 134217728
kernel.shmmni = 4096
# Modified for SAP on 2013-06-13 13:49:32 UTC
#kernel.sem = 250 32000 100 128
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.max_map_count = 300000
~
~
~
~
~
~
~
~
~
~
~
"/etc/sysctl.conf" 18L, 536C written
oracle:~ # sysctl -p
fs.file-max = 6815744
kernel.shmall = 5242880
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.max_map_count = 300000
oracle:~ # su - oracle
oracle@oracle:~> sqlplus / as sysdba
~
~
~
~
~
~
~
~
~
~
~
"/etc/sysctl.conf" 18L, 536C written
oracle:~ # sysctl -p
fs.file-max = 6815744
kernel.shmall = 5242880
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 1250 256000 100 8192
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.max_map_count = 300000
oracle:~ # su - oracle
oracle@oracle:~> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 7月 30 21:17:23 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> ipcs -a
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> ipcs -a
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 262146 oracle 660 8388608 33
0x00000000 294915 oracle 660 134217728 33
0x00000000 327684 oracle 660 134217728 33
0x00000000 360453 oracle 660 134217728 33
0x62b091ac 393222 oracle 660 115343360 33
key shmid owner perms bytes nattch status
0x00000000 262146 oracle 660 8388608 33
0x00000000 294915 oracle 660 134217728 33
0x00000000 327684 oracle 660 134217728 33
0x00000000 360453 oracle 660 134217728 33
0x62b091ac 393222 oracle 660 115343360 33
------ Semaphore Arrays --------
key semid owner perms nsems
0x1497e4d8 393217 oracle 660 164
key semid owner perms nsems
0x1497e4d8 393217 oracle 660 164
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> exit
logout
oracle:~ # su - oracle
oracle@oracle:~> sqlplus / as sysdba
logout
oracle:~ # su - oracle
oracle@oracle:~> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 7月 30 21:17:43 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl#start force
SP2-0310: 无法打开文件 "force.sql"
SYS@orcl#startup force
ORACLE 例程已经启动。
SP2-0310: 无法打开文件 "force.sql"
SYS@orcl#startup force
ORACLE 例程已经启动。
Total System Global Area 521936896 bytes
Fixed Size 2145984 bytes
Variable Size 352321856 bytes
Database Buffers 163577856 bytes
Redo Buffers 3891200 bytes
数据库装载完毕。
数据库已经打开。
SYS@orcl#!
oracle@oracle:~> ipcs -a
Fixed Size 2145984 bytes
Variable Size 352321856 bytes
Database Buffers 163577856 bytes
Redo Buffers 3891200 bytes
数据库装载完毕。
数据库已经打开。
SYS@orcl#!
oracle@oracle:~> ipcs -a
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x62b091ac 458754 oracle 660 526385152 34
key shmid owner perms bytes nattch status
0x62b091ac 458754 oracle 660 526385152 34
------ Semaphore Arrays --------
key semid owner perms nsems
0x1497e4d8 524289 oracle 660 164
key semid owner perms nsems
0x1497e4d8 524289 oracle 660 164
------ Message Queues --------
key msqid owner perms used-bytes messages
key msqid owner perms used-bytes messages
oracle@oracle:~> ps -ef | grep oracle
oracle 6110 5031 0 21:17 pts/0 00:00:00 su - oracle
oracle 6111 6110 0 21:17 pts/0 00:00:00 -bash
oracle 6142 6111 0 21:17 pts/0 00:00:00 sqlplus as sysdba
oracle 6147 1 0 21:17 ? 00:00:00 ora_pmon_orcl
oracle 6149 1 0 21:17 ? 00:00:00 ora_vktm_orcl
oracle 6153 1 0 21:17 ? 00:00:00 ora_diag_orcl
oracle 6155 1 0 21:17 ? 00:00:00 ora_dbrm_orcl
oracle 6157 1 0 21:17 ? 00:00:00 ora_psp0_orcl
oracle 6161 1 0 21:17 ? 00:00:00 ora_dia0_orcl
oracle 6163 1 0 21:17 ? 00:00:00 ora_mman_orcl
oracle 6165 1 0 21:17 ? 00:00:00 ora_dbw0_orcl
oracle 6167 1 0 21:17 ? 00:00:00 ora_lgwr_orcl
oracle 6169 1 0 21:17 ? 00:00:00 ora_ckpt_orcl
oracle 6171 1 0 21:17 ? 00:00:00 ora_smon_orcl
oracle 6173 1 0 21:17 ? 00:00:00 ora_reco_orcl
oracle 6175 1 1 21:17 ? 00:00:01 ora_mmon_orcl
oracle 6177 1 0 21:17 ? 00:00:00 ora_mmnl_orcl
oracle 6179 1 0 21:17 ? 00:00:00 ora_d000_orcl
oracle 6181 1 0 21:17 ? 00:00:00 ora_s000_orcl
oracle 6183 1 0 21:17 ? 00:00:00 ora_s001_orcl
oracle 6185 1 0 21:17 ? 00:00:00 ora_s002_orcl
oracle 6187 1 0 21:17 ? 00:00:00 ora_s003_orcl
oracle 6189 1 0 21:17 ? 00:00:00 ora_s004_orcl
oracle 6191 1 0 21:17 ? 00:00:00 ora_s005_orcl
oracle 6193 1 0 21:17 ? 00:00:00 ora_s006_orcl
oracle 6199 6142 6 21:18 ? 00:00:05 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6205 1 0 21:18 ? 00:00:00 ora_arc0_orcl
oracle 6207 1 0 21:18 ? 00:00:00 ora_arc1_orcl
oracle 6209 1 0 21:18 ? 00:00:00 ora_arc2_orcl
oracle 6211 1 0 21:18 ? 00:00:00 ora_arc3_orcl
oracle 6213 1 0 21:18 ? 00:00:00 ora_ctwr_orcl
oracle 6215 1 0 21:18 ? 00:00:00 ora_smco_orcl
oracle 6217 1 0 21:18 ? 00:00:00 ora_fbda_orcl
oracle 6219 1 0 21:18 ? 00:00:00 ora_qmnc_orcl
oracle 6221 1 0 21:18 ? 00:00:00 ora_w000_orcl
oracle 6235 1 0 21:18 ? 00:00:00 ora_q000_orcl
oracle 6237 1 0 21:18 ? 00:00:00 ora_q001_orcl
oracle 6239 6142 0 21:19 pts/0 00:00:00 /bin/bash
oracle 6255 6239 0 21:19 pts/0 00:00:00 ps -ef
oracle 6256 6239 0 21:19 pts/0 00:00:00 grep oracle
oracle@oracle:~> pmap 6147
6147: oracle
START SIZE RSS DIRTY PERM MAPPING
00400000 137196K 10576K 0K r-xp /opt/oracle/product/10.2/db_1/bin/oracle
08afa000 11980K 280K 64K rwxp /opt/oracle/product/10.2/db_1/bin/oracle
096ad000 716K 616K 616K rwxp [heap]
60000000 514048K 2400K 520K rwxs /SYSV62b091ac
2b3a47f14000 108K 100K 0K r-xp /lib64/ld-2.4.so
2b3a47f2f000 8K 8K 8K rwxp [anon]
2b3a4802e000 8K 8K 8K rwxp /lib64/ld-2.4.so
2b3a48030000 252K 84K 44K r-xp /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4806f000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4816e000 8K 8K 8K rwxp /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a48194000 32K 16K 0K r-xp /lib64/librt-2.4.so
2b3a4819c000 1020K 0K 0K ---p /lib64/librt-2.4.so
2b3a4829b000 8K 8K 8K rwxp /lib64/librt-2.4.so
2b3a4829d000 2732K 956K 452K r-xp /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48548000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48647000 712K 268K 268K rwxp /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a486f9000 8K 4K 4K rwxp [anon]
2b3a486fb000 40K 24K 8K r-xp /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48705000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48804000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48805000 128K 56K 32K r-xp /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48825000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48924000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48925000 760K 188K 48K r-xp /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a489e3000 1024K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae3000 12K 12K 12K rwxp /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae6000 12K 8K 8K rwxp [anon]
2b3a48ae9000 8K 8K 8K r-xp /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48aeb000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48bea000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48beb000 460K 60K 20K r-xp /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48c5e000 1024K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d5e000 8K 8K 8K rwxp /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d60000 360K 56K 20K r-xp /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48dba000 1024K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48eba000 8K 8K 8K rwxp /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48ebc000 4K 4K 4K rwxp [anon]
2b3a48ebd000 40K 24K 8K r-xp /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48ec7000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc6000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc7000 4K 4K 0K r-xp /usr/lib64/libaio.so.1.0.1
2b3a48fc8000 1020K 0K 0K ---p /usr/lib64/libaio.so.1.0.1
2b3a490c7000 4K 4K 4K rwxp /usr/lib64/libaio.so.1.0.1
2b3a490c8000 8K 8K 0K r-xp /lib64/libdl-2.4.so
2b3a490ca000 1024K 0K 0K ---p /lib64/libdl-2.4.so
2b3a491ca000 8K 8K 8K rwxp /lib64/libdl-2.4.so
2b3a491cc000 4K 4K 4K rwxp [anon]
2b3a491cd000 336K 32K 0K r-xp /lib64/libm-2.4.so
2b3a49221000 1020K 0K 0K ---p /lib64/libm-2.4.so
2b3a49320000 8K 8K 8K rwxp /lib64/libm-2.4.so
2b3a49322000 80K 60K 0K r-xp /lib64/libpthread-2.4.so
2b3a49336000 1020K 0K 0K ---p /lib64/libpthread-2.4.so
2b3a49435000 8K 8K 8K rwxp /lib64/libpthread-2.4.so
2b3a49437000 16K 4K 4K rwxp [anon]
2b3a4943b000 76K 24K 0K r-xp /lib64/libnsl-2.4.so
2b3a4944e000 1020K 0K 0K ---p /lib64/libnsl-2.4.so
2b3a4954d000 8K 8K 8K rwxp /lib64/libnsl-2.4.so
2b3a4954f000 12K 4K 4K rwxp [anon]
2b3a49552000 1240K 504K 0K r-xp /lib64/libc-2.4.so
2b3a49688000 1024K 0K 0K ---p /lib64/libc-2.4.so
2b3a49788000 12K 12K 12K r-xp /lib64/libc-2.4.so
2b3a4978b000 8K 8K 8K rwxp /lib64/libc-2.4.so
2b3a4978d000 2000K 428K 428K rwxp [anon]
2b3a49981000 60K 12K 12K rwxp /dev/zero
2b3a49990000 64K 12K 12K rwxp /dev/zero
2b3a499a0000 64K 28K 28K rwxp /dev/zero
2b3a499b0000 64K 40K 40K rwxp /dev/zero
2b3a499c0000 64K 64K 64K rwxp /dev/zero
2b3a499d0000 64K 16K 16K rwxp /dev/zero
2b3a499e0000 132K 0K 0K rwxp /dev/zero
2b3a49a01000 8K 8K 8K rwxp [anon]
2b3a49a03000 212K 4K 0K r-xs /var/run/nscd/passwd
2b3a49a38000 4K 4K 4K rwxs /opt/oracle/product/10.2/db_1/dbs/hc_orcl.dat
2b3a49a39000 32K 28K 20K r-xp /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49a41000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b40000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b41000 1044K 24K 24K rwxp [anon]
2b3a49c46000 212K 4K 0K r-xs /var/run/nscd/dbtGfPJL
7fff62b80000 88K 44K 44K rwxp [stack]
ffffffffff600000 8192K 0K 0K ---p [vdso]
Total: 701172K 17224K 2972K
oracle 6110 5031 0 21:17 pts/0 00:00:00 su - oracle
oracle 6111 6110 0 21:17 pts/0 00:00:00 -bash
oracle 6142 6111 0 21:17 pts/0 00:00:00 sqlplus as sysdba
oracle 6147 1 0 21:17 ? 00:00:00 ora_pmon_orcl
oracle 6149 1 0 21:17 ? 00:00:00 ora_vktm_orcl
oracle 6153 1 0 21:17 ? 00:00:00 ora_diag_orcl
oracle 6155 1 0 21:17 ? 00:00:00 ora_dbrm_orcl
oracle 6157 1 0 21:17 ? 00:00:00 ora_psp0_orcl
oracle 6161 1 0 21:17 ? 00:00:00 ora_dia0_orcl
oracle 6163 1 0 21:17 ? 00:00:00 ora_mman_orcl
oracle 6165 1 0 21:17 ? 00:00:00 ora_dbw0_orcl
oracle 6167 1 0 21:17 ? 00:00:00 ora_lgwr_orcl
oracle 6169 1 0 21:17 ? 00:00:00 ora_ckpt_orcl
oracle 6171 1 0 21:17 ? 00:00:00 ora_smon_orcl
oracle 6173 1 0 21:17 ? 00:00:00 ora_reco_orcl
oracle 6175 1 1 21:17 ? 00:00:01 ora_mmon_orcl
oracle 6177 1 0 21:17 ? 00:00:00 ora_mmnl_orcl
oracle 6179 1 0 21:17 ? 00:00:00 ora_d000_orcl
oracle 6181 1 0 21:17 ? 00:00:00 ora_s000_orcl
oracle 6183 1 0 21:17 ? 00:00:00 ora_s001_orcl
oracle 6185 1 0 21:17 ? 00:00:00 ora_s002_orcl
oracle 6187 1 0 21:17 ? 00:00:00 ora_s003_orcl
oracle 6189 1 0 21:17 ? 00:00:00 ora_s004_orcl
oracle 6191 1 0 21:17 ? 00:00:00 ora_s005_orcl
oracle 6193 1 0 21:17 ? 00:00:00 ora_s006_orcl
oracle 6199 6142 6 21:18 ? 00:00:05 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6205 1 0 21:18 ? 00:00:00 ora_arc0_orcl
oracle 6207 1 0 21:18 ? 00:00:00 ora_arc1_orcl
oracle 6209 1 0 21:18 ? 00:00:00 ora_arc2_orcl
oracle 6211 1 0 21:18 ? 00:00:00 ora_arc3_orcl
oracle 6213 1 0 21:18 ? 00:00:00 ora_ctwr_orcl
oracle 6215 1 0 21:18 ? 00:00:00 ora_smco_orcl
oracle 6217 1 0 21:18 ? 00:00:00 ora_fbda_orcl
oracle 6219 1 0 21:18 ? 00:00:00 ora_qmnc_orcl
oracle 6221 1 0 21:18 ? 00:00:00 ora_w000_orcl
oracle 6235 1 0 21:18 ? 00:00:00 ora_q000_orcl
oracle 6237 1 0 21:18 ? 00:00:00 ora_q001_orcl
oracle 6239 6142 0 21:19 pts/0 00:00:00 /bin/bash
oracle 6255 6239 0 21:19 pts/0 00:00:00 ps -ef
oracle 6256 6239 0 21:19 pts/0 00:00:00 grep oracle
oracle@oracle:~> pmap 6147
6147: oracle
START SIZE RSS DIRTY PERM MAPPING
00400000 137196K 10576K 0K r-xp /opt/oracle/product/10.2/db_1/bin/oracle
08afa000 11980K 280K 64K rwxp /opt/oracle/product/10.2/db_1/bin/oracle
096ad000 716K 616K 616K rwxp [heap]
60000000 514048K 2400K 520K rwxs /SYSV62b091ac
2b3a47f14000 108K 100K 0K r-xp /lib64/ld-2.4.so
2b3a47f2f000 8K 8K 8K rwxp [anon]
2b3a4802e000 8K 8K 8K rwxp /lib64/ld-2.4.so
2b3a48030000 252K 84K 44K r-xp /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4806f000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4816e000 8K 8K 8K rwxp /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a48194000 32K 16K 0K r-xp /lib64/librt-2.4.so
2b3a4819c000 1020K 0K 0K ---p /lib64/librt-2.4.so
2b3a4829b000 8K 8K 8K rwxp /lib64/librt-2.4.so
2b3a4829d000 2732K 956K 452K r-xp /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48548000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48647000 712K 268K 268K rwxp /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a486f9000 8K 4K 4K rwxp [anon]
2b3a486fb000 40K 24K 8K r-xp /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48705000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48804000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48805000 128K 56K 32K r-xp /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48825000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48924000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48925000 760K 188K 48K r-xp /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a489e3000 1024K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae3000 12K 12K 12K rwxp /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae6000 12K 8K 8K rwxp [anon]
2b3a48ae9000 8K 8K 8K r-xp /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48aeb000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48bea000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48beb000 460K 60K 20K r-xp /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48c5e000 1024K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d5e000 8K 8K 8K rwxp /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d60000 360K 56K 20K r-xp /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48dba000 1024K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48eba000 8K 8K 8K rwxp /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48ebc000 4K 4K 4K rwxp [anon]
2b3a48ebd000 40K 24K 8K r-xp /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48ec7000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc6000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc7000 4K 4K 0K r-xp /usr/lib64/libaio.so.1.0.1
2b3a48fc8000 1020K 0K 0K ---p /usr/lib64/libaio.so.1.0.1
2b3a490c7000 4K 4K 4K rwxp /usr/lib64/libaio.so.1.0.1
2b3a490c8000 8K 8K 0K r-xp /lib64/libdl-2.4.so
2b3a490ca000 1024K 0K 0K ---p /lib64/libdl-2.4.so
2b3a491ca000 8K 8K 8K rwxp /lib64/libdl-2.4.so
2b3a491cc000 4K 4K 4K rwxp [anon]
2b3a491cd000 336K 32K 0K r-xp /lib64/libm-2.4.so
2b3a49221000 1020K 0K 0K ---p /lib64/libm-2.4.so
2b3a49320000 8K 8K 8K rwxp /lib64/libm-2.4.so
2b3a49322000 80K 60K 0K r-xp /lib64/libpthread-2.4.so
2b3a49336000 1020K 0K 0K ---p /lib64/libpthread-2.4.so
2b3a49435000 8K 8K 8K rwxp /lib64/libpthread-2.4.so
2b3a49437000 16K 4K 4K rwxp [anon]
2b3a4943b000 76K 24K 0K r-xp /lib64/libnsl-2.4.so
2b3a4944e000 1020K 0K 0K ---p /lib64/libnsl-2.4.so
2b3a4954d000 8K 8K 8K rwxp /lib64/libnsl-2.4.so
2b3a4954f000 12K 4K 4K rwxp [anon]
2b3a49552000 1240K 504K 0K r-xp /lib64/libc-2.4.so
2b3a49688000 1024K 0K 0K ---p /lib64/libc-2.4.so
2b3a49788000 12K 12K 12K r-xp /lib64/libc-2.4.so
2b3a4978b000 8K 8K 8K rwxp /lib64/libc-2.4.so
2b3a4978d000 2000K 428K 428K rwxp [anon]
2b3a49981000 60K 12K 12K rwxp /dev/zero
2b3a49990000 64K 12K 12K rwxp /dev/zero
2b3a499a0000 64K 28K 28K rwxp /dev/zero
2b3a499b0000 64K 40K 40K rwxp /dev/zero
2b3a499c0000 64K 64K 64K rwxp /dev/zero
2b3a499d0000 64K 16K 16K rwxp /dev/zero
2b3a499e0000 132K 0K 0K rwxp /dev/zero
2b3a49a01000 8K 8K 8K rwxp [anon]
2b3a49a03000 212K 4K 0K r-xs /var/run/nscd/passwd
2b3a49a38000 4K 4K 4K rwxs /opt/oracle/product/10.2/db_1/dbs/hc_orcl.dat
2b3a49a39000 32K 28K 20K r-xp /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49a41000 1020K 0K 0K ---p /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b40000 4K 4K 4K rwxp /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b41000 1044K 24K 24K rwxp [anon]
2b3a49c46000 212K 4K 0K r-xs /var/run/nscd/dbtGfPJL
7fff62b80000 88K 44K 44K rwxp [stack]
ffffffffff600000 8192K 0K 0K ---p [vdso]
Total: 701172K 17224K 2972K
17240K writable-private, 169456K readonly-private, and 514476K shared
oracle@oracle:~> more /proc/61
6110/ 6142/ 6149/ 6155/ 6161/ 6165/ 6169/ 6173/ 6177/ 6181/ 6185/ 6189/ 6193/
6111/ 6147/ 6153/ 6157/ 6163/ 6167/ 6171/ 6175/ 6179/ 6183/ 6187/ 6191/ 6199/
oracle@oracle:~> more /proc/61
6110/ 6142/ 6149/ 6155/ 6161/ 6165/ 6169/ 6173/ 6177/ 6181/ 6185/ 6189/ 6193/
6111/ 6147/ 6153/ 6157/ 6163/ 6167/ 6171/ 6175/ 6179/ 6183/ 6187/ 6191/ 6199/
oracle@oracle:~> more /proc/6147/
attr/ cmdline environ fd/ mapped_base mem oom_adj root/ smaps statm task/
auxv cwd/ exe loginuid maps mounts oom_score seccomp stat status wchan
oracle@oracle:~> more /proc/6147/maps
00400000-089fb000 r-xp 00000000 08:02 231127 /opt/oracle/product/10.2/db_1/bin/oracle
08afa000-096ad000 rwxp 085fa000 08:02 231127 /opt/oracle/product/10.2/db_1/bin/oracle
096ad000-09760000 rwxp 096ad000 00:00 0 [heap]
60000000-7f600000 rwxs 00000000 00:07 458754 /SYSV62b091ac (deleted)
2b3a47f14000-2b3a47f2f000 r-xp 00000000 08:02 18664 /lib64/ld-2.4.so
2b3a47f2f000-2b3a47f31000 rwxp 2b3a47f2f000 00:00 0
2b3a4802e000-2b3a48030000 rwxp 0001a000 08:02 18664 /lib64/ld-2.4.so
2b3a48030000-2b3a4806f000 r-xp 00000000 08:02 171187 /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4806f000-2b3a4816e000 ---p 0003f000 08:02 171187 /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4816e000-2b3a48170000 rwxp 0003e000 08:02 171187 /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a48194000-2b3a4819c000 r-xp 00000000 08:02 18701 /lib64/librt-2.4.so
2b3a4819c000-2b3a4829b000 ---p 00008000 08:02 18701 /lib64/librt-2.4.so
2b3a4829b000-2b3a4829d000 rwxp 00007000 08:02 18701 /lib64/librt-2.4.so
2b3a4829d000-2b3a48548000 r-xp 00000000 08:02 220466 /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48548000-2b3a48647000 ---p 002ab000 08:02 220466 /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48647000-2b3a486f9000 rwxp 002aa000 08:02 220466 /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a486f9000-2b3a486fb000 rwxp 2b3a486f9000 00:00 0
2b3a486fb000-2b3a48705000 r-xp 00000000 08:02 220388 /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48705000-2b3a48804000 ---p 0000a000 08:02 220388 /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48804000-2b3a48805000 rwxp 00009000 08:02 220388 /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48805000-2b3a48825000 r-xp 00000000 08:02 175802 /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48825000-2b3a48924000 ---p 00020000 08:02 175802 /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48924000-2b3a48925000 rwxp 0001f000 08:02 175802 /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48925000-2b3a489e3000 r-xp 00000000 08:02 220387 /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a489e3000-2b3a48ae3000 ---p 000be000 08:02 220387 /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae3000-2b3a48ae6000 rwxp 000be000 08:02 220387 /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae6000-2b3a48ae9000 rwxp 2b3a48ae6000 00:00 0
2b3a48ae9000-2b3a48aeb000 r-xp 00000000 08:02 176298 /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48aeb000-2b3a48bea000 ---p 00002000 08:02 176298 /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48bea000-2b3a48beb000 rwxp 00001000 08:02 176298 /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48beb000-2b3a48c5e000 r-xp 00000000 08:02 220384 /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48c5e000-2b3a48d5e000 ---p 00073000 08:02 220384 /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d5e000-2b3a48d60000 rwxp 00073000 08:02 220384 /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d60000-2b3a48dba000 r-xp 00000000 08:02 220385 /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48dba000-2b3a48eba000 ---p 0005a000 08:02 220385 /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48eba000-2b3a48ebc000 rwxp 0005a000 08:02 220385 /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48ebc000-2b3a48ebd000 rwxp 2b3a48ebc000 00:00 0
2b3a48ebd000-2b3a48ec7000 r-xp 00000000 08:02 220386 /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48ec7000-2b3a48fc6000 ---p 0000a000 08:02 220386 /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc6000-2b3a48fc7000 rwxp 00009000 08:02 220386 /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc7000-2b3a48fc8000 r-xp 00000000 08:02 30242 /usr/lib64/libaio.so.1.0.1
2b3a48fc8000-2b3a490c7000 ---p 00001000 08:02 30242 /usr/lib64/libaio.so.1.0.1
2b3a490c7000-2b3a490c8000 rwxp 00000000 08:02 30242 /usr/lib64/libaio.so.1.0.1
2b3a490c8000-2b3a490ca000 r-xp 00000000 08:02 18677 /lib64/libdl-2.4.so
2b3a490ca000-2b3a491ca000 ---p 00002000 08:02 18677 /lib64/libdl-2.4.so
2b3a491ca000-2b3a491cc000 rwxp 00002000 08:02 18677 /lib64/libdl-2.4.so
2b3a491cc000-2b3a491cd000 rwxp 2b3a491cc000 00:00 0
2b3a491cd000-2b3a49221000 r-xp 00000000 08:02 18679 /lib64/libm-2.4.so
2b3a49221000-2b3a49320000 ---p 00054000 08:02 18679 /lib64/libm-2.4.so
2b3a49320000-2b3a49322000 rwxp 00053000 08:02 18679 /lib64/libm-2.4.so
2b3a49322000-2b3a49336000 r-xp 00000000 08:02 18697 /lib64/libpthread-2.4.so
2b3a49336000-2b3a49435000 ---p 00014000 08:02 18697 /lib64/libpthread-2.4.so
2b3a49435000-2b3a49437000 rwxp 00013000 08:02 18697 /lib64/libpthread-2.4.so
2b3a49437000-2b3a4943b000 rwxp 2b3a49437000 00:00 0
2b3a4943b000-2b3a4944e000 r-xp 00000000 08:02 18682 /lib64/libnsl-2.4.so
2b3a4944e000-2b3a4954d000 ---p 00013000 08:02 18682 /lib64/libnsl-2.4.so
2b3a4954d000-2b3a4954f000 rwxp 00012000 08:02 18682 /lib64/libnsl-2.4.so
2b3a4954f000-2b3a49552000 rwxp 2b3a4954f000 00:00 0
2b3a49552000-2b3a49688000 r-xp 00000000 08:02 18671 /lib64/libc-2.4.so
2b3a49688000-2b3a49788000 ---p 00136000 08:02 18671 /lib64/libc-2.4.so
2b3a49788000-2b3a4978b000 r-xp 00136000 08:02 18671 /lib64/libc-2.4.so
2b3a4978b000-2b3a4978d000 rwxp 00139000 08:02 18671 /lib64/libc-2.4.so
2b3a4978d000-2b3a49981000 rwxp 2b3a4978d000 00:00 0
2b3a49981000-2b3a49990000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a49990000-2b3a499a0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499a0000-2b3a499b0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499b0000-2b3a499c0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499c0000-2b3a499d0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499d0000-2b3a499e0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499e0000-2b3a49a01000 rwxp 0005f000 00:0d 3061 /dev/zero
2b3a49a01000-2b3a49a03000 rwxp 2b3a49a01000 00:00 0
2b3a49a03000-2b3a49a38000 r-xs 00000000 08:02 154858 /var/run/nscd/passwd
2b3a49a38000-2b3a49a39000 rwxs 00000000 08:02 157822 /opt/oracle/product/10.2/db_1/dbs/hc_orcl.dat
2b3a49a39000-2b3a49a41000 r-xp 00000000 08:02 220442 /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49a41000-2b3a49b40000 ---p 00008000 08:02 220442 /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b40000-2b3a49b41000 rwxp 00007000 08:02 220442 /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b41000-2b3a49c46000 rwxp 2b3a49b41000 00:00 0
2b3a49c46000-2b3a49c7b000 r-xs 00000000 08:02 154870 /var/run/nscd/dbtGfPJL (deleted)
7fff62b80000-7fff62b96000 rwxp 7fff62b80000 00:00 0 [stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso]
oracle@oracle:~> more /proc/61
6110/ 6142/ 6149/ 6155/ 6161/ 6165/ 6169/ 6173/ 6177/ 6181/ 6185/ 6189/ 6193/
6111/ 6147/ 6153/ 6157/ 6163/ 6167/ 6171/ 6175/ 6179/ 6183/ 6187/ 6191/ 6199/
oracle@oracle:~> more /proc/61
6110/ 6142/ 6149/ 6155/ 6161/ 6165/ 6169/ 6173/ 6177/ 6181/ 6185/ 6189/ 6193/
6111/ 6147/ 6153/ 6157/ 6163/ 6167/ 6171/ 6175/ 6179/ 6183/ 6187/ 6191/ 6199/
oracle@oracle:~> more /proc/6147/
attr/ cmdline environ fd/ mapped_base mem oom_adj root/ smaps statm task/
auxv cwd/ exe loginuid maps mounts oom_score seccomp stat status wchan
oracle@oracle:~> more /proc/6147/maps
00400000-089fb000 r-xp 00000000 08:02 231127 /opt/oracle/product/10.2/db_1/bin/oracle
08afa000-096ad000 rwxp 085fa000 08:02 231127 /opt/oracle/product/10.2/db_1/bin/oracle
096ad000-09760000 rwxp 096ad000 00:00 0 [heap]
60000000-7f600000 rwxs 00000000 00:07 458754 /SYSV62b091ac (deleted)
2b3a47f14000-2b3a47f2f000 r-xp 00000000 08:02 18664 /lib64/ld-2.4.so
2b3a47f2f000-2b3a47f31000 rwxp 2b3a47f2f000 00:00 0
2b3a4802e000-2b3a48030000 rwxp 0001a000 08:02 18664 /lib64/ld-2.4.so
2b3a48030000-2b3a4806f000 r-xp 00000000 08:02 171187 /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4806f000-2b3a4816e000 ---p 0003f000 08:02 171187 /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a4816e000-2b3a48170000 rwxp 0003e000 08:02 171187 /opt/oracle/product/10.2/db_1/lib/libskgxp11.so
2b3a48194000-2b3a4819c000 r-xp 00000000 08:02 18701 /lib64/librt-2.4.so
2b3a4819c000-2b3a4829b000 ---p 00008000 08:02 18701 /lib64/librt-2.4.so
2b3a4829b000-2b3a4829d000 rwxp 00007000 08:02 18701 /lib64/librt-2.4.so
2b3a4829d000-2b3a48548000 r-xp 00000000 08:02 220466 /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48548000-2b3a48647000 ---p 002ab000 08:02 220466 /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a48647000-2b3a486f9000 rwxp 002aa000 08:02 220466 /opt/oracle/product/10.2/db_1/lib/libnnz11.so
2b3a486f9000-2b3a486fb000 rwxp 2b3a486f9000 00:00 0
2b3a486fb000-2b3a48705000 r-xp 00000000 08:02 220388 /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48705000-2b3a48804000 ---p 0000a000 08:02 220388 /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48804000-2b3a48805000 rwxp 00009000 08:02 220388 /opt/oracle/product/10.2/db_1/lib/libclsra11.so
2b3a48805000-2b3a48825000 r-xp 00000000 08:02 175802 /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48825000-2b3a48924000 ---p 00020000 08:02 175802 /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48924000-2b3a48925000 rwxp 0001f000 08:02 175802 /opt/oracle/product/10.2/db_1/lib/libdbcfg11.so
2b3a48925000-2b3a489e3000 r-xp 00000000 08:02 220387 /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a489e3000-2b3a48ae3000 ---p 000be000 08:02 220387 /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae3000-2b3a48ae6000 rwxp 000be000 08:02 220387 /opt/oracle/product/10.2/db_1/lib/libhasgen11.so
2b3a48ae6000-2b3a48ae9000 rwxp 2b3a48ae6000 00:00 0
2b3a48ae9000-2b3a48aeb000 r-xp 00000000 08:02 176298 /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48aeb000-2b3a48bea000 ---p 00002000 08:02 176298 /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48bea000-2b3a48beb000 rwxp 00001000 08:02 176298 /opt/oracle/product/10.2/db_1/lib/libskgxn2.so
2b3a48beb000-2b3a48c5e000 r-xp 00000000 08:02 220384 /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48c5e000-2b3a48d5e000 ---p 00073000 08:02 220384 /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d5e000-2b3a48d60000 rwxp 00073000 08:02 220384 /opt/oracle/product/10.2/db_1/lib/libocr11.so
2b3a48d60000-2b3a48dba000 r-xp 00000000 08:02 220385 /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48dba000-2b3a48eba000 ---p 0005a000 08:02 220385 /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48eba000-2b3a48ebc000 rwxp 0005a000 08:02 220385 /opt/oracle/product/10.2/db_1/lib/libocrb11.so
2b3a48ebc000-2b3a48ebd000 rwxp 2b3a48ebc000 00:00 0
2b3a48ebd000-2b3a48ec7000 r-xp 00000000 08:02 220386 /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48ec7000-2b3a48fc6000 ---p 0000a000 08:02 220386 /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc6000-2b3a48fc7000 rwxp 00009000 08:02 220386 /opt/oracle/product/10.2/db_1/lib/libocrutl11.so
2b3a48fc7000-2b3a48fc8000 r-xp 00000000 08:02 30242 /usr/lib64/libaio.so.1.0.1
2b3a48fc8000-2b3a490c7000 ---p 00001000 08:02 30242 /usr/lib64/libaio.so.1.0.1
2b3a490c7000-2b3a490c8000 rwxp 00000000 08:02 30242 /usr/lib64/libaio.so.1.0.1
2b3a490c8000-2b3a490ca000 r-xp 00000000 08:02 18677 /lib64/libdl-2.4.so
2b3a490ca000-2b3a491ca000 ---p 00002000 08:02 18677 /lib64/libdl-2.4.so
2b3a491ca000-2b3a491cc000 rwxp 00002000 08:02 18677 /lib64/libdl-2.4.so
2b3a491cc000-2b3a491cd000 rwxp 2b3a491cc000 00:00 0
2b3a491cd000-2b3a49221000 r-xp 00000000 08:02 18679 /lib64/libm-2.4.so
2b3a49221000-2b3a49320000 ---p 00054000 08:02 18679 /lib64/libm-2.4.so
2b3a49320000-2b3a49322000 rwxp 00053000 08:02 18679 /lib64/libm-2.4.so
2b3a49322000-2b3a49336000 r-xp 00000000 08:02 18697 /lib64/libpthread-2.4.so
2b3a49336000-2b3a49435000 ---p 00014000 08:02 18697 /lib64/libpthread-2.4.so
2b3a49435000-2b3a49437000 rwxp 00013000 08:02 18697 /lib64/libpthread-2.4.so
2b3a49437000-2b3a4943b000 rwxp 2b3a49437000 00:00 0
2b3a4943b000-2b3a4944e000 r-xp 00000000 08:02 18682 /lib64/libnsl-2.4.so
2b3a4944e000-2b3a4954d000 ---p 00013000 08:02 18682 /lib64/libnsl-2.4.so
2b3a4954d000-2b3a4954f000 rwxp 00012000 08:02 18682 /lib64/libnsl-2.4.so
2b3a4954f000-2b3a49552000 rwxp 2b3a4954f000 00:00 0
2b3a49552000-2b3a49688000 r-xp 00000000 08:02 18671 /lib64/libc-2.4.so
2b3a49688000-2b3a49788000 ---p 00136000 08:02 18671 /lib64/libc-2.4.so
2b3a49788000-2b3a4978b000 r-xp 00136000 08:02 18671 /lib64/libc-2.4.so
2b3a4978b000-2b3a4978d000 rwxp 00139000 08:02 18671 /lib64/libc-2.4.so
2b3a4978d000-2b3a49981000 rwxp 2b3a4978d000 00:00 0
2b3a49981000-2b3a49990000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a49990000-2b3a499a0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499a0000-2b3a499b0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499b0000-2b3a499c0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499c0000-2b3a499d0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499d0000-2b3a499e0000 rwxp 00000000 00:0d 3061 /dev/zero
2b3a499e0000-2b3a49a01000 rwxp 0005f000 00:0d 3061 /dev/zero
2b3a49a01000-2b3a49a03000 rwxp 2b3a49a01000 00:00 0
2b3a49a03000-2b3a49a38000 r-xs 00000000 08:02 154858 /var/run/nscd/passwd
2b3a49a38000-2b3a49a39000 rwxs 00000000 08:02 157822 /opt/oracle/product/10.2/db_1/dbs/hc_orcl.dat
2b3a49a39000-2b3a49a41000 r-xp 00000000 08:02 220442 /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49a41000-2b3a49b40000 ---p 00008000 08:02 220442 /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b40000-2b3a49b41000 rwxp 00007000 08:02 220442 /opt/oracle/product/10.2/db_1/lib/libnque11.so
2b3a49b41000-2b3a49c46000 rwxp 2b3a49b41000 00:00 0
2b3a49c46000-2b3a49c7b000 r-xs 00000000 08:02 154870 /var/run/nscd/dbtGfPJL (deleted)
7fff62b80000-7fff62b96000 rwxp 7fff62b80000 00:00 0 [stack]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso]
- oracle之 sga（一）
- Oracle体系结构(一)---PGA && SGA
- oracle SGA 笔记（一） 数据库缓冲区内部机制
- 浅谈oracle 内存结构（一） 系统全局区 SGA
- ORACLE SGA之shared pool
- ORACLE--SGA之数据缓冲区（Data Buffer）
- Oracle SGA （内存控制）
- oracle SGA（11g）
- oracle基础2 （SGA）
- oracle组件之SGA,PGA和DATABASE
- Oracle - SGA → Data_buffer_cache 之 Keep pool
- Oracle SGA
- oracle sga
- Oracle SGA
- Oracle之内存结构（SGA、PGA）
- Oracle之内存结构（SGA、PGA）
- Oracle之内存结构（SGA、PGA）
- Oracle之内存结构（SGA、PGA）
- Maven系列四：持续集成：Jenkins-CI
- hdu 2005 第几天？
- jsf+spring+hibernate集成
- Java中List，ArrayList、Vector，map，HashTable，HashMap区别用法
- HDU1950：Bridging signals(LIS)
- oracle之 sga（一）
- 黑马程序员_论坛活动：递归实现猴子吃桃
- 其他知识
- 【webpy】webpy笔记
- 数字图像处理：6.旋转图像
- 推荐几个ACM网站
- 数据库
- 【Android】Toast大全
- 如何选择Linux工具书
