Abstract: This paper analyses the main features and characteristics of ORACLE optimization te- chnique in single table queries,multiple table queries and subqueries.It introduces suppressing me- thods of ORACLE optimization indexes and sort/merge routines.Finally,the evaluation of ORACLE query optimization technique is given.