Oracle database administration
Find news, tips, scripts and advice covering all the daily tasks of Oracle database administration, including Oracle backup and recovery, installation, upgrades, patching, database design, security, performance and tuning, error messages, availability and RAC, Oracle on Linux, grid computing, data warehousing, and more.
Top Stories
-
Video
17 Jul 2024
How to install MySQL on Windows
Need a well-maintained, open-source, standards-based database to test your Java apps and Spring Boot microservices? Here's how to download and install the MySQL Community Edition. Continue Reading
-
News
16 Mar 2022
Oracle Multi-VM Autonomous Database lands on Exadata systems
The tech giant now enables users of the Exadata Cloud at Customer service to run multiple types of the vendor's fully managed and unmanaged databases on the same hardware. Continue Reading
-
Definition
10 Oct 2024
What is Oracle?
Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database. Continue Reading
-
Definition
13 Sep 2024
What is NoSQL (Not Only SQL database)?
NoSQL is an approach to database management that can accommodate a wide variety of data models, including key-value, document, columnar and graph formats. Continue Reading
-
Definition
12 Sep 2024
What is a data fabric?
A data fabric is an architecture and software offering a unified collection of data assets, databases and database architectures within an enterprise. Continue Reading
-
Definition
27 Aug 2024
What is Structured Query Language (SQL)?
Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them. Continue Reading
-
Definition
29 Jul 2024
What is denormalization and how does it work?
Denormalization is the process of adding precomputed redundant data to an otherwise normalized relational database to improve read performance. Continue Reading
-
Video
17 Jul 2024
How to install MySQL on Windows
Need a well-maintained, open-source, standards-based database to test your Java apps and Spring Boot microservices? Here's how to download and install the MySQL Community Edition. Continue Reading
-
Definition
25 Jun 2024
database management system (DBMS)
A database management system (DBMS) is a software system for creating and managing databases. Continue Reading
-
Definition
21 Jun 2024
relational database
A relational database is a type of database that organizes data points with defined relationships for easy access. Continue Reading
-
Definition
06 Jun 2024
RDBMS (relational database management system)
A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Continue Reading
-
Definition
01 May 2024
database administrator (DBA)
A database administrator (DBA) is the information technician responsible for directing and performing all activities related to maintaining and securing a successful database environment. Continue Reading
-
Definition
16 Apr 2024
query
A query is a question or a request for information expressed in a formal manner. Continue Reading
-
Definition
04 Mar 2024
star schema
A star schema is a database organizational structure optimized for use in a data warehouse or business intelligence that uses a single large fact table to store transactional or measured data, and one or more smaller dimensional tables that store attributes about the data. Continue Reading
-
Definition
10 Jan 2024
MPP database (massively parallel processing database)
An MPP database is a database that is optimized to be processed in parallel for many operations to be performed by many processing units at a time. Continue Reading
-
Definition
27 Jul 2023
ACID (atomicity, consistency, isolation, and durability)
In transaction processing, ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonic device used to refer to the four essential properties a transaction should possess to ensure the integrity and reliability of the data involved in the transaction. Continue Reading
-
Definition
21 Dec 2022
data source name (DSN)
A data source name (DSN) is a data structure containing information about a specific database to which an Open Database Connectivity (ODBC) driver needs to connect. Continue Reading
-
Definition
24 Oct 2022
foreign key
A foreign key is a column or columns of data in one table that refers to the unique data values -- often the primary key data -- in another table. Continue Reading
-
Definition
29 Jun 2022
Data Definition Language (DDL)
Data Definition Language (DDL) is used to create and modify the structure of objects in a database using predefined commands and a specific syntax. Continue Reading
-
News
16 Mar 2022
Oracle Multi-VM Autonomous Database lands on Exadata systems
The tech giant now enables users of the Exadata Cloud at Customer service to run multiple types of the vendor's fully managed and unmanaged databases on the same hardware. Continue Reading
-
News
10 Feb 2022
Oracle Autonomous cloud database gains MongoDB API support
The tech giant continues to build out its multimodel database capabilities with the general availability of a new API for widely used MongoDB applications. Continue Reading
-
Definition
12 Jan 2022
sharding
Sharding is a type of database partitioning that separates large databases into smaller, faster, more easily managed parts. Continue Reading
-
News
13 Jan 2021
Oracle Database 21c brings blockchain and JavaScript
Oracle's flagship DB platform is moving beyond its roots with the 21c update, to embrace more languages and models in a bid to create a universal converged database offering. Continue Reading
-
News
14 Feb 2020
Oracle Data Science efforts advance with new services
Oracle adds news new services to its cloud infrastructure platform in a bid to provide data scientists, as well as data analysts, with data management and query functionality. Continue Reading
-
News
15 Jan 2020
New Oracle Enterprise Manager release advances hybrid cloud
Oracle updates its Enterprise Manager platform to version 13.4, bringing new hybrid management capabilities to database users across on-premises and cloud deployments. Continue Reading
-
Feature
26 Nov 2019
Oracle looks to grow multi-model database features
Decade after decade, Oracle continues to be relevant in the database market as it pivots to include an expanding list of capabilities to serve users, notably cloud. Continue Reading
-
News
16 Sep 2019
New cloud and on-premises options for Oracle Autonomous Database
Oracle introduced new cloud and on-premises deployment options for its namesake database and automated cloud service as Oracle OpenWorld 2019 got underway. Continue Reading
-
Definition
14 Mar 2019
object-oriented database management system (OODBMS)
An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects. Continue Reading
-
Feature
13 Mar 2009
How to use SQL Developer to run SQL statements
In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more. Continue Reading
-
Answer
15 Aug 2007
LOB tables missing with exp/imp move of schema
I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing. Continue Reading
-
Answer
22 May 2007
How to increase SGA_MAX_SIZE in Oracle
How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup. Continue Reading
-
Answer
23 Apr 2007
When will support for Oracle 9i be discontinued?
When will general support for Oracle 9i be discontinued? Continue Reading
-
Tip
14 Aug 2006
Oracle vs. Sybase: 10 reasons to use Sybase on Linux
Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle. Continue Reading
-
Definition
21 Sep 2005
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. Continue Reading
-
Definition
21 Sep 2005
record
In computer data processing, a record is a collection of data items arranged for processing by a program. Continue Reading
-
Answer
16 Aug 2005
Multiple instances on a single database
Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)? Continue Reading
-
Answer
28 Sep 2004
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery? Continue Reading
- Answer 23 Sep 2004
- Answer 25 Jun 2003
- Answer 13 Aug 2002