MyNotes

B-Tree cluster indexes: *This indexes(indexed cluster) is a table cluster that uses an index to locate data. *The cluster index is a B-tree index on the cluster key ,It must be created before any rows can be instered into clustered tables * A cluster is a group tables that share the same data blocks i.e all the tables are physically stored together Create cluster: Let us we can assume to create cluster based on the cluster key department_id SQL> create cluster emp_dept (department_id number(4)); Cluster created. Then create index on it SQL> create index idx_emp_dept on cluster emp_dept; Index created. Then create table emp and dept SQL> create table emp (department_id number(4), 2 name varchar2(20), 3 empno number(5), 4 sal number(10,2)) 5 cluster emp_dept (department_id); Table created. SQL> insert into emp values(10,'ram',123,'1500'); 1 row created. SQL> insert into emp values(20,'sam...

today I got a question from Oracle dba group which background process will start first when the instance is started? (When considering in oracle 10g) Many of them gave the answer is "smon" but it was the wrong answer one of the group members answered psp0 (PROCESS SPAWNER) then I searched on google about PSP process and here we can see about PSP(PROCESS SPAWNER) process. kindly check the link below https://ampersandacademy.com/tutorials/oracle-admin-1/psp0-process-label-name

Let us we discuss about today  session the type of B-tree index (reverse key)  kindly check the link below https://ampersandacademy.com/tutorials/oracle-admin-2/types-of-b-tree-indexes-reverse-key-index

Let us we discuss about today  session How to find unused index in oracle 11g  kindly check the link below https://ampersandacademy.com/tutorials/oracle-admin-2/how-to-find-unused-index-in-oracle-11g