1.模拟插入大量的数据
SQL> create table t1(id int);
Table created.
declare
i number;
begin
for i in 1..10000000 loop
insert into t1 values(i);
end loop;
commit;
end;
9 /
2.使用top命令查看哪个进程占用CPU高
3080 oracle 20 0 2886944 1.2g 1.2g R 99.3 15.4 4:18.26 oracle_3080_orc
3.使用SQL语句查看
[oracle@node01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 13 09:21:46 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SELECT sql_text
FROM v$sqltext a
WHERE (a.hash_value, a.address) IN
(SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value),
DECODE(sql_hash_value, 0, prev_sql_addr, sql_address)
FROM v$session b
WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = '3080'))
8 ORDER BY piece ASC
9 ;
SQL_TEXT
--------------------------------------------------------------------------------
INSERT INTO T1 VALUES(:B1 )
这样可以很清晰的看到INSERT INTO T1 VALUES(:B1 )的时候占用了大量的CPU。