DB-Nemec
zlog - lazy blog (don’t expect very
fresh stuff here)
|
|
6.3.2008
|
Oracle
11g new features (A.Nanda)
|
|
29.9.2007
|
Library
Cache Internals – Julian Dyke
|
|
3.3.2007
|
SQL model
clause
|
|
|
data mining,
Zachman's architecture
|
|
19.2.2007
|
Using XSQL
Servlet <xsql:include-xml> with XMLElement and XMLAgg
|
|
|
Materialized View Refresh - truncate
/ delete problem
refresh
|
|
|
Generating XML Schema , get the XML
out of your database
|
|
28.7.2006
|
Mark Rittman on partition exchange loading using OWB (PEL)
|
|
5.4.2006
|
http://oraclesponge.blogspot.com/
|
|
5.4.2006
|
Data Integration Forum
|
|
5.4.2006
|
BPEL
and Java on The Serveside
|
|
5.4.2006
|
Hibernate
remote
lazy loading
|
|
5.4.2006
|
Jonathan Lewis on Partitioned
Tables and Partitioned View
|
|
11.3.2006
|
designing_applications_for_performance_and_scalability
Oracle White Paper
Topics covered:
• Generally how applications can be designed to minimize overhead.
• How scalability of repeated execution of the same SQL statements
can be achieved.
• How data can be batched to minimize network utilization.
• A number of the often-used application programming interfaces, and
how these expose the performance and scalability features.
|
|
26.2.2006
|
Most popular Tech Sessions Oracle OpenWorld
SF 2005
|
|
6.2.2006
|
"Are
your statistics bad enough?". My presentation on UKOUG 2005
you must enter network to get through…
See the mirror version here
|
|
14.1.2006
|
Miracle A/S, Denmark White Paper
Efficient use of
bind variables, cursor_sharing and related cursor parameters
|
|
14.1.2006
|
Oracle White Paper Understanding
Shared Pool Memory Structures
|
|
4.12.2005
|
DML Error Logging feature in Oracle 10gR2 http://www.rittman.net/archives/001388.html
|
|
23.11.2005
|
ODTUG
papers
|
|
17.7.2005
|
Automatic tuning of MBRC
|
|
12.7.2005
|
Oracle 10g r2
Part 1-SQL and PL/SQL Features
http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part1.html
Part
2-Manageability Features
http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part2.html |
|
14.6.2005
|
BPEL and Java on TheServerSide |
|
28.5.2005
|
There could be a big difference between CBO mode FIRST_ROWS (uses heuristic approach) and FIRST_ROWS_n (strict cost based). See examples how FIRST_ROWS_n works |
|
26.5.2005
|
How to analyze a "CTX indexes" - see discussion on oracle-l |
|
8.3.2005
|
Snapshot compare with DBMS_RECTIFIER_DIFF.DIFFERENCES (google it) |
|
|
generating rows from dual using CONNECT BY |
|
26.2.2005
|
find all roles and privs http://www.petefinnigan.com/find_all_privs.sql |
|
26.12.2004
|
OWB PARIS : EARLY REVIEW |
|
11.12.2004
|
How to transform a table in a partitioned table without copy (2x space required). Arup Nanda presents split-split method similar stuff is here or here |
|
5.12.2004
|
Table function and model clause for generation of data http://technology.amis.nl/blog/index.php?p=266 http://www.rittman.net/archives/000923.html |
|
5.12.2004
|
OWB self service education http://www.oracle.com/technology/products/warehouse/selfserv_edu/self_service_education.html |
|
5.12.2004
|
OLAP Catalog http://www.rittman.net/archives/001145.html |
|
5.12.2004
|
Arup Nanda paper on partitioning http://download.oracle.com/owsf_2003/36605_nanda.doc |
|
5.12.2004
|
Oracle Open world presentations for download Some downloads from Open World 2003 |
|
28.11.2004
|
Perform explain plan for statements without rights to execute those statements |
|
26.10.2004
|
Wolfgang Breitling What is new in the Oracle 9i CBO init.ora parameter changed, changes to explain plan, new access paths, new cost model, system statistics, peeking bind variables, new columns in V$SQLAREA and V$SQL, join V$SQL_PLAN and V$SQL_PLAN_STATISTICS, dynamic sampling, view on V$SQL_PLAN to achieve PLAN_TABLE compatibility References: Metalink notes: 62337.1 Optimizer Features Enabled, 149560.1 System Statistics, 153761.1 Scaling the System to Improve the CBO Optimizer A Look under the Hood of CBO: The 10053 Event and other papers Oracle9i Database Performance Tuning Guide and Reference |
|
18.10.2004
|
Oracle Magazine 3/2004 Customer Data Hub The Linux Administrator’s Wisdom Kit Linux File Commands JMX Automatic Storage Management Flash Back DBMS_SQLTUNE HTML DB |
|
18.10.2004
|
How to find a string in a file in directory tree find start_path -type f -name 'file_name' -exec grep -i search_string {} \; -print |
|
18.10.2004
|
ETL and DW Gartner Magic Quadrat |
|
18.10.2004
|
Oracle Magazine 4/2004 10g Wait Interface BPEL ENABLE ROW MOVEMENT |
|
18.10.2004
|
Oracle Magazine 5/2004 Beta Books Oracle Text (stemming, query log, SCORE(N)) XML DB DBMS_MONITOR BPEL Moving Data (transportable TBS, data pump, TBS pulling) In Memory Collection how to grant on V$view |
|
17.10.2004
|
Oracle Magazine 2/2004 OTN middleware Data Pump Compressing Data Cleaning Up PL/SQL Practices DOWNLOAD PL/SQL tools www.stevenfeuerstein.com/puter/gencentral.htm www.Swyg.com www.ounit.com SQL Profiling Virtual Private Database |
|
9.10.2004
|
Real Time Data Warehousing – dbazine.com paper by M.Rittman |
|
9.10.2004
|
How Much Does an Update Cost? by J.Lewis |
|
9.10.2004
|
Meta Data Business Rules & Semantics & Data Redundancy |
|
8.8.2004
|
Comparing Informatica and OWB |
|
28.7.2004
|
J.Morle Scaling Oracle 8i – free to download |
|
23.7.2004
|
Freedom and order in PL/SQL – white paper on theme “should I receive an error if the data that are possible not needed for a query are wrong”. See also to_number thread on oracle-l follow up one and two by C.Date respectively by D.Tow |
|
01.07.2004
|
Oracle 10g – case insensitive comparison alter session set nls_comp=ansi; alter session set nls_sort=binary_ci; |
|
01.07.2004
|
Hint /*+ cardinality(t 10 ) */ and optimizer_dynamic_sampling on Ask Tom |
|
27.6.2004
|
OTN: XSQL in JDeveloper
|
|
25.6.2004
|
Metadata model – a paper
from Bill Inmon BI network
|
|
25.6.2004
|
Data
Integration Pattern on TheServerSide
(registration required)
|
|
25.6.2004
|
Jonathan Lewis
on OTN: Understanding
System Statitics
|
|
25.6.2004
|
MDA Books –
see also OMG MDA Reading
Room
|
|
19.6.2004
|
Release note
on V$SQL_PLAN
|
|
19.6.2004
|
Jonathan Lewis
comments on database
independence: "works badly everywhere"
|
|
16.6.2004
|
Understanding
System Statistics - Jonathan Lewis paper on new age of CBO
|
|
09.06.2004
|
To HINT or not
to HINT – the discussion in oracle-L .... (see here)
|
|
09.06.2004
|
New latch
paper on orapub
|
|
23.6.2003
|
MDA books
 MDA Explained: The Model Driven
Architecture--Practice and Promise
 Model Driven Architecture:
Applying MDA to Enterprise Computing
 Mda Distilled: Principles of
Model-Driven Architecture (ADDISON-WESLEY OBJECT TECHNOLOGY SERIES)
|
|
|
Select table history using VERSIONS in Oracle 10g – Arup Nanda, Oracle Doku |
