View Oracle CPU case

2010-10-15  来源:本站原创  分类:Database  人气:192 

Found that those who run a lot of PARSE SQL
select sql_text, parse_calls, executions from v $ sqlarea order by parse_calls desc;
- SYS PARSE general situation
select name, value from v $ sysstat where name like 'parse count%';

- CPU space and busy situations
select * from v $ osstat;

- Check the CPU utilization of each Session:
select ss.sid, se.command, ss.value CPU, se.username, se.program
from v $ sesstat ss, v $ session se
where ss.statistic # in
(Select statistic #
from v $ statname
where name = 'CPU used by this session')
and se.sid = ss.sid
and ss.sid> 6 order by CPU desc;

- Compare what session the CPU used for a maximum, and then view the specific circumstances of the Session:
select s.sid, s.event, s.MACHINE, s.OSUSER, s.wait_time, w.seq #, q.sql_text
from v $ session_wait w, v $ session s, v $ process p, v $ sqlarea q
where s.paddr = p.addr and
s.sid = & p and
s.sql_address = q.address;
--- The top 10 CPU-Session and SQL Statement
select s.sid, w.wait_time, w.seconds_in_wait, w.state, w.wait_time_micro, w.time_remaining_micro, w.time_since_last_wait_micro, p.USERNAME,
status, server, schemaname, osuser, machine, p.terminal, p.program, logon_time, w.event, w.wait_class, tracefile, sql_text, last_active_time
from v $ session_wait w, v $ session s, v $ process p, v $ sqlarea q
where s.paddr = p.addr and
s.sid
in
(Select sid from
(
select ss.sid
from v $ sesstat ss, v $ session se
where ss.statistic # in
(
select statistic # from v $ statname
where name = 'CPU used by this session'
)
and se.sid = ss.sid and ss.sid> 6 order by ss.value desc
) Where rownum <11
)
and s.sql_address = q.address;

<script type="text/javascript"> </ script>

相关文章
  • View Oracle CPU case 2010-10-15

    Found that those who run a lot of PARSE SQL select sql_text, parse_calls, executions from v $ sqlarea order by parse_calls desc; - SYS PARSE general situation select name, value from v $ sysstat where name like 'parse count%'; - CPU space and busy si

  • linux view the cpu, io and other activities ttxtxi system 2010-03-20

    View System Information (bjchenxu) cat / proc / cpuinfo - CPU (ie vendor, Mhz, flags like mmx) cat / proc / interrupts - interrupts cat / proc / ioports - Device IO Port cat / proc / meminfo - memory information (ie mem used, free, swap size) cat / p

  • View linux cpu and memory utilization 2010-11-30

    Transfer from: http://hi.baidu.com/paobeilvcha/blog/item/9b886d6d7d82b7fd43169482.html In the course of system maintenance at any time may be necessary to view the CPU usage, and information analysis system according to the appropriate state's needs.

  • View Oracle parameters 2010-08-24

    View Oracle parameters: SELECT NAME, VALUE, DECODE (ISDEFAULT, 'TRUE', 'Y', 'N') AS "Default", DECODE (ISEM, 'TRUE', 'Y', 'N') AS SESMOD, DECODE (ISYM, 'IMMEDIATE', 'I', 'DEFERRED', 'D', 'FALSE', 'N') AS SYSMOD, DECODE (IMOD, 'MODIFIED', 'U', 'S

  • view oracle database table space usage: 2010-09-07

    view oracle database table space usage; oracle tablespace should always check what the situation is generally idle too low when the ratio should consider increasing the table to see space. View as follows SQL: Method 1: select dbf.tablespace_name, db

  • Linux how to view the CPU information, including median and multi-core information (transfer) 2010-09-10

    inux how to view the CPU information, including information bits and multicore # Uname-a Linux euis1 2.6.9-55.ELsmp # 1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU / Linux (See the current operating system kernel information) # Cat / etc / is

  • View oracle version information 2010-09-18

    1 view oracle version information (1) with the client to connect to the database, perform select * from v $ instance View version entry (2) select * from product_component_version (3) or query V $ VERSION view the component-level information

  • View oracle maximum number of connections 2010-11-15

    View oracle maximum number of connections select count (*) from v $ session # number of connections Select count (*) from v $ session where status = 'ACTIVE' # number of concurrent connections show parameter processes # Maximum Connections alter syst

  • View oracle enterprise manager port path 2010-11-02

    View oracle enterprise manager port path: D: \ oracle \ product \ 10.2.0 \ db_1 \ install Visit the URL: http://ip (or computer name): 1158/em

  • [Oracle] CPU/PSU补丁安装详细教程 2014-01-02

    Oracle CPU的全称是Critical Patch Update, Oracle对于其产品每个季度发行一次安全补丁包,通常是为了修复产品中的安全隐患,以下是对CPU/PSU补丁安装的具体操作步骤进行了详细的分析介绍,需要的朋友可以参考 什么是CPU/PSU Oracle CPU的全称是Critical Patch Update, Oracle对于其产品每个季度发行一次安全补丁包,通常是为了修复产品中的安全隐患. Oracle PSU的全称是Patch Set Update,Oracle对于

  • Dwell Oracle CPU usage optimization 2010-03-29

    http://database.51cto.com/art/200911/163251.htm I am very fond of Oracle, is also at work on the Oracle optimization like CPU usage summary of lessons learned, the following detail on this issue to speak. CPU is an important resource server, the serv

  • View oracle current number of connections (zz) 2010-04-02

    Original: http://www.blogjava.net/temper/archive/2009/03/24/261657.html How to See oracle current number of connections it? Just use the following SQL statement queries click on it. select * from v $ session where username is not null select username, cou

  • How to view Oracle's connections 2010-10-18

    Development in the database, open the database connection is very slow. Oracle how the current number of connections it? Just use the following SQL statement to query click on it. select * from v $ session where username is not null View the number o

  • linux view the cpu. memory hard drive and other hardware information 2011-04-29

    A, CPU size [Root @ idc ~] # cat / proc / cpuinfo | grep "model name" & & cat / proc / cpuinfo | grep "physical id" model name: Intel (R) Xeon (TM) CPU 2.80GHz model name: Intel (R) Xeon (TM) CPU 2.80GHz model name: Intel (R) X

  • Detailed view the cpu top 2011-06-22

    the process of dealing with us that the percentage of users; sy that the percentage of kernel thread; ni said the nice command to change the priority task of the percentage; id represents the percentage of idle cpu; wa said that in the course of the

  • How do I view Oracle database tablespace size (idle. Has been used), whether to increase the table space data file 2010-11-24

    To view the Oracle database table space, the need to increase the table space data file, database management, disk space is a DBA will encounter the problem, the problem is more common. - 1, has been used to view the percentage of table space select

  • View oracle's job to create the Task Scheduler 2011-06-28

    How to find the job name if a scheduled job fails with ORA-12012 When a scheduled job fails, the alert log shows an error message like: "ORA-12012 error on auto execute of job 47544". How do I correlate the job number value in the alert log to t

  • (R) DBA should be how to view Oracle database connections 2011-09-22

    In the actual work, the database administrator (DBA) requires frequent connection to the database regularly to inspect, view the number of sessions established with the database is not normal, if the establishment of too many connections, it will con

  • How to view oracle tablespace size has been used 2010-02-26

    1. View All table space: select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name; 2. Have used the table space: select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name; 3. Thus the use

  • View oracle table partition information 2010-03-23

    Display the partition table information shows all database partition table information: DBA_PART_TABLES Display the current user can access all the partition table information: ALL_PART_TABLES All the partition table shows the current user informatio