Library cahe Latches and internal explaination
http://www.ixora.com.au/q+a/library.htm
Good link for LIO in Oracle ( Logical IOs)
http://www.diku.dk/undervisning/2003f/729/papers/millsap.pdf
New Latest Param.sql for finding all hidden parameters also
set pages 3000 set lines 151 accept param_name prompt ‘Enter Parameter Name : ‘ select a.ksppinm “Parameter”, b.ksppstvl “Session Value”, c.ksppstvl “Instance Value” from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and ( upper(ksppinm) like ‘%¶m_name%’ or lower(ksppinm) like ‘%¶m_name%’ ) order by a.ksppinm;
In Addition to previous note, following grants needed on PERFSTAT user.
/* System privileges */ grant create session to PERFSTAT; grant alter session to PERFSTAT; grant create table to PERFSTAT; grant create procedure to PERFSTAT; grant create sequence to PERFSTAT; grant create public synonym to PERFSTAT; grant drop public synonym to PERFSTAT; /* Select privileges on STATSPACK created views */ grant select on X_$KCBFWAIT to PERFSTAT;…
Read More “In Addition to previous note, following grants needed on PERFSTAT user.” »
Removing first line
ssh webdbprod23 “df -k /db6/oradata/WEBP18F” | awk ‘{print $4}’ | sed ‘1d’ 1d for deleting first 1 line. 2d for deleting first 2 lines ans so on.
Privileges Required to Create Procedures and Functions that uses objects from other schema.
When you are creating a procedure and you are using objects from other schemas, then the procedure owner needs related privilages exclusively on those objects of other schemas. This cannot be resolved with ROLE.
Settting up get_vmstat.sh for colletinf CPU Usage.
To collect CPU stats from Server following code needs to be setup. ( Step By Step ) Step-1 ====== Create a user named PERFSTAT/PERFSTAT. This is not for statspack, we only need 3 tables and package for this settings. Give appropriate default TS for same. Step-2 ====== create tables with following definitons: CREATE TABLE STATS$VMSTAT2…
Read More “Settting up get_vmstat.sh for colletinf CPU Usage.” »
Giving Grant on v$DATABASE
To give grant on v$database or any such synonym, need to follow following steps. 11:02:21 SYS@UOCQA:-> select * from dba_synonyms where synonym_name = ‘V$DATABASE’; OWNER SYNONYM_NAME TABLE_OWNER —————————— —————————— —————————— TABLE_NAME —————————— DB_LINK —————————————————————————————————- PUBLIC V$DATABASE SYS V_$DATABASE Then, 11:02:22 SYS@UOCQA:-> GRANT SELECT ON V_$DATABASE TO PUBLIC;
Very Good Oralce Internal Tuning Book
http://www.sun.com/blueprints/0303/817-1781.pdf
Virtual Indexes in Oracle
Create virtual indexes 11:42:42 CS@UOCQA:-> create index index_1 on BSKT_SHOPPING_BASKET_ITEM (BASKET_RECIPIENT_ID, BASKET_ITEM_ID) nosegment; need to set a hidden parameter as following. 11:42:42 CS@UOCQA:-> alter session set “_use_nosegment_indexes”=true; Indexes created without any segment. cannot views with User_indexes. Can be viewed in USER_OBJECTS. Useful in producton environment where we cannot create any indexes. Existance of this index…