Oracle Commands
  • OS

sqlplus

  • DQL

select
execute

  • DML

insert
update
delete
set transaction

  • DCL

grant
revoke

  • DDL

create table/index/procedure/function/package/tablespace/system/database
alter table/index/procedure/function/package/tablespace/system/database
drop table/index/procedure/function/package/tablespace/system/database

  1. add a identifier to trace file

alter session set TRACEFILE_IDENTIFIER='';

  1. find hot block

select * from v$bh;

See Also:
x$bh buffer headers information

  1. check shared_pool status

select * from x$ksmsp;

See Also
x$ksmsp shared memory chunk information?