Nicôme - The Data Blog

Search Term

Breadcrumb:

Oracle Database - Sort Aggregate Operation

Advertising

Oracle Database 480 pages

Db:oracle:admin:start

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

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)

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

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/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

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 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 - Sort Aggregate Operation

> Database > Oracle Database

1 - About

Operation used to calculate an aggregate function such as an avg.

In God we trust, all others must bring data.
W.E. Deming

Advertising

Helping teams, developers, project managers, directors, innovators and clients understand and implement data applications since 2009.

Gerardnico.com is a data software editor and publisher company.

If you are a data lover, if you want to discover our trade secrets, subscribe to our newsletter.

Data (State)
Data (State)
DataBase
Data Processing
Data Quality
Data Structure
Data Type
Data Warehouse
Data Visualization
Data Partition
Data Persistence
Data Concurrency

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Modeling
Process
Logical Data Modeling
Relational Modeling
Dimensional Modeling
Automata

Data Type
Number
Time
Text
Collection
Relation (Table)
Cube
Tree
Key/Value
Graph
Spatial
Color
Log

Measure Levels
Order
Nominal
Discrete
Distance
Ratio

Code
Compiler
Lexical Parser
Grammar
Function
Testing
Debugging
Shipping
Data Type
Versioning
Design Pattern

Infrastructure
Operating System
Security
File System
Network
Process (Thread)
Computer
PerfCounter

Marketing
Advertising
Analytics
Email

Web
Html
Dom
Http
Url
Css
Javascript
Selector
Browser
Web Services
OAuth

Contact
gerardnico
[email protected]
Privacy Policy

Bootie Template designed by Gerardnico with the help of Bootstrap and DokuWiki