Goal To trace the CBO working out the execution path (event 10053) Facts Solution To start the CBO trace enter the following command: ALTER SESSION SET EVENTS='10053 trace name context forever, le ...

Solution The following script will find SQL with many disk reads: -- ------------------------ -- Find SQL Statements that -- require a lot of disk -- reads. -- ------------------------ SELECT * FROM ...

Use these statements to determine the physical Disk I/O performed on Tablespaces or Data Files. Tablespace Files Physical Reads and Writes set pages 500 lines 110 clear col bre buffer col tablespac ...

If you would to determine the amount of memory database processes are consuming consider the following script set lines 110 col unm format a30 hea "USERNAME (SID,SERIAL#)" col pus format 999,990.9 h ...

set pages500 lines110 trims on clear col col name format a30 col username format a20 break on username nodup skip 1 select vses.username||':'||vsst.sid||','||vses.serial# username, vstt.name, max(vs ...

Overview Most Oracle databases use locally managed tablespaces (LMT) today - dictionary managed tablespaces (DMT) are now obsolet. The reasons to use LMTs are the following: Object fragmentation you ...

一、共享SQL区 共享SQL区，就是Library cace中的游标对象的句柄和子堆这些数据的另一种叫法。 二、私有SQL区的概念 私有SQL区，在专用服务器模式下，存贮在PGA中。 （复习一下PGA概念： PGA在服务器端分配，记录各种 ...

相老师，有没有在红帽5u3 上装过64为的oracle9i 平台的配置为：intel Xen 64位处理器。 redhat 5u3 64 内核为2.6.18位版本 oracle 9i 介质为 9.2.0.4 （64位） 我装的时候总是hang在了 %17那，为一个 copy naeet.o文 ...