Errata for Oracle Performance Tuning

last bullet now reads: * LOB columns (BLOB, CLOB, NCLOB, and BFILE) can be as large as 4 gigabytes. You can specify the BLOB and CLOB columns in a separate tablespace from the rest of the table. BFILE columns are stored in a file external to the database.

The text in the second example used to read: "Index Range Scan on Dept_Idx Index Range Scan on Cat_Idx" It now reads: "Index Range Scan on Cat_Idx Index Range Scan on Dept_Idx"

BY DECODE(:BLK.SEQN_FLD 'E', emp_no, 'D', dept_no); to BY DECODE(:BLK.SEQN_FLD, 'E', emp_no, 'D', dept_no);

code 2, line 4 now reads: UNION ALL The following scripts were replaced: [295]: waiters.sql [431]: tspuse.sql [588]: exp_lrge.sh [609-610]: chk_nxt.sql For the new scripts, return to the book's web page and click on the "Book Examples via ftp" link.

sum_sick_leave(E.emp_no) sick_days, sum_holiday_leave(E.emp_no) holidays to Sum_Sick_Leave(E.emp_no) sick days, Sum_Holiday_Leave(E.emp_no) holidays

sql> SELECT sql_text, executions, to sql> SELECT executions,

sal_val >= 8001 Then And change the preceding "THEN" to "OR" so the code reads: If sal_val <= 2000 OR sal_val >= 8001 THEN RETURN (0); END IF;

to _LOG_ENTRY_PREBUILD_THRESHOLD

The FROM statement of objstor.sql used to read: "dbs_tables T," now it reads: "dba_tables T,"

A comma has been added to the end of the seventh line of code: sum(decode(nvl(num_rows,9999), 9999,0,1)) "Tables Analyzed",

The bulleted item at the top of the page used to read: Encourage developers to use bind variables whenever possible. For example, use this statement: SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; instead of these: SELECT acct_name, acct_limit FROM account WHERE acct_no = 10301; SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; now it reads: Encourage developers to use bind variables whenever possible. For example, use this statement: SELECT acct_name, acct_limit FROM account WHERE acct_no = :accno; instead of this: SELECT acct_name, acct_limit FROM account WHERE acct_no = 10301;

There is now a join required in both SQL statements. They now read as follows: SELECT SUM(VALUE) FROM V$SESSTAT st, V$STATNAME nm WHERE nm.NAME = 'session uga memory' AND st.STATISTIC# = nm.STATISTIC# / and SELECT SUM(VALUE) FROM V$SESSTAT st, V$STATNAME nm WHERE nm.NAME = 'session uga memory max' AND st.STATISTIC# = nm.STATISTIC# /

In the code example, it used to read: (TRUNC(indx / 250) +1 interval, now it reads: (TRUNC(indx / 250) +1) interval,

The line "AND username is not null" has been added.

The line "AND se.username is not null" has been added.

The line, "and ob_typ = 2", has been removed.

to last line has been changed. It used to read: WHERE username||' ('||sid||')' = "User Session") ORDER BY username, sid, now it reads: WHERE username||'('||v$session.sid||')' = "User Session")

In line 1, "sid" has been changed to "ses.sid" In line 2, "prc.osuser" has been changed to "ses.osuser"

The eleventh line form the top used to read: AND l1.id1 = l2.id1 now it reads: WHERE l1.id1 = l2.id1

All the references to V$SQLAREA have been changed to V$SQLTEXT.

A Order by line has been added to the bottom of the script: order by 'User '||v$session.username||'('||v$session_wait.sid||')', piece