(Bob Watkins) For several releases now, DBAs and developers have had access to three dynamic performance views—V$SQL, V$SQLAREA, and V$SQLTEXT—that can be used to collect statistics about the performance of their SQL statements. In Oracle 10g, Release 2, a fourth dynamic performance view—V$SQLSTATS—

(Mark Brunelli) The question of where Hyperion Solutions Corp.’s technology fits into Oracle’s Fusion equation has some industry experts scratching their heads.

Cryptographic hash functions seem to be an ideal method for protecting and securely storing credit card numbers in ecommerce and payment applications [1]. A hash function generates a secure, one-way digital fingerprint that is irreversible and meets frequent business requirements for searching and

(Steve Muench) In previous columns, I have focused on the basics of creating Web applications by using Oracle Application Development Framework (Oracle ADF). However, the Oracle JDeveloper environment is also great for creating applications that have a polished desktop look and feel. These desktop a

(Heather Havenstein) Oracle Corp.’s purchase of business intelligence vendor Hyperion Solutions Corp. will likely benefit Oracle, but Hyperion customers could experience a decline in service and end up with less negotiating leverage, some users and analysts said.

(Sam Alapati) In this third part of a series that focuses on managing OC4J and configuring J2EE applications, we look at how to configure the OC4HJ server.

(Lucas Jellema) Process instances in the Oracle BPEL PM can be initiated in a number of ways. Some are passive – the BPEL engine receives a call and as a result starts a new instance of the referenced process – while others are more active – the BPEL engine looks for events that it knows should trig

(Babette Turner-Underwood) As usual, Oracle introduces new features, and we read the documentation about how they work and we start using them… but what about what is not in the documentation? That we find out by practice, experience, or accident. And that is exactly what happened to me today.

(Frank Zhou) This tip can be used to display all the combinations for a predetermined number of columns using the table format.

(Steve Callan) Keeping track of all the different memory areas in Oracle taxes my memory. With Oracle 10g, there can be fewer parameters to keep track of – if you remember which parameters drive or affect other parameters. It is very common to see numerous reporting scripts in a production environme