Errata

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