Free Newsletters:
Database Daily  
DBASupport

 The Knowledge Center for Oracle Professionals

Search DBAsupport:
 
HOME 11g Central 10g Central 9i Central 8i Central Oracle News Scripts FAQ OCP Zone Resources Technical Docs Tools & Utilities Forums
internet.com


» HOME
» FEATURES
    11g Central
    10g Central
    9i Central
    8i Central
    Oracle News
» COMMUNITY
    Scripts
    Forums
    FAQ
    OCP Zone
» RESOURCES
    Resources
    Technical Docs
    Tools & Utilities
    Tech Jobs
Marketplace Partners
Become a Marketplace Partner


internet.commerce
Be a Commerce Partner












internet.com
Internet News
Internet Investing
Internet Technology
Windows Internet Tech.
Linux/Open Source
Web Developer
ECommerce/ Marketing
ISP Resources
ASP Resources
Wireless Internet
Downloads
Internet Resources
Internet Lists
International
EarthWeb
Career Resources

Search internet.com
Advertise
Corporate Info
Newsletters
E-mail Offers



 






DBASupport Examining the Oracle Database 10053 Trace Event Dump File
Ever wonder what the Oracle Database Cost Based Optimizer (CBO) was doing behind the scenes or how it comes up with an execution plan? While other tools or settings show us WHAT the CBO comes up with, the 10053 trace event setting tells us HOW the CBO came to its decision (the final execution plan).

I/O Performance Tuning Tools for Oracle Database 11gR2
Oracle Database 11g Release 2 (11gR2) makes it easier than ever to isolate and identify potential root causes of poor I/O performance. This article focuses on the various Oracle and non-Oracle tools to generate sample workloads to provide sufficient metrics for detection and eventual resolution of performance bottlenecks within the databases underlying input/output (I/O) subsystem.

Solve Database Performance Tuning Problems by Monitoring CPU Resource Consumption
Constantly watching CPU utilization is critical to a database administrator's understanding of their database system. The sar utility, while seemingly small and insignificant can and should be used to help initially determine if any high-level CPU resource usage is out of balance, potentially signaling a database performance tuning problem.

Purchasing Oracle Database Support for your Own Use
Oracle's software is freely available for personal use but you'll have to pay for access to technical notes, patches, and other specialized content. Plus, there's a technical/legal catch; you can't use My Own Support to find database articles under a different product license. In terms of compliance, you really need a database product. Enter Oracle Database Personal Edition.

Regain Control of Your Oracle Database with DBMS_METADATA_DIFF
Database change control is always difficult even under the best scenarios. Using Oracle's DBMS_METADATA_DIFF becomes a great weapon for DBAs to regain control.

Oracle Database 11gR2 I/O Performance Tuning: A Primer
Tuning the performance of Oracle Database 11gR2 is still just as much of an art as it is a science. Jim Czuprynski focuses on the detection and analysis of performance bottlenecks within the database's underlying input/output (I/O) subsystem.

Installing Oracle Database Sample Schemas using Data Pump
Having a re-usable dump file for installing Oracle Database Sample Schemas is much more convenient than the current method. Would you rather download a compressed file containing one (or several) dump files, including a parameter file suitable for use during an import session or job or use the Oracle Universal Installer?

Getting Oracle VM VirtualBox Ready for an Oracle Database
Everyone wants to go virtual, but getting started with Oracles VM VirtualBox can be tricky. James Koopmann takes a quick look at installing Oracle VM VirtualBox 3.2.4, covering some of the features you as a database administrator or database developer might run across while trying to install an operating system or Oracle database.

PL/SQL Records for Oracle Database Administrators
It can be hard, as an Oracle Database administrator, to expand your PL/SQL skills due to a lack of good examples, not to mention that lines upon lines of syntax definitions can be somewhat of a turn-off. Steve Callan shows how using PL/SQL records can simplify what you have to code - and they're easy to use too.

Little Known Uses for Oracle Database's Error Tool
Oracle Database's Oracle Error messaging system is often forgotten but can become a staple for many Database Administrators.

Leveraging ACFS Snapshots and Cluster Infrastructure in Oracle Database 11gR2
Jim Czuprynski illustrates how to upgrade an Oracle Database 11gR1 quickly and efficiently to Oracle Database 11gR2 and place its database files within ASM-managed storage, including a brief demonstration of how ACFS snapshots can be used to recover quickly from human error when crucial components of an Oracle home are damaged or destroyed.

Setting Up Oracle Database's Oracle Text
Steve Callan walks through some Oracle Text setup steps and working examples of different index types used by Oracle Text.

Monitoring Oracle Database 11g R2 with Oracle Enterprise Manager
Simplify the monitoring of queries in Oracle Database with Oracle Enterprise Manager (OEM). Learn how to analyze query related activity and reach a definitive conclusion of database performance.

Oracle Database's ADRCI: the Extended Commands
Oracle's ADRCI extended commands provide valuable scripting and file viewing options, with about two dozen commands that you can use to look at and manage diagnostic information.. ADR is the future of Oracle diagnostics and it's essential that database administrators understand it.

