Lean the interesting discussion about that Can Oracle kick SQL Server's behind? Oracle versus SQL Server in the Enterprise Edition. Oracle expert David throws down the gauntlet to Microsoft devotees.
Published at 18 Dec 2008, Visited 8066 Times. 1 Comments
An Oracle database system comprises at least one instance of the application, along with data storage. An instance comprises a set of operating-system processes and memory-structures that interact with the storage.
Published at 18 Dec 2008, Visited 6792 Times. 1 Comments
As of Oracle 8.1, we can now send email from within an Oracle application. This is done by using the UTL_SMTP package. However, it should be noted that there are some shortcomings with this package that may or may not be a problem for us.
Published at 18 Dec 2008, Visited 5940 Times. 0 Comments
With the ever-burgeoning feature sets available in modern databases, it's difficult to separate the wheat from the chaff. There are plenty of high-level data warehousing features in Oracle for instance that you might never need.
Published at 18 Dec 2008, Visited 6367 Times. 1 Comments
This article is a basic primer to get you started using Advanced Queuing in Oracle9i and Oracle8i. Such as
* Environment Setup
* Define Payload
* Create Queue Table And Queue
* Grant Privilege On Queue
* Enqueue Message
* Dequeue Message
Published at 18 Dec 2008, Visited 4118 Times. 0 Comments
Oracle9i now supports the ANSI/ISO SQL: 1999 standards. This allows easier product migration and a reduced learning curve when cross-training, but there is no performance increase compared to the existing syntax.
Published at 17 Dec 2008, Visited 3921 Times. 0 Comments
Most of the Oracle 10g databases are using ASM for storage as it's very simple to maintain the storage w.r.t. to Disks, Datafiles etc. We can get most of the ASM details & implementation details from OTN here...
Published at 17 Dec 2008, Visited 5647 Times. 0 Comments
?Find out how to use DBMS_SQLTUNE package to tune SQL Statements in Oracle 10g? Have you ever been frustrated with SQL Tuning? Did you get lost in the maze of /+ HINTS +/ and analysis paralysis? Pre-10g you have to be either a SQL tuning expert or should have a license to...
Published at 17 Dec 2008, Visited 9246 Times. 0 Comments
Oracle 10g?s brilliant alternative to database point in time recovery is the the Flashback Database feature. With this feature in place you can do almost everything that you can do with point in time recovery,
Published at 16 Dec 2008, Visited 9774 Times. 1 Comments
The use of XML for data transfer has increased dramatically over the last few years. Since most applications still rely on structured relational data it is necessary to explode the non-structured XML data into relations tables
Published at 16 Dec 2008, Visited 13087 Times. 5 Comments
When using RAC or ASM under Oracle 10g Release 2, the Oracle Clusterware automatically starts and stops the Oracle database instances, so the following procedures are not necessary.
Published at 16 Dec 2008, Visited 5489 Times. 1 Comments
In a recent forum thread we was asked how we would load an XMLTYPE column in a table from a file. This article explain one way of doing this. Here first we create the necessary schema objects then we create a procedure to load a file into the table
Published at 15 Dec 2008, Visited 3840 Times. 0 Comments