Oracle Abbreviations and terminology

Term definitions
Active Session Pool resource group or sub-plan number of currently active sessions allowed
ADDM Automatic Database Diagnostic Monitor (automatic DB diagnostic monitoring
Program
ASM Automatic Storage Management (Automatic storage Management)
ASM Automatic Summary Management (Automatic profile Management)
ASMM Automatic Shared Memory Management (automatic management of sharing RAM)
ASSM Automatic Segment Space Management (automatic segment space management)
ATO Automatic Tuning Optimizer (automatic optimization optimizer)
Automated PGA Memory management a feature of the Oracle database to simplify and improve the PGA memory allocation
Way
A feature of automatic management of shared-memory Oracle databases that automates the management of Oracle DB instances to
The most important shared memory structure to use
Automated storage Management A mechanism for providing vertical integration of file systems and volume managers, which is
Created specifically for Oracle database files
Automated Database Diagnostics Management A utility that performs instance analysis, identification problems, and possible from top to bottom
The reasons for these problems and suggested cases to fix them
Automatic optimization optimizer a database feature for performing various analyses of SQL performance in a database
An automated workload repository an infrastructure that collects, processes, and maintains data for detection issues and automated optimization
Performance statistics of the data
Databases used by secondary databases when creating duplicate databases or performing table space Point-in-time restores
AWR Automatic Workload Repository (automatic workload data archive)
Backup fragments are separate files that are part of the backup set
A copy of one or more data or archived log files for a backup set. It is not associated with a copy of the image
Same as not storing empty blocks
Block change tracking a feature that uses the change tracking write process (CTWR) background process to record a single
The physical location of all database changes in the state file
Damage to block corrupted data block. Corrupted data block refers to the use of an unrecognized Oracle
Block of the format, or its contents are internally inconsistent
Block media restores a recovery method that reduces the minimum amount of media recovery from the data file to the block
Recovery Unit
BMR Blocks Media Recovery (Block media recovery)
Buffer cache a memory region used to cache chunks of data retrieved from a database
CFS Cluster file Storage (cluster files storage)
Change trace file a file that stores the database changes made since the last backup
Physical location
Link or connection of the channel to the target database
CLI command-line interpreter (command line interpreter)
A group of one or more tables that share the same block of data in a cluster
Oracle Database 10g: DB Management-classroom exercise I E-3
Term definitions
CMAN Oracle Connection Manager. It plays the network communication firewall and the proxy service
The role of the service device
A file that contains information about the physical structure of a database, including all
Location of data and redo log files
CRS Cluster Ready Services (Cluster readiness service)
The smallest unit of physical storage in the data block database. Data blocks contain data rows, indexes
Information, etc.
Data dictionary cache a memory area in a shared pool for storing Dictionary object definitions in memory
Data files that contain database data
Database character set scanner a utility for evaluating the porting of an Oracle database to a new database word
The feasibility of descriptor
DBA database Administrator (DB Administrator)
DBA data block address, which uniquely identifies a database
The data block in
DBCA Database Configuration Assistant
Dbverify an external command-line utility for performing physical data on an offline database
Structural integrity Check
The DDL data definition Language (data definitions language). is to define and manipulate the number
The SQL statement class for the library object
DML Data Manipulation Language (manipulation language). is to query and
SQL statement class for vertical data
EM Enterprise Manager
Emctl Oracle Enterprise Manager Control. is used to start, stop
Database Control, Oracle Agent, and Oracle Management Server
And check the status of the utility program
Coded character set a character set used to map a numeric code to a computer or terminal to display
and receive the characters
Oracle Enterprise
Manager Database
Control console
Graphical interface for managing the database
EXTPROC External code base
FGA fine-grained Auditing (fine-grained audit)
FGAC fine-grained access control (fine-grained access controls)
A unified storage location for all recovery-related files and activities in the Oracle database in the fast recovery zone
The flash back buffer memory stores the extents of the Flashback database data
Flashback database A new recovery method that uses restore data instead of redo data to recover
Database
Flashback deletes a feature that restores the effect of a DROP TABLE statement without having to
Use traditional point-in-time recovery
Flashback Table A command to recover a table and all its related objects from the Recycle Bin
Oracle Database 10g: DB Management-classroom exercise I E-4
Term definitions
Flashback transaction Query A diagnostic tool that can be used to view what is done to the database at the level of transaction processing
The changes
Flashback version Query a query syntax that provides a history of changes made to a row,
and the corresponding identifier for the transaction that made the change
A character literal used to describe a datetime format or number stored in a string.
Word Data format
Growth Trend Reporting Database segment growth analysis
Globalization supports a feature set to ensure utilities and error messages, sort order, letters,
Calendar, date, time, currency, and data are automatically adapted to the local language
Copy of the image copy identical to the original database file
Prototype a standalone version of the physical database. Data when opened with the Resetlogs option
The library prototype will change, but as long as the necessary redo is available, you can start from an earlier
The prototype recovery backup
Tables organized by index a database structure that has the appearance of a table but is stored in the B*tree structure
Its data
Init.ora or
Init<sid>.ora
The initial control of how the DB instance is configured at startup and how it is run
Parameter file. Also known as "parameter file"
The collection of shared memory and processes used by the instance to access the Oracle database
IPC Internal Process Communication (internal process communication)
Isqlplusctl Control Utility for starting and stopping the Isql*plus listener process
ISV Independent Software Vendor (Independent software vendor)
The area of memory in the Java pool SGA, used in all Java Virtual Machine (JVM)-specific
Java code and data for a session
JDBC Java Database Connectivity (Java DB connection)
JNNN the job queue process. Perform a scheduled job
Reserve buffer cache memory area in the SGA for long-time caching of data in the buffer cache
Language and Character set file scanning
Program
Statistics-based utility for determining the language of unknown file literals and
Character
Optional memory store for large pools to buffer large I/O requests
Lcsscan language and Character set file scanners
LEGATO
®
NetWorker,
Single Server version
Oracle Database 10g comes with software that makes recovery Manager practical
Program can write data to the tape drive
The memory area in the library cache shared pool, which contains a full analysis of PL/SQL blocks and statements
or compile notation
Language sort a function that produces a sort sequence, whose sequence matches the alphabetical order of the characters
Not match the numeric value in the character encoding scheme
Listeners all non-local users connected to the Oracle instance Gateway
Locale information collection for language and culture preferences for a specific region
Locale variable language-dependent region definition
Oracle Database 10g: DB Management-classroom exercise I E-5
Term definitions
LSSV LEGATO
®
NetWorker, Single server version
Media Management Library interface used by Rman when writing data to tape or reading data from tape
Memory guides a feature of Oracle Enterprise Manager to help optimize the memory structure
The size
Memory Manager (Mman) a database daemon that is used as the SGA memory mediator and can adjust the memory group
The size of the pieces
Measure metrics for a database or instance attribute
MML Media Management Library (Media management Gallery)
Mmon the management watcher process. This process will emit a preset when the metric exceeds its threshold value.
And captures the statistics of the most recently modified SQL object
The national language supports a number of parameters and files that determine the database client and database server
Locale-specific behavior
NK block Size buffer The area of memory in the SGA, which caches data different from the default database block size
Block. Used to support removable table spaces
NLS National Language supports (country language support)
The NLS Runtime Library is a comprehensive suite of language-independent features that can be correctly used for text and characters
Handling and language routine manipulation
Nls_lang environment variables used to specify the language, region, and character set used by the database
NLSRTL National Language support Runtime Library (Country language
Row library)
NMP Named Pipes (Named pipes)
oc4j Oracle application Server Containers for EE
OMF Oracle Managed Files
The optimizer statistics describe the statistics of the database and the objects in the database, and the query optimizer will make
Use these statistics to select the best execution plan for each SQL statement
OUI Oracle Universal Installer
Oracle Locale Builder is a feature that provides a graphical user interface that allows you to
To view, modify, and define region-specific data
Oracle Managed Files Oracle database feature for managing the number of Oracle in a disk private zone
Creation, naming, and deletion of library files
Oracle Net one interface for Oracle Database 10g with the client or middle tier should be
Establish network connections between programs
Oracle Shared Server A database server configuration that enables many user processes to share a small amount of service
process, minimizing the number of server processes and maximizing
Increase utilization of available system resources
Oracle_base for environment variables that point to the OFA structure Foundation
Oracle_home environment variables used to identify directories that contain Oracle software
ORACLE_SID environment variables used to specify the default DB instance name
Oracle Database 10g: DB Management-classroom exercise I E-6
Term definitions
A collection of package logic-related procedures and function definitions. Procedures and functions are provided by the package body
Implement
Parallelization refers to the allocation of multiple channels for Rman backup and recovery operations
PGA Program Global Zone
The PGA guides Oracle Enterprise Manager with a feature that provides detailed workspace
Statistical data, and provides a global area of the program based on workload characteristics
Recommended for best use of memory (PGA)
Pipeline a memory area in which a process is used to pass information to other processes
The memory area in the dedicated SQL Zone PGA, which contains the binding information and the run-time memory structure
Class of data
Permission to execute a specific type of SQL statement. There are two basic types of permissions:
Imaging and Systems
Proactive tablespace monitoring a feature of Oracle Database 10g to manage disk space for table spaces
Use case
The private memory area used by the program global Zone process
Recovery Catalog holds a stand-alone database of historical data about backup activity
Recovery Manager Oracle Utility for backing up and recovering database files
Recycle Bin a data dictionary table that maintains the original name of the deleted object and its system
The relationship between the names generated by the
Loop buffer cache memory area in the SGA to hold fast aging data in the buffer cache
Redo log buffer A memory area where the redo information can be written to disk until it is cached in the
Area in
Redo log file resizing
Guidance
A feature of Oracle Enterprise Manager that can provide redo log files
Sizing recommendations
A feature of the Resource Manager Oracle database enables the Oracle database server to
Control of resource management decisions, thus avoiding the inefficiencies in operating system management
The problem of health
Recoverable space allocation a suspended and later execution of a large number in the event of a space allocation failure
How the library operates
RMAN Recovery Manager
RMAN repository A storage structure for maintaining metadata about database backup and recovery operations
Scheduler a new database feature that enables database administrators and application developers
Can control the time and location of multiple tasks in the database environment
SCN System Change number (System changes)
Section guides a guide to monitoring object space issues and analyzing growth trends
Segment Resource estimation program new segment resource estimation function to estimate the amount of resources needed to create a new segment
Server process for connecting to the target database called by the server session client utility
(UNIX) or thread (Windows nt/2000)
Oracle Database 10g: DB Management-classroom exercise I E-7
Term definitions
Memory allocated in the session memory PGA for saving session variables and sessions related
Other information
SGA system Global Zone. Memory area shared by all servers and background processes
The SGA guides a guide to advising on parameter settings related to the SGA
Shared Pool A memory area used to cache various structures that can be shared between users
Shrink guide See section guidance
The SID system identifier. The default is the database name, which uniquely identifies the given service
instance on the device
SQL Structured Query Language (Structured Query language)
SQL Access guidance A tool for determining the best data access paths (such as indexing and manifested
Usage of the view)
SQL Optimization Guidance a tool to provide tuning recommendations for SQL statements
Statspack a set of SQL, PL, and sql*plus scripts that can be used for collection, automatic
Process, store, and view performance data. This feature has been updated by automatic workload data
Replaced by archives
Streams Pool The optional memory area in the SGA used by Oracle Streams
System statistics Some statistical data used to describe the hardware characteristics of the system to the query optimizer.
such as I/O and CPU performance and utilization
Logical grouping of tablespace data files
Target database The database you are trying to connect to
Threshold values that are compared with the thresholds measure
Restore a feature that directs Oracle Enterprise Manager to provide parameter value recommendations
Additional amount of space required to support flashback at a given time
Restores the original copy of the data that was stored when the DML transaction changed the data. Restores
Data is used for fallback transactions and provides read-consistent views of change data
A user global share pool or memory area in a large pool that contains an Oracle shared server
Session information for a conversation
UTC Universal Time coordinates (universal temporal coordinates). is the unified audit line
Global timestamp for Noose
VPD Virtual Private Database
A statistic that waits for an event to be incremented by a server process or thread to indicate that the process must first
Wait for an event to complete before proceeding with processing
Dedicated memory allocations in the workspace PGA for sorting, hashing joins, and other memory
Intensive operations
Workload Data archive See AWR

Oracle Abbreviations and terminology