(Jason Price) In this article, you will learn how to use database transactions in Visual Basic .NET (VB.NET) and Visual C# .NET (C#). Specifically, you will explore database transactions, use OracleTransaction objects in .NET programs, and learn how to set a transaction savepoint. All the scripts an

To enhance Query Optimization, the OPTIMIZER_DYNAMIC_SAMPING is set to 2 by default. Automatic PGA Memory Management is now enabled by default and PGA_AGGREGATE_TARGET is set to 20 percent. In order to disable the Automatic PGA Memory Management set the parameter to 0.

(David Jason Bennett) If you have installed Oracle Application Server 10g Enterprise Edition and are ready to create custom SSO login and sign-off pages, then you might want to consider using PHP over the traditional PL/SQL and JSP methods. A big advantage of using PHP over PL/SQL and JSP is the eas

(Boris Milrud) A massive DELETE operation deletes millions of rows from a table with indexes and constraints. This operation is database intensive and time consuming, mainly because it forces the database to generate and save to disk significant amounts (possibly gigabytes) of redo and undo data.

(Gavin Powell and Carol McCullough-Dieter) This chapter takes a bird’s-eye view of Oracle SQL changes in both Oracle Database 10g and Oracle Database 9i. Without further ado, let’s get started with Oracle Database 10g. (pdf)

Attempting to use an Oracle linked server using the MSDAORA OLE DB provider, which queries a table with a NUMERIC column, may give an error similar to the following: Server: Msg 7354, Level 16, State 1, Line 1 OLE DB provider ‘MSDAORA’ supplied invalid metadata for column ‘columnname’. The data

(James Koopmann) Using e-mail from within Oracle can be a great advantage. Many methods of sending e-mail extract the information and then package it up outside of Oracle. However, Oracle has supplied us with all that we need to do everything from within Oracle. This can be quite handy when we as DB

(Bill Hamilton) Get a comparison of the strengths of the two most common .NET data providers for Oracle, and be prepared to select the right one for your next development project.

(Mark Teter) End users are looking for cost-effective database storage solutions that maximize online transactions, provide good backup-and-recovery performance, minimize overall storage costs, and provide reasonable fault tolerance. In addition, users need high-performance storage to support Oracle

(Azeem Mohamed) Oracle has introduced many advanced features in managing memory. One of the interesting features is the advisory, which enables a DBA to dynamically resize SGA components and control the PGA memory utilization at the instance level. Oracle introduced advisories for buffer cache