close
Welcome! Wikis are websites that everyone can build together. It's easy!

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 site
Read more about To-Dos at Wetpaint Central.
)

  • Fact check Fact check: add contents about ambiguous acronyms

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
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
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?Performance review???



Latest page update: made by mackelcd , May 8 2008, 2:43 AM EDT (about this update About This Update mackelcd Clarify dates on JDE - mackelcd

8 words added
1 word deleted

view changes
- complete history)
Keyword tags: faq acronym shortnames
More Info: links to this page

Threads

Anonymous  (Get credit for your thread)
Started By Thread Subject Replies Last Post
MCiortea Table needs to be sortable 0 Oct 17 2007, 8:16 PM EDT by MCiortea
MCiortea
Thread started: Oct 17 2007, 8:16 PM EDT  Watch
I have asked Wetpaint to look into that request
4  out of 9 found this valuable. Do you?    
Keyword tags: None