René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Keywords


Editing HTML with VIM

Aggregate functions (Oracle SQL)
User defined aggregate functions in Oracle 9i

Analytical function
LAG analytic function in Oracle SQL, lag

Analytical Functions
Analytical Functions in Oracle

Archiver
Oracle Processes

AVI with c#
Writing an AVI file with C#

bash
Path completion in a DOS box under Windows

block address
A transaction in Oracle

buffer cache
buffer busy waits

Checkpoint
Oracle Checkpoint
Oracle's CKPT
Oracle Processes

CKPT
Oracle's CKPT

cmd
Path completion in a DOS box under Windows

Config File
Chameleon: a C++ class that can act as a number and a string

consistent get
A transaction in Oracle

Control Structures
SGA (System Global Area)

cube
Oracle SQL: Group by and CUBE

data block
buffer busy waits

Database Writer
Oracle Processes

dbms_utility
Oracle's analyze

DBWR
Oracle's DBWR

Dispatcher Process
Oracle Processes

Distributed Transaction Recovery
Oracle Processes

Dynamic Views
Oracle's V$ Views

Execute Immediate
Why is dynamic SQL bad
Why is dynamic SQL bad
Execute Immediate

find, recursive
Recursive find and grep with perl

Find::File
Recursive find and grep with perl

foldopen
Folding in vim

for update
Insert while select loop
PL/SQL: Cursor for Update Example

function based index
Create Index in Oracle

glogin.sql
Storing settings for SQL*PLUS (login.sql and glogin.sql)

grep, recursive
Recursive find and grep with perl

Group By
Oracle SQL: Group by and CUBE
Oracle SQL: GROUP BY and ROLLUP

Hints
Oracle SQL hints

inline view
Update of an inline view in Oracle

insert
Oracle SQL: Insert into y returning x

INTERNAL
Oracle's special users: SYS, SYSTEM, INTERNAL and PUBLIC

InteropServices
Importing DLL in .NET

Links
Oracle Links

Log Writer
Oracle Processes

login.sql
Storing settings for SQL*PLUS (login.sql and glogin.sql)

LRM-00109
Creating an Oracle 10g database from the command line only
Creating an Oracle 9i database from the command line only

MessageBeep with C#
Importing DLL in .NET

name spaces for variables
Variables in vim

nomount
SGA (System Global Area)

NULL (in SQL)
NULLs as operands [Oracle SQL]

ODCIAggregateInitialize
User defined aggregate functions in Oracle 9i

ODCIAggregateIterate
User defined aggregate functions in Oracle 9i

ODCIAggregateMerge
User defined aggregate functions in Oracle 9i

ODCIAggregateTerminate
User defined aggregate functions in Oracle 9i

ODCIConst
User defined aggregate functions in Oracle 9i

operator
Chameleon: a C++ class that can act as a number and a string

Optimizer
Oracle SQL hints

ORA-01078
Creating an Oracle 10g database from the command line only
Creating an Oracle 9i database from the command line only

ORA-02096
Alter system in Oracle

Oracle database
Oracle

Oracle instance
Oracle

Oracle server
Oracle

Oracle-managed file
Initialization Parameters, DB_CREATE_FILE_DEST
Initialization Parameters, DB_CREATE_ONLINE_LOG_DEST_n
Creating an Oracle 10g database from the command line only
Creating an Oracle 9i database from the command line only

ORACLE_SID
Creating an Oracle 9i database from the command line only

ORA_NLS33
Globalization in Oracle

Overloading in PL/SQL
Overloading in PL/SQL

parallel server option
Rollback segments [Oracle]

physical structures
Oracle basic things

PL/SQL Procedures
SGA (System Global Area)

PLAN_TABLE
Oracle's explain plan

post-wait drivers
Initialization Parameters

Process Monitor
Oracle Processes

recursive find
Recursive find and grep with perl

returning
Oracle SQL: Insert into y returning x

rollback segments
Initialization Parameters

rollup
Oracle SQL: GROUP BY and ROLLUP

segment header
buffer busy waits

select any dictionary
Initialization Parameters

SET TRANSACTION USE ROLLBACK SEGMENT
Initialization Parameters

Shared Server Process
Oracle Processes

Shared SQL Area
SGA (System Global Area)

socket class
C++ Socket Class for Windows

sql trace
Oracle's TKPROF

SYS
Oracle's special users: SYS, SYSTEM, INTERNAL and PUBLIC

SYSDBA
Oracle's special users: SYS, SYSTEM, INTERNAL and PUBLIC

SYSOPER
Oracle's special users: SYS, SYSTEM, INTERNAL and PUBLIC

SYSTEM
Oracle's special users: SYS, SYSTEM, INTERNAL and PUBLIC

System Monitor
Oracle Processes

Tablespace
Oracle basic things

tkprof
Oracle's TKPROF

TSPITR
Available Options in Oracle

Tuning Oracle
Oracle's TKPROF

undo block
buffer busy waits

undo header
buffer busy waits

Undo Tablespaces
Initialization Parameters

Undocumented Hints
Oracle SQL hints

Update
Update of an inline view in Oracle

UTLXPLAN.SQL
Oracle's explain plan

V$ Tables
Oracle's V$ Views

webserver
A Simple Webserver in C++ for Windows

Zero-width assertions in regular expressions
Searching in VIM

\@
Searching in VIM

__gc
Managed C++