Oracle Commands
- OS
- 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
- add a identifier to trace file
alter session set TRACEFILE_IDENTIFIER='';
- find hot block
select * from v$bh;
See Also:
x$bh buffer headers information
- check shared_pool status
select * from x$ksmsp;
See Also
x$ksmsp shared memory chunk information?