Oracle Text - Expanding Your String Searching Capabilities in Oracle Database
Searching for text within a database can be like searching for the proverbial needle in a haystack. Users depend on the database administrator to solve complex text search requirements. Do you respond with clever methods such as LIKE, regular expressions and function-based indexes? Is there something more available to you and your users?

» More Features...

Receive articles via our XML/RSS feed




DBASupport News Postgres Plus Advanced Server Database adds Enhanced Oracle Database Compatibility
EnterpriseDB announces immediate availability of Postgres Plus Advanced Server database version 8.4, adding several usability and management enhancements including an Enhanced Oracle compatibility layer.

Oracle Now Has Another Rival After EU Approves SAP $5.8 Billion Takeover of Sybase
Will the biggest maker of business software be able to extend the Sybase database to rival that of Oracle?

Oracle Database Experts: Share Your Story
Just a couple weeks left to get your Oracle database or application abstract in for review to the UKOUG Conference Series.

Oracle's July Critical Patch Update for the Oracle Database Supported by Application Security, Inc.
The CPU update for the Oracle database keys in on CVE-2010-0902 as a most dangerous vulnerability.

Oracle's Acquisition of MySQL Doesn't Seem to Worry MySQL Users Much
A recent study suggests that MySQL users are upbeat about the Oracle acquisition of MySQL.

Simplify Oracle Database Development as OraDeveloper Comes to Visual Studio 2010
The Devart Team releases an updated version of OraDeveloper Tools to simplify the Oracle database application development process.

Oracle Database Critical Patch Update Address Vulnerabilities with High CVSS Score
Oracles Critical Patch Update for July 2010 contains 13 new security fixes for Oracle Database Server.

Oracle Database Client Friendly SQL version 1.6 Friendlier than Ever
Friendly SQL is an Oracle Database Client which features include a SQL Editor, Visual Database Browser, Data Export Wizard, and requires no configuration at setup.

Oracle Coherence 3.6 Steps up to Scaling and Data Grid Challenges
Now available is Oracle Coherence 3.6, a distributed in-memory data grid product that is also a component of Oracle Fusion Middleware 11g.

Oracle Licensing by Independent helps Customers Ensure they are Properly Licensed
After nine month review process, iQSonar releases Oracle Licensing solution so companies can manage their Oracle software license risk; ensuring they are properly licensed for software they use.

Oracle DBA Headed to Jail and to Pay $100,000 in Restitution
DBAs, some of the closest individuals to corporate data, get a wakeup call on malicious attempts against their companies.

Oracle has Released Oracle Business Intelligence 11g
Oracle has now released its Oracle Business Intelligence 11g, a complete suite of products providing business intelligence capabilities from enterprise reporting to scorecards and ad hoc queries.

Oracle Technology Network Site Merger with Suns Content Nearing Completion
July 19th will mark the completion date for developers.sun.com, java.sun.com, and BigAdmin to be merged with the Oracle Technology Network.

Oracle, DB2, and Other Databases Sync to Android and More with MobiForms
MobiForms Sync Server supports Oracle, MySQL, DB2, Sybase, SQL Server, among other databases.

Oracle's Sun Merger; Seems Monty Just Wont Give Up
Michael Widenius, co-founder of MySQL is at it again; submitting an appeal with the European courts decision to clear the Oracle takeover of Sun.

» More News...

Receive news via our XML/RSS feed




Bulk File Edit
This script will go through each file with the *.dat extension in a directory and fill the 3rd pattern "<>" in the line that contains a specified directory, with a specified path.

FULL OUTER JOIN LOOP
This script displays matched records from two tables when constraints prevent a full outer join.

IF EXISTS/IF NOT EXISTS
This script creates a user, if the user does not exist in the db and drops the user, if the user exists in the db.

Killing Sessions
Use this script to kill a job and re-run it fter incorporating HINTS.

Debugging Column Length
This script debugs column length mismatch in Oracle tables and joins the matching rows through an equi join.

» More Scripts...



Latest Database Articles from DevX
Google's New Predictive API Gives Cloud Developers a Big Boost
The Rise of NoSQL Databases
Will Oracle Help Java Regain its Status?
How Complex Databases Are Governed In the Mormon Church
Flex RESTing with MySQL


Database Administration Forum Latest Forum Threads
Topic By Replies Updated
  rman differential vs cummulative backups BeefStu 6 July 29th, 11:59 AM
  index not used for negative numbers mitpat121 18 July 29th, 12:46 AM
  ORA-55567: Message 55567 not found; product=RDBMS; facility=ORA Mohith123 0 July 28th, 05:48 AM
  E-Business Suite tech question ridges54 1 July 27th, 08:23 PM


Database Development Forum Latest Forum Threads
Topic By Replies Updated
  string processing help Sonia 2 July 29th, 09:23 AM
  help with the where clause of an update jayjabour 2 July 26th, 08:47 AM
  Load the data file name in the column of table using sqlloader himalayhaa 1 July 22nd, 06:38 AM
  Control size of oracle forms Alert dialog pablogosse 0 July 21st, 03:28 PM