Managing Database Objects - Glossary

BLOB, Dictionary Cache, hit-ratio

Back to root Glossary
A B C D E F G H I J K  L M N O  P Q R S T U V W X Y Z
A database object is any defined object in a database that is used to store or reference data. Some examples of database objects include tables, views, clusters, sequences, indexes, and synonyms. The table is this hour's focus because it is the primary and simplest form of data storage in a relational database.
Add-on Tuning Pack
One of any number of applets Oracle offers to extend the capabilities of the Oracle Enterprise Manager.
A binary large object (BLOB) is a large piece of data.
Computer Aided Software Design, a process where the implementation details of application systems are partially determined through computerized automation.
A source of possible performance degradation caused by two or more users contending for the same resources.
Data Definition Language
The portion of the SQL language that is used to create and alter the structures that hold the data in thedatabase.
Data Dictionary
A group of tables and views that define the structures in a database.
Data Manipulation Language (DML)
The portion of the SQL language that is used to manipulate the actual data in the database.
Dictionary Cache hit-ratio
This ratio ells you relatively how often Oracle finds data dictionary information in memory as opposed to reading it from disk. The ratio is relative to 1, so a ratio of .95 indicates that 95% of the time Oracle is finding data dictionary information in memory. Higher ratios indicate better performance than lower ones.
When a value is resolved at compile time, it is called early-bound.
Each time you click a glossary term, you will see a window like this displaying the term and its definition. To see the entire glossary, click Show All Terms.
An invalid piece of code is one not capable of being run because of errors in its definition.
When a value is resolved at runtime, it is called late-bound.
National Language Subset
A group of characters that are used to represent a specific national language or dialect.
Oracle interMedia
An option for the Oracle database designed for handling specific types of large data (such as images or spatial data) and text.

The capability to perform some type of database action.
Query Optimizer
A piece of software that selects the optimal way to retrieve data from a selection of possible retrieval paths.
Referential Integrity
The guarantee that a data value in one column refers to an already existing value in another column.
A collection of privileges that can be assigned together.
A structure in an Oracle database that contains database structures, typically owned by the schema owner.