fuyuncat的专栏

查看哪些SQL语句消耗资源：select * from(select SQL_TEXT,EXECUTIONS,DISK_READS,BUFFER_GETS from v$sqlarea order by BUFFER_GETS desc)where rownum  查看表空间占用率：SQL> col tablespace_name format a15SQL> select a.tablespac

BEGIN dbms_refresh.refresh("HW"."G101"); END;SELECT USER FROM SYS.DUALSELECT NAME FROM USER$  WHERE NAME = :b1SELECT R.REFGROUP FROM SYS.RGROUP$ R  WHERE R.OWNER = :b1  AND R.NAME = :b2  AND R.INSTS

QUESTION=========Enabled 10046 trace level 4 and created trace files,But how to find bind variabless valueeos (end of section)ANSWER=======Here is an example:Sample PL/SQL code:declarevcount number :

l   V$DB_CACHE_ADVICE(调整db_cache_size):ColumnDatatypeDescriptionIDNUMBERBuffer pool identifier (ranges from 1 to 8)NAMEVARCHAR2(20)Buffer pool nameBLOCK_SIZENUMBERBlock size in bytes for buffers in th

_ksm_granule_size为最低粒度大小。如果SGA_MAX_SIZE小于128M，则_ksm_granule_size为4M；如果SGA_MAX_SIZE大于等于128M，则_ksm_granule_size为8M_ksm_granule_size决定了其他一些参数的大小。假如SGA_MAX_SIZE为64M，则_ksm_granule_size为4M，那么如果设定db_cache_si