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 7868 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 6598 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 5728 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 6171 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 3976 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 3769 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 5476 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 9074 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 9568 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 12807 Times. 5 Comments