本文介绍Oracle数据库中用于性能分析的关键视图，包括活动进程信息、会话状态、I/O统计等，帮助理解数据库运行状况及优化查询执行。
[img]http://dl2.iteye.com/upload/attachment/0094/7108/097236b3-62ed-38ff-9002-4bae7b4b69f7.jpg[/img]
默认是parallel_max_servers是大于0的 也就是打开的
alter session enable parallel [ddl | dml | query];
alter session disable parallel [ddl | dml | query];
alter session force parallel ddl parallel 5;
用来分析DB性能的几个view.
V$PROCESS
Contains information about the currently active processes
V$SESSION
Lists session information for each current session
V$SESS_IO
Contains I/O statistics for each user session
V$SESSION_LONGOPS
Displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution. More operations are added for every Oracle Database release.
V$SESSION_WAIT
Displays the current or last wait for each session
V$SESSION_WAIT_HISTORY
Lists the last ten wait events for each active session
V$WAIT_CHAINS
Displays information about blocked sessions
V$SYSSTAT
Contains session statistics
V$RESOURCE_LIMIT
Provides information about current and maximum global resource utilization for some system resources
V$SQLAREA
Contains statistics about shared SQL areas. Contains one row for each SQL string. Provides statistics about SQL statements that are in memory, parsed, and ready for execution
默认是parallel_max_servers是大于0的 也就是打开的
alter session enable parallel [ddl | dml | query];
alter session disable parallel [ddl | dml | query];
alter session force parallel ddl parallel 5;
用来分析DB性能的几个view.
V$PROCESS
Contains information about the currently active processes
V$SESSION
Lists session information for each current session
V$SESS_IO
Contains I/O statistics for each user session
V$SESSION_LONGOPS
Displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution. More operations are added for every Oracle Database release.
V$SESSION_WAIT
Displays the current or last wait for each session
V$SESSION_WAIT_HISTORY
Lists the last ten wait events for each active session
V$WAIT_CHAINS
Displays information about blocked sessions
V$SYSSTAT
Contains session statistics
V$RESOURCE_LIMIT
Provides information about current and maximum global resource utilization for some system resources
V$SQLAREA
Contains statistics about shared SQL areas. Contains one row for each SQL string. Provides statistics about SQL statements that are in memory, parsed, and ready for execution
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
