Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed


follow us on Twitter





Brocade Doubles Down on 16 Gbps Fibre Channel

Microsoft Wants iOS Apps to Run on WP7

Avaya Debuts New Virtual Services Switch
Database Journal |DBA Support |SQLCourse |SQLCourse2










Oracle database management, tutorials, scripts, coding, programming and tips for database administrators

Oracle

Finding Database Network Abusers with Netstat 05/09

DBAs often have to relate the consumption of system resources by a database to the available resources on the database server. Sometimes this is a very difficult task. Netstat can help you see network traffic for Oracle processes. Read on to learn how.

Using Adaptive Thresholds to Monitor Oracle Database Performance 05/07

AWR baselines have been available since Oracle 10g; Oracle 11g enhances those baselines with new ways to generate them and new tricks in OEM to use adaptive thresholds to monitor the performance of the database.

Oracle Enterprise Manager 12c Cloud Control - New Features Part One 04/23

Oracle's newest release of Enterprise Manager 12c Cloud Control has a multitude of new features and functionality. Join Karen Reliford as she discusses changes to the infrastructure behind Cloud Control.

How Statistics Have Improved from Oracle 10gR2 to 11gR2 04/09

Oracle databases run better with a good set of statistics, and by good I mean representative of the data distribution or skew. Oracle 11gR2 has finally addressed two major issues of statistics gathering -- speed and accuracy -- by changing how DBMS_STATS samples the data.

Top 10 New Features for Oracle 11g Data Guard - Part Two 03/16

Karen Reliford returns to give us the final top 5 of her top 10 favorite new features in Oracle 11g Data Guard, their primary product for protecting databases and an integral part of many Disaster Recovery plans.

Using Application Editions To Make Upgrades Less Painful 03/14

Oracle 11g Application editions are a very useful addition to an already world-class database, allowing developers to make changes to existing tables and schemas without affecting current users in the testing environment. Read on to learn more...

Oracle's Ever Increasing Index 02/22

Indexes are interesting objects -- they can dramatically improve performance but their management can be tricky. Let's take an example through a number of iterations and see what Oracle does with the index, and explain why the results shouldn't be unexpected.

Oracle Invisible Indexes 02/06

In 11.2, Oracle offers the option of invisible indexes, which can't be 'seen' by any session by default, so it can be created and remain unavailable until testing is scheduled. This can be confusing since Oracle has never offered such a feature. Looking at an example might clear up any confusion.

Archiving Oracle Databases 01/11

Archiving older data is a complex task. Within the context of an Oracle database there are methods of archiving data, some simple, some a bit more complex but still within the realm of possibility. Let's look at those options and what they can, and cannot, offer.

Oracle 11gR2 I/O Performance Tuning: Using Solid State Drives 12/02

Solid-state drives (SSDs) can make an incredible difference when applied judiciously to an apparently intractable I/O performance bottleneck.

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Using Autoextend to Increase Oracle Database File Sizes 11/04

Autoextend can save DBAs precious time by allowing Oracle to automatically increase database file sizes to a pre-determined limit.

Database Buyer's Guide Conclusion: Which Database Is Best for You? 10/27

Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?

PGA and Memory Management in Oracle 09/26

Oracle has evolved over the years to make PGA and memory management easier for DBAs.

Monitoring Index Usage in Oracle Databases 08/22

Oracle can help you determine which indexes are not being used to help boost application and database performance.

Oracle Archives



Latest Forum Threads
Oracle Forum
Topic By Replies Updated
no matching unique or primary key rcanter 1 April 25th, 03:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 09:01 PM
A good book for Oracle DBA? luca2000 0 February 27th, 08:58 AM
PLEASE Guide me through this ERD latinunit 0 February 25th, 09:29 AM