Sign in or 
This page needs improvement. Help by completing a To-Do. (what's this?What is a To-Do?To-Dos are a tool to help users understand what content is needed on the site. They are created by site members to:• identify content or photos a page needs• ask for help with organization on the page• let others know where they can help on the siteRead more about To-Dos at Wetpaint Central.)
Share this
Acronyms
As is common in the IT world, there are a huge range of acronyms associated to Oracle. In a few regrettable cases the same acronym can mean more than one thing dependent upon context. The table below lists a few. (Note: this list should ideally be sorted alphabetically (or even sortable) if this can be done).
| ACRONYM | MEANING | DESCRIPTION |
| ADF | Application Developer Framework | ADF is a productivity layer for J2EE developers which simplifies application-building as a set of business services with Web, Wireless, and Rich Client interfaces. |
| ASH | Active Session History | ASH consists of session performance view snapshots over time, which are often used to simplify performance tuning. |
| ASM | Automatic Storage Management | The volume manager provided by Oracle for database files such as datafiles, redo logs, backups, controlfiles and spfiles. |
| ASMM | Automatic Shared Memory Management | The collective name for the dynamic memory allocation technologies added in Oracle 9i and improved with each subsequent release. This reduces the amount of manual configuration required. |
| ASO | Advanced Security Option | ASO is an encryption option used to safeguard sensitive data and address regulatory compliance requirements. |
| ASSM | Automatic Segment Space Management | A new way Oracle manages space inside a block. Instead of trying to track the exact space inside a block, Oracle marks the block as one of five types, tracked by a bitmap. This eliminates the need of a freelist. |
| AWR | Automatic Workload Repository | AWR is a built-in repository which persists system workload information to disk at regular intervals. |
| CBO | Cost Based Optimizer | For a given query, the CBO calculates the cost (in system resources) of several possible execution plans and selects the one with the lowest cost. |
| DBA | Data Block Address | Address of an Oracle Datablock for access purposes. |
| DBA | Database Administrator | The person (team) responsible for maintaining the databases. |
| EBS | Oracle E-Business Suite | Oracle's original application suite |
| ESB | Enterprise Service Bus | Standard Acronym. Also name of one of the Oracle 10g ESBs: Oracle ESB |
| ESSO | Oracle Enterprise Single Sign-On Suite | Extends Oracle Identity Management's single sign-on capability to non-web applications. |
| IOT | Index-Organized Table | IOTs are indexed tables whose data is stored as a B*Tree index structure. |
| JDE E1 | JD Edwards EnterpriseOne | ERP system, (software acquired by Oracle in 2005 & corporate acquisition completed May 2008.) |
| OCI | Oracle Call Interface | OCI is a C-language data access API which provides a low-level programmatic interface to the Oracle database. |
| OCCI | Oracle C++ Call Interface | OCCI is an object-oriented data access API for C++ which provides a programmatic interface to the Oracle database. |
| ODCI | Oracle Data Cartridge Interface | ODCI extends the capabilities of the Oracle server by taking advantage of the Oracle Extensibility Architecture framework |
| OID | Oracle Internet Directory | Oracle's LDAP product |
| OEL | Oracle Enterprise Linux | Oracle's Linux distribution |
| OEM | Oracle Enterprise Manager | OEM is a comprehensive management tool which provides a top-to-bottom monitoring solution for Oracle software. |
| OPI | Oracle Programmatic Interface | The server-side complement to OCI. |
| OSES | Oracle Secure Enterprise Search | Secure search access to all of your organization's data sources |
| PGA | Program Global Area | Private memory area for program use |
| RAC | Real Application Clusters | Multiple interconnected computers or servers that appear as if they are one server to end users and applications. See here. |
| RAT | Real Application Testing | RAT is a database option used to capture, analyze, and replay database transactions in order to test workloads or upgrades with minimal effort. |
| SCN | System Change Number | The SCN is a unique, monotonically incremented number used internally by Oracle to provide system-wide versioning for recovery and read consistency purposes. |
| SGA | Shared Global Area | Shared Memory area for Oracle instance structures |
| SID | System IDentifier | Uniquely identifies an Oracle database instance |
| SID | Session Identifier | Identifies an Oracle Session |
| SSA | Self Service Application(s) | Oracle acronym |
| SSO | Single Sign-On | Method of access control that enables a user to authenticate once and gain access to the resources of multiple web software systems |
| SQL | Structured Query Language | The data retrieval and manipulation language of the Oracle database |
| TCA | Touch Count Algorithm | TCA is a buffer-cache management algorithm used by Oracle to maximize cache efficiency. |
| TNS | Transparent Network Substrate | A foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol. |
| TKPROF | Transient Kernel Profile | A utility available in Oracle installations that converts the trace files (generated by session tracing) to a human readable manner, with formatting and sorting. |
| TTC | Two-Task Common | TTC is Oracle's implementation of the OSI presentation layer which provides character set and data type conversion between the client and server. |
| TTI | Two-Task Interface | TTI consists of a network interface to specific server-side functionality. |
| UGA | User Global Area | A memory region in the large pool which is used for user sessions. |
| UPI | User Programmatic Interface | UPI is an undocumented C-language data access API used by Oracle to interface with the Oracle database. |
| SPA | SQL Performance Analyzer | A tool in the Real Application Testing family in Oracle 11g, that allows to replay a specified set of SQLs captured earlier to gauge the impact of some database changes on them. Using SPA, you can accurately predict the impact of index building, database parameter change, etc. on those SQLs. |
| STS | SQL Tuning Set | A group of SQL statements with a given name. STS stores these statements even if they are aged out of the shared pool. STS can be used as an input to SPA or STO. |
| STO | SQL Tuning Optimizer | The tool (inside Oracle Database) that inspects the SQL statements for possible performance improvement. |
| SAA | SQL Access Advisor | The tool inside Oracle Database that analyzes the SQL statement(s) for possible performance enhancemnt. It's little different from STO in the sense that some more recommendations like partitioning are provided here. |
| DG | Data Guard | The overall term or infrastructure for Oracle Standby Database management, both logical and physical. DG has its own command line interface. |
| OPAS | Online Performance Appraisal System | Appraisal Tool used in Self Service e-Biz |
jo.wilson@oracle.com |
Latest page update: made by jo.wilson@oracle.com
, Feb 9 2009, 5:50 AM EST
(about this update
About This Update
mostly used in JAPAC
- jo.wilson@oracle.com
11 words added 3 words deleted view changes - complete history) |
|
Keyword tags:
faq acronym
shortnames
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| MCiortea | Table needs to be sortable | 0 | Oct 17 2007, 8:16 PM EDT by MCiortea | ||
|
Thread started: Oct 17 2007, 8:16 PM EDT
Watch
I have asked Wetpaint to look into that request
|
||||
Showing 1 of 1 threads for this page
