Submitted by Donald K. Burleson on Mon, 2004-06-07 01:00
Many Oracle shops are plagued with slow I/O intensive databases, and this tip is for anyone whose STATSPACK top-5 timed events shows disk I/O as a major event.
Submitted by Mark Rittman on Wed, 2004-06-02 01:00
Submitted by Saikat Goswami on Sun, 2004-05-30 01:00
This article explores the fundamentals of a transaction, in the context of JDBC, Enterprise Java Beans and a database.
Submitted by admin on Mon, 2004-05-24 01:00
With Oracle Database 10g, there are some new arguments available for the dbms_stats package subprograms. Those parameters are as follows:
Submitted by admin on Mon, 2004-05-17 01:00
Advisors are the server components that provide you with useful feedback about resource utilization and performance. The most important of all advisors is the Automatic Database Diagnostic Monitor (ADDM). ADDM does analysis of the system, identifies problems and their potential causes, and comes up with recommendations for fixing the problems. It can call all other advisors also.
Submitted by admin on Sun, 2004-05-09 01:00
In this article (chapter) we will look at new features surrounding the DML commands INSERT, UPDATE, and DELETE.
Submitted by Donald K. Burleson on Sat, 2004-05-01 01:00
Just a few years ago, many senior Oracle DBAs detested Oracle Enterprise Manager (EM). Viewed as a crutch for beginners who could not memorize the command syntax, EM was largely ignored by the veteran DBA who preferred the ease and certainty of the SQL*Plus command-line interface. This is about to change.
Submitted by admin on Mon, 2004-04-26 01:00
Two improvements have been made in the backup and recovery areas in Oracle 10g. When user errors and logical corruptions occur in the database, flashback functionalities provide fast and flexible data recovery. When physical or media corruption occurs in the database, RMAN delivers an improved and simplified recovery method.
Submitted by Saikat Goswami on Mon, 2004-04-19 01:00
This article is the first of a series. In this series, we will discuss all the good things JDBC® 3.0 package has to offer. JDBC API provides a programmatic way of accessing data from Java code. Even though non-relational data can be accessed, the goal of JDBC and the technology revolves around accessing relational data. The JDBC is packaged in the java.sql and javax.sql packages.
Submitted by Mark Rittman on Fri, 2004-04-09 22:04
If you've been developing applications on Oracle for a while, you've no doubt come across the concept of 'Bind Variables'. Bind variables are one of those Oracle concepts that experts frequently cite as being key to application performance, but it's often not all that easy to pin down exactly what they are and how you need to alter your programming style to use them. With this in mind, I've tried to pull together the key information about bind variables and why they are a 'good thing' when building Oracle applications.