Nicôme
Data (State)
Data (State)
Data Base (Dbms)
Data Processing
Data Modeling
Data Quality
Data Structure
Data Type
Data Warehouse
Data Visualization
Data Partition
Data Persistence
Data Concurrency
Data Type
Number
Time
Text
Collection
Relation (Table)
Tree
Key/Value
Graph
Spatial
Color
Measure Levels
Order
Nominal
Discrete
Distance
Ratio
Code
Compiler
Lexical Parser
Grammar
Function
Testing
Debugging
Shipping
Data Type
Versioning
Design Pattern
Web
Html
Dom
Http
Url
Css
Javascript
Selector
Browser
Web Services
System
Operating System
Security
File System
Network
Process (Thread)
Computer
PerfCounter
Search Term
Breadcrumb:
Oracle Company - Edelivery
Advertising
Oracle Company - Edelivery
> Database
> Oracle Database
Table of Contents
1 - About
2 - Articles Related
1 - About
Edelivery
is the ex-Siebel download site.
2 - Articles Related
OBIEE - BI Management Pack
Endeca - Advanced (Content|Text) Enrichment with Lexalytics
Oracle Company
ODI - Endeca Integration (IKM SQL to Endeca Server)
Advertising
db/oracle/edelivery.txt
· Last modified: 2017/09/06 19:28 by
gerardnico
Oracle Database
482 pages
Db:oracle:admin:start
Oracle Company
Oracle - Partitions (Table and Indexes)
Oracle Database - (Logical) Segment (Database Object Storage)
Oracle Database - SQL
Oracle Database - Optimizer Statistics
Oracle Database - Trace File 10053 to understand the Optimizer (CBO)
Oracle Database - Oracle Automatic Storage Management Cluster File System (ACFS)
Oracle Database - ACTIVE_INSTANCE_COUNT parameter
Oracle Database - (Actual|Final) Execution Plan
Oracle Database - Actual (Runtime) Plan Statistics
Oracle Database - Adaptive Optimization
Oracle Database - Adaptive Plan
Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool
Oracle Database - Analytics
Oracle Database - SQL - Analytic Functions
Oracle Database - Mode Archive Log / Archiving
Oracle Database - Archived Redo Log Files
Oracle Database - ARCHIVELOG
Oracle Database - How to change the Database Archiving Mode
Oracle Database - How to know the archivelog mode ?
Oracle Database - The effect of ArraySize on Logical I/O
Oracle Database - ASM (Automatic Storage Management)
Oracle Database - Prepare Storage for Oracle Automatic Storage Management on Linux
Oracle Database - Authentication
Oracle Database - AUTHID
Oracle Database - Automatic reoptimization / (statistics|cardinality) feedback
Oracle Database - AutoTask (Automated maintenance tasks)
Oracle Database - Autotrace
Oracle Database - AWR (Advanced|Automatic) - Workload Repository - Performance Statistics Gathering Tool - DBA_HIST views
Oracle Database - Background Process
Oracle Databse - SQL - between
Oracle Company - BI Strategy
Index - Bitmap
Oracle Database - Blevel Index Statistics
Oracle Database - (Data|Db|Logical|Oracle) Block or Page
Oracle Database - (B|Balanced) Tree - BTree indexes
Oracle Database - Buffer IO (Logical IO)
Oracle Database - Buffer cache
Oracle Database - Buffer Pool
Oracle Database - How can we load a large number of rows into an indexed existing table ?
Oracle Database - Bytes or Characters for VARCHAR2 and CHAR
Oracle Database - bytes sent via SQL*Net to client
Oracle Database - (Memory) Cache (Tables, ...)
Oracle Database - Rows (of Card as Cardinality for 9i)
Oracle Database - Cartesian Joins Operation
Oracle Database - Cascade
Oracle Database - (Consolidated|Root) Database (Cdb)
ORACLE - Streams / Change Data Capture
Oracle Database - How to change the password for the account SYS/SYSTEM ?
Oracle Database - Character Set
Oracle Database - Configure Database Options with the chopt tool
Oracle Database - Client Application
Cluster Scan/Access
Oracle Database - The (index) Clustering Factor Statistics
Oracle Database - cman.ora configuration file
Oracle Database - Column
Oracle Database - COMMIT (of a transaction)
Oracle Database - Compile
Oracle Database - Compression
Oracle database - Concurrency Wait Class
Oracle Database - How to connect SYS as SYSDBA without password
Oracle Database - Connect Descriptor (TNS Connect String)
Oracle Database - Connect Identifier
Oracle Database - Connect String (Client Connection Initiation)
Oracle Database - Oracle Connection Manager
Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)
Oracle Database - Connection Pool
Oracle Database - Read Consistency
Oracle Database - Consistent (Read get|Buffer Mode) (CR)
Oracle Database - (Integrity) Constraints
Oracle Database - (Application) Context
Oracle Database - Control Files
Oracle Database - CPU_COUNT parameter
Oracle Database - Create table as select (CTAS)
Oracle Database - CURRENT_SCHEMA
Oracle Database - CURRENT_USER, SESSION_USER
Oracle Database - Data Dictionary
Oracle Database - Data Files
Oracle Database - Data Load
Oracle Database - Data Pump - (Export|Import) Utilities
Oracle Database - Data Redistribution (Parallel)
Oracle Database - Database
Oracle Database - Oracle Enterprise Manager Database Control (Database Control)
Oracle Database - Database Link
Oracle Database - Database Service
Oracle - DataType
Oracle Database - Character DataType
Oracle Database - Data type Conversion
Oracle Database - Datatype Datetime
Oracle Database - Numeric Datatype
Oracle Database - Data Warehousing
Oracle - Date Datatype
Oracle Database - (Db Block Get|Current Get) Buffer Mode (CU)
Oracle Database - DB_BLOCK_SIZE initialization parameter
Oracle Database - DB_DOMAIN
Oracle Database - DB_FILE_MULTIBLOCK_READ_COUNT Parameter
Oracle Database - 'db file scattered read' wait event
Oracle Database - db file sequential read Wait Event
Oracle Database - DB_NAME
Oracle Database - DB_UNIQUE_NAME parameter
Oracle Database - Database Administrator (Dba)
DBCA
DBMS_APPLICATION_INFO to manage long-running operation
Oracle Database - DBMS_FLASHBACK
Oracle Database - DBMS_LOB Package
Oracle Database - DBMS_LOCK
Oracle Database - DBMS_MONITOR
Dbms_mview Package
Oracle Database - DBMS_SPACE Package
Oracle Database - PL/SQL Package DBMS_XDB
Oracle Database - DBMS_XPLAN
Oracle Database - Database Writer Process (DBWn)
Oracle Database - DDL Locks (data dictionary lock)
Oracle Database - Deadlock
Oracle Database - Dedicated Server Architecture
Oracle Database - Dedicated Server Process
Oracle Database - Dimensions
Oracle Database - Direct (path insert|load) (/*+ APPEND */)
Oracle Database - "direct path read temp" and "direct path read" wait event
Oracle Database - Directory Object
Oracle Database - Directory naming method (LDAP-compliant)
Oracle Database - DISK_ASYNCH_IO parameter
Oracle Database - ASM - Disk group
Oracle database - Dispatcher and Shared Server Process
Oracle Database - Explain Plan from Cursor Cache (DBMS_XPLAN.DISPLAY_CURSOR)
Oracle Database - Distributed Transactions
Oracle Database - DML Lock
Oracle Database - (Degree|Degree of Parallelism (DOP))
Oracle Database - DUAL
Oracle Database - Easy Connect Method with host, port and service name (EZCONNECT)
Oracle Company - Edelivery
Oracle Database - Entreprise Manager
Oracle Database - Environment Variables / Registry Values
Oracle Database 11g: Administration I - 1Z0-052
Oracle Database - Export Utility (exp)
Oracle Database - Data Pump Export (expdp)
Oracle Database - Explain Plan
Oracle Database - EXPLAIN PLAN and Autotrace Comparison
Oracle - Extended Statistics
Oracle Database - (Logical) Extent (Unit of Storage)
Oracle Database - External naming method
Oracle Database - External Tables
Oracle Database - How to load a CLOB field with an external table
Oracle database - File (Common Specification for data file, control file,...)
Oracle Database - File System
Oracle Database - Effect of a filter on a outer join table
Oracle Database - FIRST_ROWS
Oracle Database - SQL - First Value Analytic function
Oracle Database - _FIX_CONTROL Optimizer Parameter
Oracle Database - Flash Cache
Oracle Database - Flashback
Oracle Database - Flashback Query
Oracle Database - Floating-Point Number Datatype (BINARY_FLOAT, BINARY_DOUBLE)
Oracle Database - FOREIGN KEY Constraints
Oracle Database - (Fragmented) (Unused|Free) space (Reclaim|Shrink|resize)
Oracle Database - Full Table Scans
Oracle - Function-based Index
Oracle Database - Gateway (Heterogeneous services)
Oracle Database - Gateway Architecture
Oracle Database - Gateway Data Dictionary
Oracle Database - Gateway - Data Dictionary (from the remote data source) - The Translation Views
Oracle Database - Gateway Log
Oracle Database - Gateway Agent Registration
Oracle Database - Global Database Name (GLOBAL_NAME)
Oracle Database - GLOBAL_NAMES parameter
Glossary
Oracle Database - Golden Gate (OGG)
Oracle Database - Grant
Oracle Database - Granule (Parallel Data Access)
Oracle Database - Grid Control
Oracle Database - Operating System Group
Oracle Database and Hardware
Hash Access / Scan
Oracle Database - HASH AREA memory
Oracle Database - HASH_AREA_SIZE parameter
Oracle Database - Hash joins
Oracle Database - (Level|Height) Index statistics
Oracle Database - High Water Mark (HWM) - boundary between used and unused space
Oracle Database - Data Loading Hint
Oracle Database - Hints
Oracle Database - Histogram Analytic
Oracle Database - How to create a time dimension table in Sql ?
Oracle Database - PLSQL - IF Statement
Oracle Database - Import (imp)
Oracle Database - Data Pump Import (impdp)
Oracle Database - Indexes
Oracle Database - Index Scans
Oracle Database - Index Statistics
Oracle Database - INITRANS parameter
Oracle Database - Insert Statement
Oracle Database - Installation of a database RAC 10g
Oracle Database - Installation of 11gR1/R2 on Windows
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)
Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64)
Oracle Database - 12c Installation on Windows 64 bit
Oracle Database - Installation
Oracle Database - Installation Oracle Database 10gR2 on Windows
Oracle Database - Instance (Database Start-up)
Oracle Database - INSTANCE_NAME parameter
Oracle Database - INTEGER Datatype
Oracle Database - Interconnect Traffic (RAC)
Oracle Database - Internal Locks
Oracle SQL - Interval
Oracle Database - Input/Output (I/O)
Oracle - Java
Oracle - Java/JSERVER - Debug Load / Compilation
Oracle - JSERVER - How to get the Java Version ?
Procedure Stockee Java
Oracle Database - Java Database Connectivity (JDBC) Driver
Oracle Database - Join (Operation|Method|Mechanism|Algorithm)
Oracle Database - Join Order
Oracle Database - SQL - Analytic Function LAG/LEAD
Oracle Database - NLS_LANGUAGE parameter
Oracle Database - Leaf (block|Node) of a Btree index
Oracle Database - Log Writer (lgwr)
Oracle Database - Session (Library|Cursor) Cache
Oracle Database - Like SQL Condition
Oracle Database - Configuration of the Listener (listener.ora)
Oracle Database - Listener
Oracle - LOB Datatype
Oracle Database - Local Naming Method
Oracle Database - Locks
Oracle Database - Locks and Foreign Keys - Concurrency control of parent keys
Oracle Database - Logical Structure
Oracle Database - LogMiner
Oracle Database - Long (Text) and Long Raw Datatype
Oracle Database - LRU
Oracle Database - Materialized view (Snapshot)
Oracle Company - Media Pack (Oracle Edelivery)
Oracle Database - Memory
Oracle Database - MERGE JOIN operation
Oracle OLAP - Methodology for Defining the Analytic Workspace
Oracle Database - Methodology for Designing and Building Materialized Views
Oracle Database SQL - Minus
Oracle Database - Memory manager (MMAN)
Oracle - Monitoring
Oracle Database - Monitoring
Oracle Company - My Oracle Support (MOS)
Oracle Database - Multiblock
Oracle Database - Naming convention
Oracle Database - Naming method (naming resolution method)
Oracle Database - Oracle Net (SQL*Net)
Oracle Database - Oracle Net Manager
Oracle Database - Net Service Alias
Oracle Database - Net Service Name (tnsname)
Oracle Database - Oracle Net Configuration Assistant
Oracle Database - NLS_DATE_FORMAT
Oracle Database - NLS_DATE_LANGUAGE
Oracle Database - NLS_LANG (LOCALE)
Oracle Database - NLS_LENGTH_SEMANTICS parameter
Oracle Database - NLS_NUMERIC_CHARACTERS (decimal separator and thousands separator)
Oracle Database - Globalization (Localization, NLS parameter)
Oracle Database - NLS_SORT (Sorting Character parameter)
Oracle Database - NOARCHIVELOG
Oracle Database - NOLOGGING
Oracle Database - Non-schema Object
Oracle Database - Null value (Missing Value)
Oracle Database - NUMBER Data Type
Oracle Database - Objects
Oracle Database - ODBC
Oracle Database - ODBC Driver Insallation on Linux
Oracle Database - Oracle ODBC driver
Oracle Database - Optimal Flexible Architecture (OFA)
Oracle Database - OPTIMIZER_FEATURES_ENABLE Parameter
Oracle Database - Optimizer Goal (CBO/RBO)
Oracle Database - ORA-01720 - grant option does not exist for 'AnObject'
Oracle Database - Error (Ora-XXXXX)
Oracle Database - ORA_HASH Function
Oracle Database - ORA_NLS
Oracle Database - Oracle Validated Configuration RPM for a Linux Installation
Backup
Oracle Database - Oracle base directory (ORACLE_BASE)
Oracle Database - Character Set Functions : CONVERT, UNISTR
A Common Business Problem : Messages (AQ)
Oracle Database - Auditing
Oracle Database Is Function (IsDate, ...)
Green/Grid Computing
Oracle Database - Oracle Home Directory (ORACLE_HOME|OH)
Oracle Database - ORACLE_HOSTNAME environment variable
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)
Oracle Olap
Oracle Database - ORACLE_SID environment variable
Oracle Database - ORACLE_UNQNAME environment variable
Oracle Database - Datatype difference between VARCHAR2 and CHAR
Oracle Database - How to reconfigure Enterprise Manager Database Control (with Emca)
How to find the version informations of the Database ?
Oracle Database - How to detect read from the temporary tablespace ?
Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)
Oracle Database - oraenv and coraenv script to set Linux environment variable
Oracle Database - Oracle Inventory directory (oraInventory)
Oracle Company - Oracle User Group
Oracle Database - OUI-10044: The selected Oracle Home ...
Oracle Database - Oracle Universal Installer (OUI)
Oracle Database - Package
Oracle Database - Parallel Operations
Oracle Database - PARALLEL_DEGREE_LIMIT
Oracle Database 11g - PARALLEL_DEGREE_POLICY parameter
Oracle Database - Parallel DML
Oracle Database - How to (enable|disable) parallel query and get (degree of parallelism|DOP) ?
Oracle Database - parallel_execution_message_size parameter
Oracle Database - PARALLEL_MAX_SERVERS parameter
Oracle Database - PARALLEL_MIN_PERCENT parameter
Oracle Database - PARALLEL_MIN_SERVERS parameter
Oracle Database - Parallel Execution Monitoring
Oracle Database - Parallel execution with Oracle Partitioning (parallel partition-wise join)
Oracle Database - Parallel execution in an RAC environment
Oracle Database - (Parallel|PX) Server
Oracle Database - PARALLEL_SERVER_TARGET
Oracle Database - PARALLEL_SERVERS_TARGET parameter
Oracle Database - PARALLEL_THREADS_PER_CPU Parameter
Oracle Database - (Initialization|System) Parameters
Oracle Database - Parameter Files
Oracle Database - Partition Exchange for Data Movement / Data Load
Oracle Database - PATH environment Variable
Oracle Database - Pattern matching
Oracle Database - PCTFREE (Percentage Free)
Oracle Database - Pluggable Database (PDB)
Oracle Database - Performance
Oracle Database - Performance statistics (V$ views)
Oracle Database - Process global area (PGA) - Work Area
Oracle Database - PGA_AGGREGATE_TARGET Parameter
Oracle Database - Physical I/O
Oracle Database - Physical Read
Oracle Database - Physical Database Structures (Files)
Oracle Database - (Pivot|Unpivot) Statement
Oracle Database - The Query Plan Estimator
Oracle Database - The Query Plan Generator
Oracle Database - PMON process
Oracle Database - Pooled Server Architecture
Oracle Database - Port Assignement
Oracle Database - Materialized Views (ROLAP) and Cubes (MOLAP) comparison (Pre Compute Operations)
Oracle Database - Execution Plan Predicate
Oracle Database - Primary Key
Oracle Database - private sql area
Oracle Database - Privileges
Oracle Database - Producer / Consumer Model
Oracle Database - User Profile
Oracle Database - Parallel Slaves
Oracle Database - The Query Coordinator (QC)
Oracle - Controlling the Behavior of the Query Optimizer with initialization parameters
Database Oracle - Query Rewrite
Oracle Database - Example of query Tuning (to decrease the logical I/O)
Oracle Database - Oracle Real Application Clusters (RAC)
Oracle Database - SQL - RANK Function
Oracle - RDA (Remote Diagnostic Agent)
Oracle Database - RDF
Oracle Database - Read
Oracle Database - Recovery
Oracle - Recursive Calls
Oracle - Recursive call caused by Hard Parse
Oracle - Recursive call caused by PL/SQL function
Oracle - Recursive calls caused by data modification (triggers, function based index, ...)
Oracle Database - Recursive call caused by space requests
Oracle Database - Recycle Bin (Flashback Drop)
Oracle Database - Why you have still a lot of redo and archive ? The Index side effect.
Oracle Database - Redo Log (Transaction Log Files)
Oracle Database - How to bypass the redo log generation ?
Oracle Database - Redo Size statistics
Oracle Database - SQL - Regular expression
Oracle Database - Resources
Oracle Database - Resource Manager (DBRM)
Oracle Database - Ressource Manager
Oracle Database - Result Set
Oracle Database - Reverse Key Indexes
Oracle Database - Role
Oracle Database - ROLLBACK (undo of a transaction)
Oracle Database - Row Locks (TX)
Oracle Database - SQL - ROW_NUMBER function
Oracle Database - Rowid
Oracle Database - Rowid Scans operation
Oracle Database - Rownum
Oracle Database - Runstats
Oracle Database - Sample SQL Clause for Table Scans/Access
Oracle Database - Sample Schemas
Oracle Database - SAVEPOINT (of a transaction)
Oracle Database - Scheduler Job
Oracle Database - Schema
Oracle Database - Schema Object
Oracle Database - System Change Numbers (SCNs) - Point in time
Oracle Database - Session Data Unit (SDU) parameter
Oracle Database - User, Security
Oracle Database - SELECT_CATALOG_ROLE
Oracle Database - SELECT ... FOR UPDATE statement
Oracle Database - Selectivity
Oracle Database - Sequence
Oracle Database - Server Process
Oracle Database - Server Result Cache
Oracle Database - Service Handler
Oracle Database - Service name
Oracle Database - SERVICE_NAMES parameter
Oracle Database - Service Registration
Oracle Database - Session
Oracle Database - Session Statistics (V$SESSTAT)
Oracle Database - System Global Area - SGA (Shared Memory)
Oracle Database - Shared Pool
Oracle Database - shared server architecture
Oracle Database - Shared sql area
Oracle Database - System Identifier (SID)
Oracle Database - skip_unusable_indexes parameter
Oracle Database - (Software|Installation) Owner (oracle, grid)
Oracle Database - Sort Aggregate Operation
Oracle Database - Sort Area memory
Oracle Database - SORT_AREA_SIZE parameter
Oracle Database - SORT JOIN (or SORT MERGE JOIN)
Oracle Database - sorts (Disk)
Oracle Database - sorts (memory) statistics
Oracle Database - Space (Size)
Oracle Database - Special Characters
Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)
Oracle Database - SQL
Oracle Database - SQL Access Advisor (Summary Advisor)
Oracle Database - SQL*Net roundtrips to from client
Oracle Database - SQL*Net Statistics
Oracle Database - SQL Parallel Execution
Oracle Database - SQL Plan Management
Oracle - SQL_TRACE
Oracle Database - SQL Tuning Advisor
SQL Loader - Lob File
Oracle Database - SQLNET.ORA
Oracle Database - StandBy Database
Oracle Database - Star Transformation
Oracle Database - Automating Shutdown and Startup on Linux
Setting Up Statspack
Oracle Database - Storage Options
Oracle Database - Stored Procedure
Oracle Database - Java Stored Procedure
Oracle Database - PL/SQL - Result Sets from Stored Procedures
Oracle Database - Synonym (Object Alias)
Oracle Database - SYSASM privileges
Oracle Database - sysdate
Oracle Database - SYSDBA privilege
Oracle Database - V$SYSMETRIC
Oracle Database - SYSOPER privilege
Oracle Database - System Lock
Oracle Database - SYSTEM Tablespace
Oracle Database - Table
Oracle Database - Table Function (Pipelined)
Oracle Database - Table Lock (TM)
Oracle Database - Table Size
Oracle Database - TableSpace
Oracle Database - Temporary Datafiles (tempfiles)
Oracle Database 12c - Temporal Validity
Oracle Database - Temporary Tablespace
Oracle Database - Territory (NLS_TERRITORY)
Oracle Database - TIMED_STATISTICS parameter
Oracle Database - TIMESTAMP data type
Oracle - Tkprof
Oracle Database - TNS_ADMIN environement variable
Oracle Database - tnsnames.ora
Oracle Database - TNS Ping Utility
Oracle Database - TO_NUMBER function
Oracle Database - Trace Tool
Oracle Database - Trace File (.trc)
Oracle Database - Transactions
Oracle Database - Transaction table - Interested transaction list (ITL)
Oracle Database - Trigger
Oracle Database - Two-Task Common (TTC) protocol
Oracle Database - LOCAL or TWO_TASK Environment Variable
Oracle Database - UNDO (Rollback Segment)
Oracle Database - Union
Oracle Database - UNIQUE Constraints
Oracle Database - Update
Oracle Database - v$object_usage
Oracle Database - User (Account/Client)
Oracle Database - Userenv (Current Session Informations)
Oracle Database - utl_mail package
Oracle Database - PL/SQL - Using utl_match functions to compare string similarity
Oracle Database - V$SQL
Oracle Database - V$SQL_MONITOR
Oracle Database - V$SQL_PLAN
Oracle Database - V$SQL_PLAN_STATISTICS
Oracle Database - V$SQL_PLAN_STATISTICS_ALL
Oracle Database - V$SQL_WORKAREA
Oracle Database - V$SQLAREA
Oracle Database - V$ table
Oracle Database - Version
Oracle Database - View
Oracle Database - Virtual circuit
Oracle Database - Virtual Column
Oracle Database - Vpd (Virtual Private Database)
Oracle Database - Wait Event
Oracle Database - What are the benefits to define a dimension in Oracle ?
Oracle Database - SQL - With clause
Oracle Database - (Query) Work Area
Oracle Database - WORK_AREA_SIZE_POLICY
Oracle Database - Xml External Table
Oracle Database - Oracle XML DB
Back to top
Advertising