(David Baum) The trend is inescapable: Networks get faster, computers get more powerful, clustering technologies get more effective, and storage devices get more efficient. These advances pave the way for software applications that are more capable and intelligent, automating a diverse array of busi

(Jim Czuprynski) Oracle 10g Release 2 (10gR2) has improved significantly the methodology for tracking performance metrics within the database. This article – the first in this series – discusses how adaptive thresholds are designed to improve the detection of threshold violations, including the abil

(Bob Watkins) Before version 9i, Oracle had no built-in way to record the passage of time. The DATE datatype records an individual moment in time; but to express a quantity of time (i.e., an interval), database designers had to convert the interval to raw seconds and use a NUMBER column to store it.

(Jayaram Krishnaswamy) Many enterprises need to move data from one kind of data source to another. This tutorial guides you through the steps necessary to move data from Oracle XE into a SQL 2005 Server database.

(James F. Koopmann) The creation and use of temporary tablespaces has just taken another leap in performance and manageability, which should make us all re-think how we have created and assigned our users to temporary tablespaces.

(MS Sridhar) There are times that you may need to fetch the last couple of records that you’ve inserted. The exact number can vary. Oracle provides an easy way of retrieving these records.

(Patricia Ashe) This is a script that was passed down to me about eight years ago from another DBA and I have passed it on to others. I use it all the time to see who is logged into the database. I use it when I have to kill an OS process for a user connected to the database or […]

(Hamid Minoui) Managing space in a data warehouse environment is often one of the most challenging tasks for data warehouse database administrators. Not only are there many data files and tablespaces to manage, but the size of individual segments and partitions tends to be very large. This white pap

(Elisa Gabbert) Nearly 90% of Oracle users experienced significant downtime last year due to both planned and unplanned events, despite the fact that the vast majority say they require continuous uptime, a new survey of Independent Oracle Users Group (IOUG) members found. (R)

(Andrei Cioroianu) The Ajax core API known as XMLHttpRequest is all about sending HTTP requests for the sole purpose of exchanging data between Web browsers and servers. The JavaScript code running in a Web page can use XMLHttpRequest to submit the request parameters to a server-side script such as