- 浏览: 1303820 次
- 性别:
- 来自: 合肥
文章分类
- 全部博客 (404)
- ToDoList (24)
- 项目管理 (39)
- REDMINE (1)
- Oracle (32)
- 杂文 (21)
- 管理 (19)
- Java (6)
- 全文搜索 (1)
- 编程语言排名 (4)
- 人力资源 (5)
- SVN (1)
- CMMI (2)
- VER (1)
- VAL (1)
- 其他 (8)
- OceanBase (1)
- IT PRO (2)
- KVM (1)
- Access (1)
- Drupal (3)
- mysql (4)
- 理财 (1)
- 读书笔记 (6)
- 个人总结 (16)
- 我的推荐 (13)
- REDMINE培训材料 (0)
- 随笔 (10)
- AIX (1)
- 管理故事 (12)
- 工具推荐 (6)
- 系统架构 (5)
- 免费活动 (3)
- 名词解释 (3)
- Apache (5)
- mongrel (4)
- redmine插件 (0)
- 知识管理 (4)
- REDMINE第三方应用 (5)
- redmine问题 (0)
- NOSQL (1)
- UML (1)
- SQLite (1)
- use case,UML (1)
- nginx (5)
- 规划 (1)
- 系统思考 (1)
- resin (2)
- android (43)
- android代码 (10)
- HTML5 (1)
- 移动开发 (4)
- android问题 (3)
- DB2 (4)
- http (1)
- LBS (1)
- IT职业规划 (11)
- 微信 (1)
- 就业 (1)
- google (2)
- 微信开发 (2)
- js (1)
- Anroid (1)
- Service Worker (1)
- weblogic (2)
- 测试 (1)
- weblogi (1)
- vue (4)
- jeeplus (1)
- ureport (1)
最新评论
-
Caelebs:
上海交大?ms工作六年?感觉好屌啊我厂一堆10K 20K 98 ...
IT人为什么难以拿到高薪? -
小桔子:
如果加入listView 在滑动的时候偶尔会空指针异常,加入P ...
Android组件推荐-侧滑效果DragLayout -
wangyonglin1123:
小公司是锻炼人的 不管是业务技术都会有突飞猛进的进度 进步 ...
程序员在大公司工作好?还是在小公司工作?我的经历和建议[ZT] -
wangyonglin1123:
必须有所专长 技术和业务都需要 你必须在一个行业够牛逼
程序员的出路之一,拥有一技之长、打造自己的精品、更广阔的市场【ZT】 -
luhuajcdd:
这个不错
StarUML 不能在64位的windows7下运行,提示错误的解决方案
V$SESSION
This view lists session information for each current session.
SADDR
|
RAW(4 | 8)
|
Session address |
SID
|
NUMBER
|
Session identifier |
SERIAL#
|
NUMBER
|
Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. |
AUDSID
|
NUMBER
|
Auditing session ID |
PADDR
|
RAW(4 | 8)
|
Address of the process that owns the session |
USER#
|
NUMBER
|
Oracle user identifier |
USERNAME
|
VARCHAR2(30)
|
Oracle username |
COMMAND
|
NUMBER
|
Command in progress (last statement parsed); for a list of values, see Table 7-5
. These values also appear in the AUDIT_ACTIONS
table. |
OWNERID
|
NUMBER
|
The column contents are invalid if the value is 2147483644
. Otherwise, this column contains the identifier of the user who owns the migratable session.
For operations using Parallel Slaves, interpret this value as a 4-byte value. The low-order 2 bytes of which represent the session number, and the high-order bytes the instance ID of the query coordinator. |
TADDR
|
VARCHAR2(8)
|
Address of transaction state object |
LOCKWAIT
|
VARCHAR2(8)
|
Address of lock waiting for; null if none |
STATUS
|
VARCHAR2(8)
|
Status of the session:
|
SERVER
|
VARCHAR2(9)
|
Server type (DEDICATED
| SHARED
| PSEUDO
| NONE
) |
SCHEMA#
|
NUMBER
|
Schema user identifier |
SCHEMANAME
|
VARCHAR2(30)
|
Schema user name |
OSUSER
|
VARCHAR2(30)
|
Operating system client user name |
PROCESS
|
VARCHAR2(12)
|
Operating system client process ID |
MACHINE
|
VARCHAR2(64)
|
Operating system machine name |
TERMINAL
|
VARCHAR2(30)
|
Operating system terminal name |
PROGRAM
|
VARCHAR2(48)
|
Operating system program name |
TYPE
|
VARCHAR2(10)
|
Session type |
SQL_ADDRESS
|
RAW(4 | 8)
|
Used with SQL_HASH_VALUE
to identify the SQL statement that is currently being executed |
SQL_HASH_VALUE
|
NUMBER
|
Used with SQL_ADDRESS
to identify the SQL statement that is currently being executed |
SQL_ID
|
VARCHAR2(13)
|
SQL identifier of the SQL statement that is currently being executed |
SQL_CHILD_NUMBER
|
NUMBER
|
Child number of the SQL statement that is currently being executed |
PREV_SQL_ADDR
|
RAW(4 | 8)
|
Used with PREV_HASH_VALUE
to identify the last SQL statement executed |
PREV_HASH_VALUE
|
NUMBER
|
Used with SQL_HASH_VALUE
to identify the last SQL statement executed |
PREV_SQL_ID
|
VARCHAR2(13)
|
SQL identifier of the last SQL statement executed |
PREV_CHILD_NUMBER
|
NUMBER
|
Child number of the last SQL statement executed |
MODULE
|
VARCHAR2(48)
|
Name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE
procedure |
MODULE_HASH
|
NUMBER
|
Hash value of the above MODULE
|
ACTION
|
VARCHAR2(32)
|
Name of the currently executing action as set by calling the DBMS_APPLICATION_INFO.SET_ACTION
procedure |
ACTION_HASH
|
NUMBER
|
Hash value of the above action name |
CLIENT_INFO
|
VARCHAR2(64)
|
Information set by the DBMS_APPLICATION_INFO.SET_CLIENT_INFO
procedure |
FIXED_TABLE_SEQUENCE
|
NUMBER
|
This contains a number that increases every time the session completes a call to the database and there has been an intervening select from a dynamic performance table. This column can be used by performance monitors to monitor statistics in the database. Each time the performance monitor looks at the database, it only needs to look at sessions that are currently active or have a higher value in this column than the highest value that the performance monitor saw the last time. All the other sessions have been idle since the last time the performance monitor looked at the database. |
ROW_WAIT_OBJ#
|
NUMBER
|
Object ID for the table containing the row specified in ROW_WAIT_ROW#
|
ROW_WAIT_FILE#
|
NUMBER
|
Identifier for the datafile containing the row specified in ROW_WAIT_ROW#
. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
. |
ROW_WAIT_BLOCK#
|
NUMBER
|
Identifier for the block containing the row specified in ROW_WAIT_ROW#
. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
. |
ROW_WAIT_ROW#
|
NUMBER
|
Current row being
locked. This column is valid only if the session is currently waiting
for another transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
. |
LOGON_TIME
|
DATE
|
Time of logon |
LAST_CALL_ET
|
NUMBER
|
If the session STATUS
is currently ACTIVE
, then the value represents the elapsed time in seconds since the session has become active.
If the session |
PDML_ENABLED
|
VARCHAR2(3)
|
This column has been replaced by column PDML_STATUS
|
FAILOVER_TYPE
|
VARCHAR2(13)
|
Indicates whether and to what extent transparent application failover (TAF) is enabled for the session:
See Also:
|
FAILOVER_METHOD
|
VARCHAR2(10)
|
Indicates the transparent application failover method for the session:
|
FAILED_OVER
|
VARCHAR2(3)
|
Indicates whether the session is running in failover mode and failover has occurred (YES
) or not (NO
) |
RESOURCE_CONSUMER_GROUP
|
VARCHAR2(32)
|
Name of the session's current resource consumer group |
PDML_STATUS
|
VARCHAR2(8)
|
If ENABLED
, the session is in a PARALLEL DML enabled mode. If DISABLED
, PARALLEL DML enabled mode is not supported for the session. If FORCED
, the session has been altered to force PARALLEL DML. |
PDDL_STATUS
|
VARCHAR2(8)
|
If ENABLED
, the session is in a PARALLEL DDL enabled mode. If DISABLED
, PARALLEL DDL enabled mode is not supported for the session. If FORCED
, the session has been altered to force PARALLEL DDL. |
PQ_STATUS
|
VARCHAR2(8)
|
If ENABLED
, the session is in a PARALLEL QUERY enabled mode. If DISABLED
, PARALLEL QUERY enabled mode is not supported for the session. If FORCED
, the session has been altered to force PARALLEL QUERY. |
CURRENT_QUEUE_DURATION
|
NUMBER
|
If queued (1
), the current amount of time the session has been queued. If not currently queued, the value is 0
. |
CLIENT_IDENTIFIER
|
VARCHAR2(64)
|
Client identifier of the session |
BLOCKING_SESSION_STATUS
|
VARCHAR2(11)
|
Blocking session status:
|
BLOCKING_INSTANCE
|
NUMBER
|
Instance identifier of blocking session |
BLOCKING_SESSION
|
NUMBER
|
Session identifier of blocking session |
SEQ#
|
NUMBER
|
Sequence number that uniquely identifies the wait. Incremented for each wait. |
EVENT#
|
NUMBER
|
Event number |
EVENT
|
VARCHAR2(64)
|
Resource or event for which the session is waiting
See Also: Appendix C, "Oracle Wait Events" |
P1TEXT
|
VARCHAR2(64)
|
Description of the first additional parameter |
P1
|
NUMBER
|
First additional parameter |
P1RAW
|
RAW(4)
|
First additional parameter |
P2TEXT
|
VARCHAR2(64)
|
Description of the second additional parameter |
P2
|
NUMBER
|
Second additional parameter |
P2RAW
|
RAW(4)
|
Second additional parameter |
P3TEXT
|
VARCHAR2(64)
|
Description of the third additional parameter |
P3
|
NUMBER
|
Third additional parameter |
P3RAW
|
RAW(4)
|
Third additional parameter |
WAIT_CLASS_ID
|
NUMBER
|
Identifier of the wait class |
WAIT_CLASS#
|
NUMBER
|
Number of the wait class |
WAIT_CLASS
|
VARCHAR2(64)
|
Name of the wait class |
WAIT_TIME
|
NUMBER
|
A nonzero value is the session's last wait time. A zero value means the session is currently waiting. |
SECONDS_IN_WAIT
|
NUMBER
|
If WAIT_TIME
= 0
, then SECONDS_IN_WAIT
is the seconds spent in the current wait condition. If WAIT_TIME
> 0
, then SECONDS_IN_WAIT
is the seconds since the start of the last wait, and SECONDS_IN_WAIT
- WAIT_TIME
/ 100
is the active seconds since the last wait ended. |
STATE
|
VARCHAR2(19)
|
Wait state:
|
SERVICE_NAME
|
VARCHAR2(64)
|
Service name of the session |
SQL_TRACE
|
VARCHAR2(8)
|
Indicates whether SQL tracing is enabled (ENABLED
) or disabled (DISABLED
) |
SQL_TRACE_WAITS
|
VARCHAR2(5)
|
Indicates whether wait tracing is enabled (TRUE
) or not (FALSE
) |
SQL_TRACE_BINDS
|
VARCHAR2(5)
|
Indicates whether bind tracing is enabled (TRUE
) or not (FALSE
) |
able 7-5 COMMAND Column of V$SESSION and Corresponding Commands
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
发表评论
-
画图解释SQL联合语句
2014-05-05 07:49 1106英文原文;Jeff Atwood,编译:伯乐在线 ... -
oracle中使用decode进行数据的列转换为行的试验
2012-07-20 07:18 1168如何将以 ... -
RAID 5和RAID 10 的比较--- 针对数据库服务器存储方案的选择
2011-12-27 21:51 2970RAID 5和RAID 10 的比较 RAID5 和 ... -
百度技术沙龙海量用户的数据挖掘与行为分析(1月7日 京仪大酒店)免费
2011-12-27 08:41 1972百度技术沙龙第二十二 ... -
对于单表数据超过1亿的数据查询时候,必须默认时间段查询条件
2011-12-21 16:40 3225项目基本情况 最近系统碰到一个非常头疼的问题,数据库采 ... -
第二届华东地区数据库大会(2011.12.11)上海 免费
2011-12-06 13:53 1130第二届华东地区数据库 ... -
甲骨文发布Oracle NoSQL 数据库 -看来NOSQL大行其道了
2011-10-25 13:28 1282甲骨文公司在10月2日召开的OpenWorld 2011大 ... -
慎用create table as select,一定要注意默认值的问题
2011-08-01 12:06 12220再做一些数据迁移时候,很多人会使用create table ... -
ORA-26563: 不允许重命名此表的解决方法
2011-04-13 14:23 3722今天准备导入一个表,但是为了保留一个备份,准备新导入一个表,把 ... -
就因为多一个%,害的整个服务器差点挂掉
2011-04-11 17:13 2634oralce10g数据库一张表,由于一个表数据量比较大,大概1 ... -
Sybase在线研讨会:复杂事件处理与实时分析应用(4月14日 周四,免费)
2011-04-11 12:37 1322课程内容介绍 这次我们特别邀请了 Sybase软件(中国)有 ... -
最新Oracle技术沙龙(3.20)
2011-03-16 09:44 1230PSC 奉献特别圆桌会议 陈卫星- ... -
Oracle 中 ROWNUM 的使用技巧-rownum和order by
2011-03-01 15:30 1389ROWNUM和Order BY 要注意的是:在使用ROWN ... -
5款主流开源数据库的比较
2011-02-24 15:36 7811开源数据库使得信 ... -
甲骨文推数据库防火墙 监控SQL攻击
2011-02-19 20:00 1158oracle终于发布了一个不是让大多数人讨厌的事情,在 ... -
查询oracle所有执行sqlid中disk读取比重大的sql
2011-01-22 17:05 1759通过查询V$sql来查询sql读写disk次数最多的sql排序 ... -
如何查看正在执行指定sqlid的sql的执行时间
2011-01-22 16:37 2915最近在优化sql,发现有个sql_id对应的sql的IO读取量 ... -
create index注意n如果是大表建立索引,切记加上ONLINE参数
2011-01-21 22:43 20654这几天在做数据库的优化,有个2亿记录的表,发现需要添加一个联合 ... -
如何快速的获取oracle数据库中表中记录行数,不使用select count(1)方式
2010-11-21 11:44 5321数据库版本:Oracle 10G 今天查询下数据库中一 ... -
MySQL价格提升了,JVM要收费了,ORACLE想干嘛了
2010-11-08 12:53 3451甲骨文一变再变 MySQL企业版价格提升 未来,甲骨 ...
相关推荐
简单描述Oracle v$sqlarea, v$sql, v$sqltext视图说明
如果为null或0,那就说明这个session没有执行任何SQL语句。PREV_HASH_VALUE和PREV_ADDRESS两列用来鉴别被session执行的上一条语句。 注意:当使用SQL*Plus进行选择时,确认你重定义的列宽不小于11以便看到完整的...
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=21 and ses.paddr=pro.addr; 说明:21是某个连接的sid数 然后用 kill 命令杀此进程号。 五、SQL*PLUS使用 a、近入SQL*Plus $sqlplus ...
如果这项比率较低,说明系统执行了太多的解析。 公式:1 - (parse time cpu / CPU used by this session) 执行: select 1-(a.value/b.value) from v$sysstat a,v$sysstat b where a.name='parse time cpu' and ...
select username,lockwait,status,machine,program from v$session where sid in (select session_id from v$locked_object) 如果有输出的结果,则说明有死锁,且能看到死锁的机器是哪一台。字段说明: Username:...
死锁的原理 当对于数据库某个表的某一列做更新或删除等操作,执行完毕后该条语句不提 ...select username,lockwait,status,machine,program from v$session where sid in (select session_id from v$locked_object) 如
9.2.1 V$SESSION 和V$SESSION_WAIT 409 9.2.2 V$SESSION_EVENT和V$SYSTEM_EVENT 410 9.2.3 Oracle 11g实时SQL监控 411 9.2.4 从V$SQLTEXT中追踪 414 9.2.5 捕获相关SQL 415 9.3 Oracle 10g的增强 417 ...
杀掉oracle在线用户,在oracle所在服务器上使用root用户执行该脚本参数说明$1为该oracle用户 代码如下:#!/bin/shfunction _oracleplus(){su – oracle -c “$oraclehome/bin/sqlplus /nolog” <<EOFconnect /...
2、修复了SESSION报错的问题; 3、修复留言出错返回而丢失信息的问题; 4、其它的不值得一说的小错误; 使用说明: 1、运行install/install.php进行留言本的安装。 2、根据提示输入数据库连接相关信息,然后点击下...
SELECT a.osuser, a.username,b.address,b.hash_value, b.sql_text from v$session a, v$sqltext b, v$process p where p.spid = &spid and p.addr = a.paddr and a.STATUS = 'ACTIVE' and a.sql_address =b....
the URL and Anchor Tag allowsremote command execution, session access and manipu lation and XSS attacks.(see:https://cwiki.apache.org/confluence/display/WW/S2-01 4) It help you to scan detects ...
可以使用,里面有安装说明。 安装完后,进入data目录,删除cache下除文件夹的所有文件,再次刷新,OK,大功告成! 安装之前准备工作:把你的PHP环境配置好,程序只支持php5.3或更高版本,php.ini要支持以下:...
POST和upload 仅仅对不同的地方做说明: function post($sUrl,$aPOSTParam){ global $aConfig; ... //拼接POST数据 $aPOST = array(); foreach($aPOSTParam as $key=>$val){ $aPOST[] = $key."=".urlencode($...
99乘法表java源码OracleDBUtils 适用于 Oracle 数据库的有用 PL/SQL 实用程序。...V$SESSION)作为参数并通过调用 orakill.exe(在 Windows 服务器上)或 kill -9(在 UNIX 机器上)来终止相应的会话。
2.3 敏感信息(如PASSWORD/银行帐号等)不要依赖COOKIE,SESSION,最好读表,并尽量缓存读表数据 8 2.3.1 说明 8 2.3.2 应对 9 2.3.3 举例 9 2.4 注意对网站根目录及下面所有子目录及文件的权限控制与保护,不要让配置...
二、升级说明: 增加了SQL防注入程序、修补了部分用户无法删除帖子的BUG、增加了session记录(删贴无须重复登陆)、解决了国外空间乱码问题。 三、开发机构: 【思想吧】 THINK8.COM 专业提供ASP...
WebIM-for-ThinkPHP开发说明(README) ================== WebIM Application for ThinkPHP3.1 Demo ===== Webim目录上传WEB服务器根目录 访问http://localhost/Webim/Index/ Develop ======= Webim目录上传...
5451CMS v1.2更新说明: 1.修复前台不能提交调查表 2.修复加好友发表情不能输入问题 3.更新整个后台UI 4.局部调整前台UI 5451CMS系统基于PHP MYSQL开发,是一个轻量极的资讯系统,框架完全采用面向对象的...
Maybecms更新说明: 1、删除内容未删除浏览量数据Bug。 2、外部链接的缩略图格式化处理。(暂时未用到) Maybecms使用php语言和mysql数据库开发,并且采用了主流的MVC设计模式,使系统框架结构清晰、易维护、...
欢迎使用网络日志本[DLOG v2.2版](运行于ASP+ACCESS2000下)。 此程序的功能主要是提供个人拥有者一个可以在线书写日志并管理的的界面。主要操作和功能如下: ---------------------------------------------------...