Oracle Fachvokabular
Begriffe und Erklärungen (Oracle Fachvokabular)
Begriffe und Erklärungen (Oracle Fachvokabular)
Fichier Détails
| Cartes-fiches | 300 |
|---|---|
| Langue | English |
| Catégorie | Informatique |
| Niveau | Autres |
| Crée / Actualisé | 23.02.2017 / 23.02.2017 |
| Lien de web |
https://card2brain.ch/box/20170223_oracle_sql
|
| Intégrer |
<iframe src="https://card2brain.ch/box/20170223_oracle_sql/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
|
user process
The process that runs on the client computer or application server and connects to the instance using a server process.
user-process failure
The failure of a single connection to the database.
username
A unique identification to connect to Oracle Database.
VARCHAR2
Datatype used to store variable-length character data.
view
A customized representation of data from one or more tables. Views can be used to present a different perspective of data, to limit the data access, or to hide a complex query.
WHERE
A clause used with SQL statements to limit the number of rows retrieved.
whole-database backup
A database backup that includes all data files and at least one control file.
throughput
The amount of work that an application or the database can perform in a specified amount of time. This is frequently used as a performance measure in systems.
time-zone displacement
The difference between the time zone and UTC (Coordinated Universal Time zone).
TIMESTAMP
Datatype used to storage datetime data with a fraction of seconds, and optional time-zone information.
tnsnames.ora
The name of the physical file that is used to resolve an Oracle Net service name when you are using the local naming resolution method.
tnsping
An Oracle-supplied utility used to test basic connectivity from an Oracle client to an Oracle listener.
tracing
A configuration that records all events that occur on a network, even when an error does not occur. This facility can be established at the client, the middle tier, or the server location.
transaction
A unit of work within a series of SQL statements. A statement begins with the user’s first Data Manipulation Language (DML) statement and ends with a COMMIT or ROLLBACK command. See also Data Manipulation Language (DML).
trigger
A Procedural Language/SQL (PL/SQL) program that is invoked in response to a database event.
two-tier architecture
A network architecture that is characterized by a client computer and a back-end server that communicate using some type of network protocol, such as TCP/IP.
Undo Advisor
A tool within the Oracle advisory framework that uses past undo usage to recommend settings for the UNDO_RETENTION parameter as well as an optimal size for the undo tablespace.
undo data
The data blocks changed or updated, along with pointers to rows inserted that are stored in an undo tablespace to support read consistency, rolling back, and recovery from failed transactions or an instance crash. This is also referred to as rollback information.
undo segment
The segment that stores the before image of modified data. This is used for rollback or transaction-recovery purposes.
undo tablespace
A special type of tablespace that holds undo data. Only one undo tablespace can be active in the database at any given time.
