As Published In November/December 2004

From Our Readers

Your corrections, your opinions, and your requests: Here's your forum for telling us what's right and wrong in each issue of Oracle Magazine, and for letting us know what you want to read.

Correcting the View

Regarding the article "Perform Without Waiting" in the July/August 2004 issue of Oracle Magazine, the article states that the following query

select event, seconds_in_wait,
wait_time
from v$session
where sid = 355;

fetches the information shown in Listing 4, but it is a multirow output that—for v$session—should have been only a single row.
John Kanagaraj
ora_apps_dba_y@yahoo.com

The query should have selected from v$session_wait; that will produce the output shown in Listing 4. The correct query is

 
select event, seconds_in_wait,
wait_time
from v$session_wait
where sid = 355;

The online version of the article has been updated at oracle.com/technology/oramag/oracle/04-jul/o44tech_perf.html.

Getting Vertical

"Perform Without Waiting," in the July/August 2004 issue of Oracle Magazine, has the following result:

SID : 270
USERNAME : BILL
EVENT : enq: TX - row lock
contention
BLOCKING_SESSION : 254
SECONDS_IN_WAIT : 83
WAIT_TIME : 0

Do you know how to make the query return results like this? Was it done by hand?
Henrique Souza
Henrique@programmers.com.br

This was done by hand in order to fit our column format, but you can create vertical formats like this by using Tom Kyte's print table utility, available at asktom.oracle.com/~tkyte/print_table/.

Controlling Corrections

"Controlling Mythological Code," in the September/October 2004 issue of Oracle Magazine, is an excellent article, but I think there's a typo in the code. Shouldn't the text "CREATE OR REPLACE change_team" be "CREATE OR REPLACE PROCEDURE change_team"?
Harm Vers3churen
Harm.Verschuren@europeesche.3nl

Yes. This has been corrected online at oracle.com/technology/oramag/oracle/04-sep/o54plsql.html.

Put the Library First

In the article "Rapid Struts Development," in the September/October 2004 issue of Oracle Magazine, I have a problem with Listing 2 (result.jsp). Shouldn't the tag library struts-bean.tld be included in the first line?
Greg Grimes
gpgrimes@gte.net

Send Mail to the Editor Send your opinions about what you read in Oracle Magazine, and suggestions for possible technical articles, to opubedit_us@oracle.com. Or click on the Write the Editors link on our Web site. Letters may be edited for length and clarity and may be published in any medium. We consider any communications we receive publishable.

Yes. Listing 2 (result.jsp) has been corrected online at www.oracle.com/technology/oramag/oracle/04-sep/o54jdev_l2.html. The line "<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>" has been added to the beginning of the listing.

Missing A

As always, I greatly enjoyed the Ask Tom column in the September/October 2004 issue of Oracle Magazine. I believe there is a small omission in the last code listing of that issue's article on page 84. The second-to-last line should read "from v$session a" instead of "from v$session."
Stephen H. Merkel
merkelsb@earthlink.net

The article has been corrected online at oracle.com/technology/oramag/oracle/04-sep/o54asktom.html.

Different Coverage

I see that some of my coworkers' copies of the July/August 2004 issue of Oracle Magazine sport a "By Popular Demand" Linux cover, whereas others have a "Scoring with Web Services" cover. What's up?
Graydon Mah
Mah.Graydon@Menloworldwide.com

We printed a limited number of covers featuring Linux for the July/August 2004 issue. The content of the issue is the same, regardless of the cover.