Part 21: Troubleshooting ASM problems on VMware ESX 3.x - Part 2
Tarry Singh looks at some problems that can be encountered during ESX 3.x Oracle RAC setup, and how to fix those problems.
Oracle Database 11g: Automatic SQL Tuning
This article delves into a new Oracle Database 11g feature that significantly extends this powerful 10g feature by providing the ability to implement improved execution plans automatically within DBA-specified boundaries.
The Dictionary in the Data Dictionary
Take a trip into Oracles data dictionary, specifically, the dictionary part or aspect of it.
Tuning an Oracle Procedure
Join JP Vijaykumar as he tunes a procedure that is running for eight hours, bringing the run time of the procedure down to three hours.
Troubleshooting ASM problems on VMware ESX 3.x
Several errors may be encountered when setting up ESX 3.x on Oracle Rac. This article covers some of those errors and how to fix them.
Oracles Transportable Automatic Workload Repository
Oracles Automatic Workload Repository provides a whole new way of gathering, comparing and storing statistics. Read on to learn how AWR differs from the old statspack reports.
Making Database Administration Easier with Freeware
Cygwin, an OpenSSH application, helps relieve the stress of more commonly seen administration problems, including not being able to get a GUI tool (e.g., Oracle Universal Installer) to display and not being able to have it display at the correct location.
Using Orion Calibration to check I/O numbers
Orion is an I/O metrics testing tool, designed specifically to simulate the I/O workload before installing Oracle RAC on the hardware. It is ideal for capacity planning and checking DAS, SAN or NAS storage. Read on to learn more.
Product Review: HyperBac for Oracle
A relatively new product called HyperBac provides an excellent alternative to Oracle 10gR2 compressed backupset methodology without the need to modify any RMAN backup, restoration, and recovery scripts. This article provides an overview of HyperBac features that nicely complement Oracle 10gR2's enhancements to database backups and exports.
Oracle: Synonyms Synonyms
Oracle restricts the length of object names (tables, columns, views, procedures) to 30 characters, but does not impose the 30 characters length restriction on synonym names. Read on to learn how to create synonym names of any length.
Clearing Alerts in Enterprise Manager
Using Oracle Enterprise Manager can be one of the most frustrating experiences in Oracle because of OEMs non-intuitive, disjointed interface and OEMs inability to clean up after itself. Follow along with Steve Callan as he delves into the mystery of how to clear alerts in Enterprise Manager.
Part 4 - Clustering Oracle RAC Virtual Machines across physical and ESX hosts
Part 4 of this series examines various possibilities for building clusters across several physical and ESX hosts and takes a quick look at upgrading clustered Virtual Machines in all the three scenarios.
Oracle, MySQL and PostgreSQL feature comparison Part 1
Oracle, MySQL and PostgreSQL obviously have a lot of features, and different solutions for the same problems. This article looks at the major features, such as stored procedures, views, snapshots, table datatypes, transactions, and so on, to discover which ones do what you need.
Learning Oracle by the Numbers
It's hard enough mastering Oracle 10g, let alone trying to devote time to learning the nuances of an older version. Steven Callan offers advice on how to overcome a step or two backwards with respect to Oracle.
Oracle RAC: How shared storage works on VMware Part 3
Our previous article looked at the clustering possibilities on the ESX Server. In this article, we will examine the various possibilities for building clusters across several physical ESX hosts and the clustering possibilities across ESX hosts and physical machines.
»
More Features...
Receive articles via our XML/RSS feed
 
Will Oracle outbid SAP for Business Objects?
It would be just like Oracle to try and outbid SAP for business intelligence (BI) software maker Business Objects -- but SAP executives are hoping that it just doesn't happen.
Oracle simplifies managing 11g database storage
Users are eager to test Oracle Corp.'s embedded network file system (NFS) client...
XML-Enabled Applications - Part 4
When building XML-enabled PHP/Oracle applications, the database can be used as an efficient means of storing XML data and will operate on any kind of data that can be expressed in XML. PHP's XML extensions allow you to take advantage of Oracle XML DB.
Oracle Raises Retention Profile
The company thinks its latest records-management software poses a formidable threat to industry leaders IBM and EMC.
Oracle Maestro 7.10 released
SQL Maestro Group announces the release of Oracle Maestro 7.10, a Windows GUI solution for Oracle database server administration and database development.
Oracle Pushes Enterprise 2.0
Oracle believes Enterprise 2.0 technologies can transform the way employees inside a company share information and work together.
Oracle and SQL Server: The new Odd Couple?
When instances of Microsoft SQL Server start popping up in Oracle Database shops, it's often the result of a CIO mandate designed to lower costs. But other times, SQL Server's proliferation begins from lower rungs on the company ladder...
XML-Enabled Applications - Part 3
In this section we look at validating XML documents against XML schemas. Topics covered include: retrieving XML data, accessing relational data through XMLType views, using XMLType views and performing DML operations on XML schema-based XMLType views.
Oracle Extends Leadership in Data Warehousing with the Oracle Optimized Warehouse
Oracle today announced the Oracle Optimized Warehouse Initiative to help accelerate data warehouse deployments by offering a choice of optimized solutions...
Data virtualization: The answer to the integration problem?
Data integration is a difficult proposition, but help is coming in the form of a relatively new approach to information management called data virtualization, according to one expert.
SAP-Oracle Trial Set For Early 2009
A U.S. district judge in San Francisco sets the tone, parameters and timeline for legal proceedings that may lead to a February 2009 trial.
XML-Enabled Applications - Part 2
Oracle XML DB allows you to perform SQL operations on XML data as well as XML operations on relational data, thus bridging the gap between the SQL and XML worlds. You can choose between several storage options and achieve required levels of performance and scalability.
Guide to Oracle Berkeley DB for SQL Developers
Get an introduction to using common SQL functions in Oracle Berkeley DB, from one of its inventors.
Oracle Shatters 1Q Estimates
Another blockbuster earnings report ratchets up the pressure on arch-rival SAP.
Microsoft offers Oracle defectors up to 50 percent off SQL Server
SQL Server 2008 isnt set to be released to manufacturing until the second quarter of next year. But Microsoft already is taking aim at Oracle with its forthcoming release.
»
More News...
Receive news via our XML/RSS feed
Hierarchial Loop I
This procedure finds all the employees working under 'KING' from the 'SCOTT.EMP' table.
Starting with 'KING' all the employees working under 'KING' or under his subordinates are found.
Code Generation for Table Triggers
Creates a procedure in which table names may be passed to create an AFTER UPDATE audit trigger for the table.
DateDiff Function
Determine the elapsed time between two dates stated in a specific interval.
PL/SQL String Parser
PL/SQL String Parser can parse sentences and paragraphs that are separated by blank lines of any length and new lines.
Beyond Find
Delete all the files from the temporary directory,
leaving only the recently created last 4 files.
»
More Scripts...
|
Featured in the
