ORACLE

Table of Contents General Versions Sample database Install thick client Rights Optimizing Method

General

Server Instance Schema User

Versions

Overview:

• 2 (1979): First on market
• 6 (1988): PL/SQL, row-level locking
• 7 (1992): Parallel execution, CBO, stored procedures
• 8 (1997): Partitions
• 9 (2001): RAC
• 10 (2003):
• 11 (2007):
• 12 (2013):
• 18 (2018):

Sample database

Story

List:

• | Scott HR
• | comprehensive list

Install thick client

Download thick client from OTN (look for DB client, latest release) Install thick client (2GB), using administrator option. Check settings in registry: HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient, especially:

• NLS_LANG (should be the client-side language)

Put tnsnames.ora in \product\12.2.0\client_1\network\admin

Rights

Give debug rights grant DEBUG CONNECT SESSION to <USERNAME>

Optimizing

Method

Tools:

• look far all queries whose duration exceeds 6s seconds: v$longops view
• track bottleneck using profiler & hierarchical profiler;
• explain plan and SQLTRACE on individual queries