|
Solution Search:
This tip was originally published on SearchSQLServer.com. Working with both Oracle and SQL Server databases presents a variety of challenges -- precisely why we've compiled this collection of short lessons by Kevin Kline, our resident Monitoring/Administration expert. If you have questions about working with Oracle and SQL Server, submit them today.
Kevin Kline Your Instructor... More... Jun 12, 2006
A set-oriented method for representing trees in SQL that runs orders of magnitude faster than the adjacency list (i.e. child-parent pairs) method. [Ed. note: A follow-up to this article is also available.] The usual example of a tree structure in SQL books is called an adjacency list model and it looks like this: CREATE TABLE Personnel (emp CHAR(10) NOT NULL PRIMARY KEY, boss CHAR(10) DEFAULT NULL... More... Mar 31, 2001
As you will recall from my previous article, the usual example of a tree structure in SQL books is called an adjacency list model and it looks like this: CREATE TABLE Personnel (emp CHAR(10) NOT NULL PRIMARY KEY, boss CHAR(10) DEFAULT NULL REFERENCES Personnel(emp)); Personnel emp boss =================== 'Albert' 'NULL' 'Bert' 'Albert' 'Chuck' 'Albert' 'Donna' 'Chuck' 'Eddie' 'Chuck' 'Fred' 'Chuck'Another way of representing trees is... More... Feb 12, 2002
Looking for your first Oracle job as a DBA or developer? Concerned about the future of your current position? You're not alone! With the IT market becoming increasingly competitive, it can be very difficult to find a job working with Oracle or keep the one you've got. We know how time-consuming it can be to search the Web for relevant career information, so we've gathered some valuable Oracle...
More...
Mar 1, 2006
By default, SQL*Plus does not support command history on Linux, which makes the tool difficult to use out of the box. I spent weeks looking for a solution to this problem on Google.
I finally found this at http://www.dizwell.com/html/cli_history.html:
Install rlwrap on your system. On gentoo I emerged it so in debian or other distros there should be an RPM or package available. Edit your /home/you... More... Sep 14, 2005
Too often the debates over cheaper, faster and better deteriorate into religious wars. Just mention the sins of the Macintosh computer, the Linux operating system or non-Intel silicon to get the argument going. But as developers and programmers look for new jobs or move up within their own organizations, they may debate the merits of being proficient in both Java and Microsoft's C#. Yes, it... More... Feb 12, 2003
BFF (best friends forever)? Not quite. More like two kids on the DBMS playground that would just as soon throw spitballs at each other as play nice together. However, with the release of SQL Server 2005, it has become easier than ever for SQL Server to coexist with rival Oracle. In this article, I provide an overview of some of the new and old ways to successfully exchange data between Oracle and... More... Oct 4, 2007
Enterprise application integration (EAI) and Web services technologies solve integration problems in different ways. Find out how these two technologies differ and how to determine the right approach to your integration problem. Integration is an age-old problem for IT, probably going back to when the second application was installed in the first computer shop. Indeed the more... More... Jan 24, 2002
Like coding, tuning is an area about which hundreds of pages have been written. But I can distill this mass of material into a few good practices.
It is a good practice to perform proactive database monitoring. Proactive database monitoring means that you must, at a minimum: Monitor for space usage. Monitor waits. Monitor for execution times for standard queries/procedures. Monitor for... More... Feb 23, 2007
This tip is excerpted from the book Practical Oracle Security: Your Unauthorized Guide to Relational Database Security by Josh Shaul and Aaron Ingram. Printed with permission from Syngress, a division of Elsevier. Copyright 2008. For more information about this title, please visit www.syngress.com. Authentication is the gateway to the database, and for the vast majority of Oracle... More... Nov 6, 2007
I came across this Data Guard situation lately where a datafile was added to the primary database, but failed during creation on the standby. The database version was 10.2.0.3 and standby_file_management was set to AUTO.
Standby_file_management is a parameter, and when set to AUTO on the standby site, will create datafiles automatically on the standby site, for every datafile created on the... More... Feb 25, 2008
Introduction
With today's growing need to retain every little bit of data, be it to meet regulatory requirements, support end-user needs, feed business intelligence and trend analysis, accommodate overall business growth or just support the consolidation of data from various systems, data managers are looking for solutions to better address and manage data growth. We see the... More... Sep 13, 2007
This is Chapter 1 from the O'Reilly book "Learning Oracle PL/SQL" by Bill Pribyl & Steven Feuerstein. You can purchase the book here. In this chapter:What Is PL/SQL? Why Use PL/SQL? What You Need to Get Started with PL/SQL Let's start at the beginning and take a look at what Procedural Language/Structured Query Language (PL/SQL) really is, what it is good for, and how it fits into the world. What Is PL/SQL?... More... May 27, 2003
This is an excerpt from Chapter 15 of the book "OCA Oracle Database 11g: Administration I Exam Guide"
by John Watson, copyright 2008 from Oracle Press, a division of McGraw-Hill. Click here to download the full chapter.
Perhaps the most important aspect of a database administrator's job is to ensure that the database does not lose data. The mechanisms of redo and undo ensure that it is... More... Jun 12, 2008
This is an excerpt from Chapter 2 of the book "Oracle Database 11g DBA Handbook" by Bob Bryla and Kevin Loney, copyright 2008 from Oracle Press, a division of McGraw-Hill. Click here to download the full chapter.
If you have previously installed an earlier version of the Oracle database server, you can upgrade your database to Oracle Database 11g. Multiple upgrade paths are supported; the... More... Jan 17, 2008
The collapse of major financial institutions has rippled through the economy, and managers everywhere are searching for ways to stretch their dollars. In this two-part article, we explore the ways in which Oracle managers can trim their budgets to survive the looming worldwide recession.
Bank failures, global insecurity, the credit crunch and declining sales mean corporations are... More... Nov 11, 2008
Data modelers are often faced with the dilemma of how to model logical attributes in their data warehouse schema design. A new feature in Oracle 11g called virtual columns solves this dilemma by exposing logical attributes while reducing object management and storage consumption. Additionally, virtual columns can be used to improve availability, manageability and performance...
More...
May 8, 2008
This series is a collection of tips that explain in detail how to perform specific tasks in Oracle related to database administration. Consisting of expert advice from our panel of top Oracle gurus, these how-tos provide step-by-step instructions to guide you through database administration processes related to installation and upgrades, backup and recovery and other Oracle... More... Dec 12, 2007
In the previous installment, we explored ways the Oracle manager could cut his budget by trimming hardware and software costs,. But the sad reality is that the lion's share of a typical budget is for highly talented and well-compensated Oracle professionals, those indispensable folks who create and maintain the applications that allow the company to manage its information. Cutting...
More...
Nov 11, 2008
This is an excerpt from Chapter 2 of the book "Oracle Database 11g PL/SQL Programming "
by Jason Price, copyright 2008 from Oracle Press, a division of McGraw-Hill.
Click here to download the full chapter.
As an introduction to PL/SQL basics, this chapter introduces and briefly discusses Oracle PL/SQL block structure Variables, assignments, and operators Control structures Conditional... More... Jun 18, 2008
The following is an excerpt from chapter one of the upcoming Rampant Press technical book, Migrating to Oracle: Expert Secrets to Migrate from SQL Server and MySQL by Ben Prusinski.
Overview of Oracle Migration Oracle migration is the process of moving from one database platform to a different database platform. In contrast, a database upgrade would be a movement from one particular... More... Mar 20, 2008
Ever wonder how all that storage you purchase is being used? If you're having trouble getting an answer to this question, you're not alone. Many organizations find it difficult to truly understand their soaring storage budgets. This is usually due to the lack of visibility into the various management domains, poor management practices and the psychology of organizational behavior.
... More... Apr 6, 2007
This tip originally appeared on SearchOpenSource.com.
PostgreSQL and MySQL are making significant inroads into businesses' software portfolios, say the authors of Apress' Beginning Databases with PostgreSQL. When the costs of licensing and maintenance are compared to that of big name vendors, the savings become significant. In this tip, Neil Matthew and Richard Stones explain... More... Oct 10, 2006
This tip originally appeared on SearchOpenSource.com.
Why are you paying so much in licensing costs and annual maintenance when you could use PostgreSQL for free, and get community support and upgrades for free as well? This is the question that Neil Matthew and Richard Stones pose to smaller companies regarding their less critical applications. Matthew and Stones, authors of... More... Oct 10, 2006
Introduction
Flashback Database is a new approach to point-in-time (PIT) database recovery. This incomplete recovery strategy can be used to recover a database that has been logically corrupted due to human error. Introduced in 10g, it is designed to maximize availability by reducing recovery time. This article will explore Flashback Database, compare it against traditional... More... Sep 27, 2006
|
Oracle Content
Oracle Solutions
|