Abstract: Based on the features of ORACLE, this paper discusses how to write optimal SQL statements and applications. It also describes how to use ORACLE performance diagnostic tools to identify inefficient statements in application.