Email Alerts
-
Collaborate 2013 Oracle user groups show guide
Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish. Collaborate 2013
-
Pluggable Database virtualizes Oracle Database 12c
Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features. Feature
-
OpenWorld and JavaOne 2012 conference coverage
guide
-
Oracle OpenWorld 2012 special report
The 30th annual Oracle OpenWorld conference has 50,000 registered attendees and is packed full of sessions and keynotes on Oracle databases, applications, middleware and hardware, among other topics. OpenWorld occurs the same time as JavaOne 2012, an... guide
-
The 2012 Dynamic Database Project Award
The award will recognize the most innovative, cost-saving, best database project of 2012. Enter for a chance to win an Apple iPad. Deadline is Nov. 9. guide
-
SearchOracle.com Advisory Board
Advisory Board
-
Oracle 10g tops list of Oracle database platforms
In a survey taken in 2010, Oracle professionals listed Oracle Database 10g as their primary database platform, despite 11g having been out since 2007. Slideshow
-
Oracle upgrades lead expected database changes this year
Oracle database upgrades will be big on Oracle professionals' list of things-to-do this year, according to a recent survey by SearchOracle.com. Slideshow
-
How to determine your SQL database through needs analysis
Finding the best SQL database for your company can be a long-drawn-out process that should not be taken lightly. The journey starts with a single step: a thorough 'needs analysis. Guide
-
The MySQL open source database in the enterprise
The MySQL open source database is not a head-to-head competitor with the SQL database offerings of Oracle, IBM and Microsoft, but many have discovered its hidden advantages. Guide
- See more Essential Knowledge on Oracle database design and architecture
-
Introducing Pluggable Database, the star of Oracle Database 12c
Meet Pluggable Database, the star of Oracle Database 12c—it may redefine database virtualization. News | 15 Feb 2013
-
Oracle Database 12c, Exadata x3 highlight OpenWorld keynote
Oracle CEO Larry Ellison highlighted some features of the new Oracle Database 12c and Exadata X3 products announced at Oracle OpenWorld 2012. News | 30 Sep 2012
-
Oracle Database 12c to be announced at OpenWorld
The first major upgrade to Oracle's flagship database product in three years will include features around the cloud, tuning and automation. News | 21 Sep 2012
-
Quest Software, its Toad tool leaping over to Dell
Dell plans to acquire Quest Software, maker of the Oracle Database development tool Toad. End users said Dell could improve Toad and adapt it for larger tech trends like “big data.” News | 02 Jul 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
-
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 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
-
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
-
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
- See more News on Oracle database design and architecture
-
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
-
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
-
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
-
Oracle database consolidation is a paradigm shift
Oracle database consolidation can save IT organizations a lot of money, but require them to get past the mental hurdle of so-called shared databases. Tip
-
Dealing with Oracle Database bottlenecks
Unclogging Oracle Database bottlenecks can range from simple SQL re-coding to examining CPU use and monitoring the network infrastructure. Tip
-
Oracle XML capabilities in Oracle Database 11gR2, part 3
This third part of a series on Oracle XML capabilities explains how to ingest, shred and publish XML data in Oracle Database. Tip
- See more Tips on Oracle database design and architecture
-
Why won't TNS listener connect with Oracle Database 11g 32-bit?
One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g. Answer
-
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Answer
-
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 temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large. Answer
-
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
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata. Answer
-
Oracle Exadata and SGA caching
One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata. Answer
-
Cache Fusion for RAC on Exadata
One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms. Answer
-
Can I use special characters in Oracle table names?
Learn why you may want to avoid using special characters in Oracle table names when they also have meaning in utilities or SQL scripts in this tip from Oracle database expert Brian Peasland. Answer
- See more Expert Advice on Oracle database design and architecture
-
in-memory database
An in-memory database is a type of analytic database designed to streamline the work involved in processing queries. Definition
-
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
-
flexfield
In an Oracle environment, a flexfield is a database field that has flexibility built into it so that users can define reporting structures that are relevant to their specific organizations. Definition
-
E. F. Codd (Edgar F. "Ted" Codd)
E. F. Codd (Edgar F. "Ted" Codd) formed the concepts for organizing and accessing data that are embodied in the relational database, the predominant approach to data organization in today's business world. Definition
-
extent
An extent is a set of contiguous blocks allocated in a database. Definition
-
row
In a database, a row (sometimes called a record) is the set of fields within a table that are relevant to a specific entity. Definition
-
splay tree
A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database. Definition
-
field
A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size. Definition
-
quad tree
A quad tree is a method of placing and locating files (called records or keys) in a database. Definition
-
record
In computer data processing, a record is a collection of data items arranged for processing by a program. Definition
- See more Definitions on Oracle database design and architecture
-
Rich Niemiec on Oracle database 12c, database security and Larry's law
We caught up with Rich Niemiec at Collaborate 13. Listen to his observations on such topics as Oracle database 12c and more. Videocast
-
What Oracle Database queries to tune, and when to index
Popular Oracle author and consultant Richard Niemiec talks about what Oracle Database queries are the best to tune, when it’s smart to index, and the importance of Exadata. Video
-
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
-
What managers should consider when starting a database scaling project
Learn about database scaling from Oracle consultant Don Burleson, who discusses the goals, costs and challenges of scaling an Oracle database in this podcast. Podcast
-
Rich Niemiec on Oracle database 12c, database security and Larry's law
We caught up with Rich Niemiec at Collaborate 13. Listen to his observations on such topics as Oracle database 12c and more. Videocast
-
Collaborate 2013 Oracle user groups show guide
Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish. Collaborate 2013
-
Introducing Pluggable Database, the star of Oracle Database 12c
Meet Pluggable Database, the star of Oracle Database 12c—it may redefine database virtualization. News
-
Pluggable Database virtualizes Oracle Database 12c
Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features. Feature
-
Oracle Database 12c, Exadata x3 highlight OpenWorld keynote
Oracle CEO Larry Ellison highlighted some features of the new Oracle Database 12c and Exadata X3 products announced at Oracle OpenWorld 2012. News
-
OpenWorld and JavaOne 2012 conference coverage
guide
-
Oracle OpenWorld 2012 special report
The 30th annual Oracle OpenWorld conference has 50,000 registered attendees and is packed full of sessions and keynotes on Oracle databases, applications, middleware and hardware, among other topics. OpenWorld occurs the same time as JavaOne 2012, an... guide
-
Oracle Database 12c to be announced at OpenWorld
The first major upgrade to Oracle's flagship database product in three years will include features around the cloud, tuning and automation. News
-
The 2012 Dynamic Database Project Award
The award will recognize the most innovative, cost-saving, best database project of 2012. Enter for a chance to win an Apple iPad. Deadline is Nov. 9. guide
-
Why won't TNS listener connect with Oracle Database 11g 32-bit?
One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g. Answer
- See more All on Oracle database design and architecture
About Oracle database design and architecture
Have a question about best practices for Oracle database design, configuration and table design? This section contains the tips and expert adivce for DBMS versions 8, 9i, 10g and 11g to help you out.