Oracle中的Parallel Execution 和有用的view

默认是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 processesV$SESSION
Lists session information for each current sessionV$SESS_IO
Contains I/O statistics for each user sessionV$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 sessionV$SESSION_WAIT_HISTORY
Lists the last ten wait events for each active sessionV$WAIT_CHAINS
Displays information about blocked sessionsV$SYSSTAT
Contains session statisticsV$RESOURCE_LIMIT
Provides information about current and maximum global resource utilization for some system resourcesV$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更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle中的global_name和db domainOracle中的shared server相关资讯 Oracle基础

Oracle基础介绍及常用相关SQL*PLUS （03月11日）
Oracle 角色的两个特性和误区（09/04/2012 05:56:16）
Oracle rac11.2.0.3.0的vip在重启（09/02/2012 10:00:39）

Oracle中删除用户遇到的问题（09/08/2012 20:01:42）
IMP-00008: unrecognized （09/02/2012 10:03:25）
在Oracle数据库上设置限制ip地址访（09/02/2012 09:59:55）

本文评论查看全部评论（0）