(Ayan Mitra) In this article, the author explains how to make use of DBMS_PIPE package to allow for access to the value of a variable across different sessions. This useful feature has been exemplified with the help of a practical example.

(Alex Gorbachev) Recently we’ve had quite a few migrations to 10g Release 2 and several times been hit by one issue – some users consistently get locked with status LOCKED(TIMED). One good example is with the DBSNMP and SYSMAN users, but more important are locked production accounts.

(Bob Watkins) Oracle’s export and import utilities have historically used a disk file as intermediate storage when unloading or reloading the database. For large databases, this “dump file” was an issue because operating system limits on file size could be exceeded, making export impossible.

(Brian Peasland) I am currently trying to restrict access to my database through listing the IP addresses with permission. I read that I should modify my sqlnet.ora file. The problem is I do not have this file. When I create it and specify the parameters, the listener gets whacked out and stops work

(Jagadish Chatarji) This is the first article in a series concentrating on working with sub-queries in Oracle. Sub-queries really have tremendous depth. In this series I will show you several scenarios where they can be efficiently used to retrieve information from Oracle databases.

In this guide, we will discuss many of the operational costs and resource drains of implementing and managing the Oracle E-Business Suite and discuss how to reduce effort and eliminate errors using a ZeroERROR object migration solution. (R)

(Lewis Cunningham) I had the opportunity to attend some XML sessions at OOW and some really great things are coming in Oracle 11g. I wish I had the beta version of the docs just to read through it.

(Shakir Sadikali) In the last month, we have been hit with two clients’ large-scale failures. The first involved network issues; the second, disk failures. Fun fun.

Database and business applications giant Oracle Corp has bought content management software maker Stellent Inc for around $440m.

The Maximum Availability Architecture (MAA) represents the optimum high availability (HA) architecture and set of best practices to accommodate the most stringent requirements for business continuity with the least amount of complexity. We provide details on how to configure, deploy, and manage MAA