Sql statement tuning

Managing Privileges A privilege is a right to execute a particular type of SQL statement or to access another user’s object. These include the right to: Connect to a database Create a table Select rows from another user’s table Execute another user’s stored procedure System privileges Each system privilege allows a user to perform a particular database operation or class of database operations; for example, the privilege to create tablespaces is a system privilege.

26p trinh02 28-01-2013 73 5   Download

After completing this lesson, you should be able to do the following: Control optimizer options Use optimizer hints Employ plan stability Use stored outlines Use SQL Trace and TKPROF

32p trinh02 28-01-2013 51 4   Download

Overview of Primary Components The Oracle architecture includes a number of primary components, which are discussed further in this lesson. Oracle server: There are several files, processes, and memory structures in an Oracle server; however, not all of them are used when processing a SQL statement. Some are used to improve the performance of the database, to ensure that the database can be recovered in the event of a software or hardware error, or to perform other tasks necessary to maintain the database. The Oracle server consists of an Oracle instance and an Oracle database.

48p trinh02 28-01-2013 92 8   Download

SQL statements are not case sensitive. SQL statements can be on one or more lines. Keywords cannot be abbreviated or splitacross lines. Clauses are usually placed on separate lines. Indents are used to enhance readability.

40p trinh02 28-01-2013 48 6   Download