Nicôme - The Data Blog
Subscribe
Search Term
Breadcrumb:
Oracle Database - Golden Gate (OGG)
Advertising
Oracle Database
480 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 - Index (indices)
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 - 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
Oracle Database - Golden Gate (OGG)
> Database
> Oracle Database
1 - Documentation/Reference
Oracle GoldenGate Application (Java) Adapter v11.2.1 Example
for
Flume
(into HBase, Hive, HDFS)
In God we
trust
, all others must bring data.
Advertising
