(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
Author: SSWUG Research
Checking to see if indexes exist
(Craig Mullins) I have a process that loads data through a nightly job. Say for example the job drops all the indexes and then loads the data and rebuilds the indexes. Is there an easy way to check if the indexes exist before even starting the dropping of the existing indexes. In some cases the proc
URL Decoder :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 7.x and later Description:
URL Encoder :: (Script Library)
Category: Utilities Tags: Compatibility: SQL Server 7.x and later Description:
Understanding and Leveraging Oracle9i Advisories
(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
Deploying cost-effective database storage
(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
Data Sanitization Techniques
(Dale Edgar) Data Sanitization is the process of making sensitive information in non-production databases safe for wider visibility. This White Paper is an overview of various techniques which can be used to sanitize sensitive production data in test and development databases. An initial discuss
Changing Databases at the Customer’s Location Using XML and VB
(Dinesh Asanka) As a database developer, you may be fed up with never-ending customer changes. Actually, this is not only relevant to database developers but also for all other developers. But, because database developers have to meet customer requirements, they may need to change the databases.
Format Your Way to Success with the .NET Framework Versions 1.1 and 2.0
(Juval Lowy) Serialization is the act of persisting the state of an object, typically to a file or a memory stream. Serialization is crucial when it comes to composing an application out of independent components. If an application contains several components from various vendors, how will it persis
Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET
(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.