- Oracle DBA tools
- Backup and recovery
- Database design
- Export, import and migration
- Installation, upgrades and patches
- Error messages
- Oracle performance problems and tuning
- Oracle security
- Availability
- Real Application Clusters (RAC)
- Cloud infrastructure
- MySQL database
Email Alerts
-
Oracle Database 11g R2 High Availability sample book chapter
Here is a sample chapter from Oracle Database 11g R2 High Availability, a new book from Oracle Press.Book chapter | 27 May 2011
-
Ensuring high availability in Oracle Database 11g R2
Scott Jesse, senior manager for Oracle RAC customer support, discusses Oracle Database 11g Release 2 High Availability, a book he co-wrote this year.News | 27 May 2011
-
virtual private database (VPD)
A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table.Definition
-
Oracle XML capabilities in Oracle Database 11gR2, part 1
New Oracle XML capabilities in Oracle Database 11gR2 allow for easier reading and manipulation of XML documents, according to columnist Jeff McCormick. In part 1, McCormick introduces the reader to XML capabilities in Oracle Database and sets up a scenario where a business wants to pull XML documents into its database.Tip
-
Quest offers new Toad tools for Oracle Java development, cloud DBs
Quest Software has released beta versions of two new Toad tools for Oracle users that focus on Java development and NoSQL cloud databases.News | 24 Sep 2010
-
Third-party tools for Oracle: Special report
Learn about the options for third-party tools for Oracle databases and why Oracle third-party tools are growing in popularity.News | 25 May 2010
-
New Toad tool offers Oracle database development with Visual Studio
Quest has released Toad Extension for Visual studio, a new database schema provider to improve Oracle database development.News | 11 May 2010
-
Oracle updates, reaffirms commitment to MySQL
Speaking to a gathering of open source database users, Oracle's chief architect said the company remains committed to MySQL.News | 14 Apr 2010
-
Oracle application development trends toward the Web
With the economy forcing developers to pursue less expensive methods of Oracle application development, many are evaluating Web development tools, including those for Rapid Application Development.Tutorial
-
Toad 10: Good for database developers, good for administrators
A major strength of Toad 10 is its ability to serve both Oracle database application developers and administrators equally well.Tutorial
- VIEW MORE ON : Oracle DBA tools
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.Tip
-
Improve the Media Recovery Process (MRP) in Oracle Data Guard
One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.Answer
-
Oracle license requirements in disaster recovery scenarios
One reader asks whether they need an Oracle license to back up their database to tape.Answer
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout.News | 03 Oct 2011
-
Data replication software helps hospital network prepare for the worst
The UPMC health network faced several data replication software challenges when ramping up its disaster recovery site.News | 21 Jul 2011
-
Copy Oracle Database but with no data
One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes.Answer
-
Oracle RAC and distance limitations
One reader asks what the Oracle RAC distance limitations are for two environments being run in sync.Answer
-
Changing file paths in a recovered Oracle database
Expert Brian Peasland helps a reader figure out how to successfully remap the file path for a database that had to be recovered from a dead server.Answer
-
Restoring to a backup instance on a backup server for a disaster recovery plan
In this Oracle database and backup recovery tip, expert Brian Peasland helps a reader restore a backup instance on a backup server in order to develop a disaster recovery plan.Answer
-
How can I identify data files with active Oracle I/O?
Can you find the data files with active Oracle I/O without affecting the application? Oracle expert Brian Peasland answers this question and offers solutions in this tip.Answer
- VIEW MORE ON : Backup and recovery
-
IBM aims new database squarely at Oracle users
The latest version of IBM's flagship DB2 database offers several features designed to coax Oracle customers out of their software comfort zones.News | 23 Apr 2012
-
Can SAP databases compete with Oracle?
SAP claims it wants to be the No. 2 database vendor by 2015, and it’s pushing to do so. But is its goal realistic, and what is Oracle doing about it?News | 17 Apr 2012
-
Oracle vs. SQL Server faceoff: Oracle Database wins on high availability security
An Oracle user group member argues that Oracle wins in the battle of Oracle vs. SQL Server.Faceoff
-
In-memory databases: Oracle TimesTen vs. Sybase ASE, part 2
In this second part, expert Mich Talebzadeh looks at how Sybase’s Adaptive Server Enterprise (ASE) in-memory database compares with Oracle TimesTen.Tip
-
In-memory databases: Oracle TimesTen vs. Sybase ASE
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system.Tip
-
Addressing quality-of-service improves Oracle database consolidation
In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns.Tip
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.Tip
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata.Answer
-
Oracle Advanced Analytics bundles R with Oracle Database
Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products.News | 08 Feb 2012
-
How Oracle Virtual Private Database helps consolidation
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation.Tip
- VIEW MORE ON : Database design
-
Addressing quality-of-service improves Oracle database consolidation
In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns.Tip
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.Tip
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata.Answer
-
One shop describes its move off Oracle on Itanium
Given Oracle’s recent announcement that it would stop software development on Itanium, one environmental services company’s decision to move to x86 Linux is timely.News | 25 Mar 2011
-
Oracle database upgrade guide
If you’re considering a move to a new Oracle database version -- especially Oracle Database 11g or Oracle Database 11gR2 -- read our Oracle database upgrade guide for tips and customer success stories.Tutorial
-
Oracle upgrades: Tips and trends
If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades.Tutorial
-
Server load problems after moving from Oracle 10g XE to 11g SE One
Experiencing server load problems when moving from Oracle 10g XE to 11g SE One? Learn ways to solve these server load issues in this tip from Oracle database expert Brian Peasland.Answer
-
Minimize database downtime when moving an Oracle DB to a new server
Learn how to minimize database downtime when moving your Oracle 10gR2 database from a Windows 2003 32-bit server to a Windows 2008 64-bit server, using the Database Configuration Assistant, in this tip from an Oracle database expert.Answer
-
Oracle backup and recovery strategies: Export dump vs. RMAN
Should you use an export dump or RMAN in your Oracle backup and recovery strategies? Learn about the importance of employing both in this tip from Oracle expert Brian Peasland.Answer
-
Can I run Oracle 9i on a Windows 64-bit O/S?
If you want to migrate Oracle 9i to a Windows 64-bit O/S environment, learn in this expert tip why you may want to install Oracle 10g or 11g first.Answer
- VIEW MORE ON : Export, import and migration
-
Midmarket companies find JD Edwards upgrades a good fit
At some point, your JD Edwards shop will have to decide whether to switch to a different product, upgrade or stay where you are. Learn what two other organizations did when working through JD Edwards upgrades.News | 08 May 2012
-
IBM aims new database squarely at Oracle users
The latest version of IBM's flagship DB2 database offers several features designed to coax Oracle customers out of their software comfort zones.News | 23 Apr 2012
-
Collaborate 2012 Oracle user groups show guide
Conference Coverage
-
Oracle vs. SQL Server faceoff: Oracle Database wins on high availability security
An Oracle user group member argues that Oracle wins in the battle of Oracle vs. SQL Server.Faceoff
-
In-memory databases: Oracle TimesTen vs. Sybase ASE
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system.Tip
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.Tip
-
Consolidate Oracle databases with session schema management
In part two of this series on database consolidation, the author explains how an Oracle consolidation can be done using session schema management.Tip
-
Can Oracle be a NoSQL player?
The Oracle NoSQL database is mainly an attempt to satisfy existing Oracle Database customers interested in big data on the side, experts say.News | 25 Oct 2011
-
Oracle’s largest database runs Beehive on Oracle Exadata
Oracle’s in-house email and collaboration application runs a 101 TB database on Oracle Exadata. A company official explained the deployment.News | 05 Oct 2011
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout.News | 03 Oct 2011
- VIEW MORE ON : Installation, upgrades and patches
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error.Answer
-
How to perform incomplete recovery to overcome Oracle database error
Learn how to perform incomplete recovery in Oracle to overcome an error after restoring with RESETLOGs in this tip from Oracle expert Brian Peasland.Answer
-
Why am I receiving Oracle memory allocation errors?
Are you receiving Oracle memory allocation errors? Learn why you may be having memory allocation problems in Oracle in this tip from Oracle expert Brian Peasland.Ask the Expert
-
Oracle error 6550 may mean incorrect Oracle export version
Oracle expert Brian Peasland explains why you might get an Oracle error 6550 when using the wrong Oracle export version in this tip.Ask the Expert
-
Are we getting the ORA-00382 error because we're at maximum block size?
Are you receiving the ORA-00382 error when determining Solaris block size? Learn what the maximum block size on Solaris is in this expert tip.Ask the Expert
-
Why does the archive log in Oracle give me the ORA-16032 error?
Oracle expert Brian Peasland explains why you might be getting the ORA-16032 error, including why starting multiple instances with the archive log in Oracle will throw the error.Ask the Expert
-
How do I solve the ORA-00257 error in Oracle?
Read about some possible solutions to the ORA-00257 error in Oracle with this expert tip.Ask the Expert
-
Error during RMAN backup
An Oracle user asks why they are receiving an error when conducting an RMAN backup.Ask the Expert
-
Unable to view Oracle tables in NetBeans
I am very new to databases (Oracle 9.2 installed) and my problem is I'm not able to view tables in NetBeans 5.5 even after establishing the connection with the database via NetBeans.Ask the Expert
-
ORA-12560 error with Oracle 10g Instant Client
I installed Oracle 10g Enterprise Edition on one computer, and the 10g Instant Client on another. When I try to connect from the other computer with I get an ORA-12560 (TNS protocol adaptor error).Ask the Expert
- VIEW MORE ON : Error messages
-
Query Tuning for Developer, Beginner DBAs
If you’re a DBA, improving query performance is probably on your mind. Read this excerpt from Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec for his take.Feature
-
Collaborate 2012 Oracle user groups show guide
Conference Coverage
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata.Answer
-
How Oracle Virtual Private Database helps consolidation
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation.Tip
-
Oracle querying for developers
What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions.Feature
-
Consolidate Oracle databases with session schema management
In part two of this series on database consolidation, the author explains how an Oracle consolidation can be done using session schema management.Tip
-
Book explores Oracle, MySQL query methods
Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview.Q&A | 29 Nov 2011
-
Oracle application performance management like a detective novel
Determining the root cause of an Oracle application performance problem might take you far, far outside the inner sanctum of Oracle database and applications.News | 29 Nov 2011
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout.News | 03 Oct 2011
-
Oracle temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large.Answer
- VIEW MORE ON : Oracle performance problems and tuning
-
Security pro: Find and secure sensitive Oracle database data
Jonathan Intner, solutions architect for data security company Vormetric, talks about what makes sensitive data sensitive, encryption key management and finding sensitive data in surprising places in this Q&A.News | 07 Dec 2011
-
Oracle Fusion Middleware evolves its mobile development platform
Oracle Application Development Framework (ADF) Mobile has improved, but the company should focus more on mobile security, a big consumer concern.Tip
-
Three trends in Oracle identity and access management
Moving toward a service-centric focus is one of three important IAM trends, according to one consultant.Tip
-
Object privileges in Oracle database security
A reader asks a question about the GRANT OPTION as it relates to object privileges in Oracle database security.Answer
-
Oracle issues patch update with 66 fixes
Oracle released a patch update with 66 fixes on Tuesday, aimed at vulnerabilities on multiple Oracle products including Oracle Database, E-Business Suite, PeopleSoft and Fusion Middleware.News | 17 Jan 2011
-
Are Oracle DBA jobs at educational institutions the right fit for you?
Read about the pros and cons of working as an Oracle DBA or developer at a college or university, and how salaries, benefits, culture and responsibilities compare to Oracle DBA jobs in other industries.News | 28 Dec 2010
-
Oracle helps solve unique database security issues at Robert Morris U.
When Robert Morris University began developing a security plan, they used Oracle to help them with unique database security issues such as threats from insiders, students and hackers.News | 22 Sep 2010
-
Implementing Oracle 11g data guard and data guard protection modes
Chapter Download
-
How fingerprint scanning works with Oracle 9i security
Interested in using fingerprint scanning in Oracle 9i? Learn about Oracle 9i security and how it works with a biometric scanner in this tip from Oracle security expert Brian Fedorko.Answer
-
Understanding the Oracle user provisioning process
This chapter describes the various sophistication levels of the user provisioning process, including discretionary account provisioning, self-service provisioning, workflow-based provisioning and more.Feature
- VIEW MORE ON : Oracle security
-
Collaborate 2012 Oracle user groups show guide
Conference Coverage
-
In-memory databases: Oracle TimesTen vs. Sybase ASE
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system.Tip
-
Data replication software helps hospital network prepare for the worst
The UPMC health network faced several data replication software challenges when ramping up its disaster recovery site.News | 21 Jul 2011
-
Mirroring in Oracle RAC and Data Guard
A reader asks a question about mirroring on Oracle RAC using Data Guard.Answer
-
MySQL high availability trends podcast
Sarah Novotny, a MySQL expert and chair of the MySQL advisory council of the IOUG, talks in this podcast about MySQL high availability.Podcast
-
Oracle RAC and distance limitations
One reader asks what the Oracle RAC distance limitations are for two environments being run in sync.Answer
-
Oracle Database 11g R2 High Availability sample book chapter
Here is a sample chapter from Oracle Database 11g R2 High Availability, a new book from Oracle Press.Book chapter | 27 May 2011
-
Ensuring high availability in Oracle Database 11g R2
Scott Jesse, senior manager for Oracle RAC customer support, discusses Oracle Database 11g Release 2 High Availability, a book he co-wrote this year.News | 27 May 2011
-
Oracle database professionals challenged by availability, upgrade issues
On top of the list for Oracle database professionals' challenges includes issues around availability and upgrades.Slideshow
-
Review: Oracle's 11g R2 database has some good and bad
Oracle made no major architectural enhancements to the 11g R2 database, but it made some useful changes and added some clunkers, too.Article | 22 Sep 2009
- VIEW MORE ON : Availability
-
Oracle licensing on Oracle Database Standard Edition
One reader asks two questions about licensing Oracle Database Standard Edition.Answer
-
Oracle Database Appliance has been slow to adoption
Alex Gorbachev, CTO of Pythian, explains why Oracle Database Appliance hasn't seen the rate of adoption that he was expecting.Video
-
Collaborate 2012 Oracle user groups show guide
Conference Coverage
-
Improve the Media Recovery Process (MRP) in Oracle Data Guard
One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.Answer
-
ATT.com eyes hybrid Oracle cloud computing
ATT.com is considering a hybrid public-private Oracle cloud computing model so it can handle highly variable traffic without having to build to peak capacity.News | 03 Nov 2011
-
Oracle Database Appliance: How much it really costs
This column from consultant Eric Guyer breaks down the hardware and software costs of the Oracle Database Appliance, unveiled last week and targeted for smaller businesses.Tip
-
Oracle Database Appliance seen as gateway to Exadata
The Oracle Database Appliance is a 4U, two-node RAC server appliance seen by experts as a more affordable entry point toward Exadata, but it doesn’t have nearly as many features.News | 21 Sep 2011
-
Is Oracle Exadata vs. SAP HANA a valid comparison?
Experts Alex Gorbachev of Pythian and John Appleby of Bluefin Solutions debate the merits of Oracle Exadata and SAP HANA.Podcast
-
Mirroring in Oracle RAC and Data Guard
A reader asks a question about mirroring on Oracle RAC using Data Guard.Answer
-
Oracle RAC and distance limitations
One reader asks what the Oracle RAC distance limitations are for two environments being run in sync.Answer
- VIEW MORE ON : Real Application Clusters (RAC)
-
ATT.com eyes hybrid Oracle cloud computing
ATT.com is considering a hybrid public-private Oracle cloud computing model so it can handle highly variable traffic without having to build to peak capacity.News | 03 Nov 2011
-
Oracle, Salesforce spar over cloud, multi-tenancy
Oracle’s latest public cloud offering came with jabs at Salesforce.com and multi-tenancy, a concept crucial to cloud computing.News | 20 Oct 2011
-
IOUG President talks Exadata, middleware
IOUG President Andrew Flowers spoke about the topics that are top-of-mind for members of the Independent Oracle Users Group, including Exadata, virtualization and middleware.News | 10 Oct 2011
-
Oracle Public Cloud: The good and bad
Oracle has decided cloud-based services do have some merit after all. But its latest offerings are missing key elements of true cloud computing services.Column | 07 Oct 2011
-
Oracle Public Cloud to offer two Fusion apps
Oracle announced the Oracle Public Cloud on Wednesday, which will initially offer Fusion CRM and HCM. Other options, for Java, a database service and a “social network,” will come later.News | 06 Oct 2011
-
Oracle Sun enterprise server hardware guide
Knowing what hardware works best for your Oracle databases, middleware and applications is key to optimizing performance. This Oracle Sun enterprise server hardware guide should help you on your way.Guide | 08 Apr 2011
-
Exadata, Exalogic, and Oracle’s move into the converged cloud
Can Oracle effectively deliver a cloud platform with their Exadata and Exalogic server appliance products?Feature | 06 Apr 2011
-
Top Oracle predictions in 2011
Oracle storage, Fusion Applications and Oracle cloud computing to be big topics this year, according four IT experts.News | 04 Jan 2011
-
Eric Guyer, consultant
Eric Guyer consults with IT organizations to optimize Oracle environments from an architectural and financial perspective.Contributor
-
Oracle cloud computing adoption slowly growing
Oracle cloud computing hasn't really caught on yet among Oracle pros, according to a recent SearchOracle.com reader survey of almost 450 Oracle pros. Interest and deployment are growing, but slowly.Slideshow
-
SearchOracle.com Advisory Board
Advisory Board
-
Oracle querying for developers
What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions.Feature
-
Book explores Oracle, MySQL query methods
Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview.Q&A | 29 Nov 2011
-
Facebook MySQL DBA gives tips on server management
Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout.News | 03 Oct 2011
-
MySQL high availability trends podcast
Sarah Novotny, a MySQL expert and chair of the MySQL advisory council of the IOUG, talks in this podcast about MySQL high availability.Podcast
-
IOUG President Andrew Flower on Oracle MySQL
Andrew Flower, President of IOUG, sat down with SearchOracle.com at the Collaborate 2011 conference in Orlando to discuss Oracle's stewardship of MySQL.Video
-
Despite lingering skepticism, Oracle soldiers on with MySQL
Oracle has announced a MySQL 5.6 development release and continues to proclaim its dedication to the open source database platform, despite ongoing skepticism.News | 12 Apr 2011
-
New Oracle MySQL council aims to mend fences
A new Oracle MySQL council within the Independent Oracle Users Group (IOUG) aims to open communication pathways between Oracle and the MySQL community, which thus far have been wanting.News | 27 Jan 2011
-
Will users dip their toes into Oracle MySQL 5.5?
Oracle announced updates to MySQL, its first since acquiring Sun Microsystems, at OpenWorld 2010 this week. But do MySQL users trust Oracle enough to dive into it?News | 21 Sep 2010
-
Oracle MySQL users have little loyalty to Oracle
Six months after the Oracle-Sun deal, end users say it’s too early to say where Oracle MySQL is going. But one thing is certain: If it goes nowhere, they’ll quickly go elsewhere.News | 26 Aug 2010
- VIEW MORE ON : MySQL database