My Oracle Articles
|
1
|
The other deadlock ORA-4020
|
Go
|
|
2
|
Preventing user access to data from SQL*Plus
|
Go
|
|
3
|
Implicit Vs Explicit Cursors
|
Go
|
|
4
|
Creating table with null and not null columns
|
Go
|
|
5
|
Table positioning in from clause, for rule based optimizer...Myth breaking
|
Go
|
|
6
|
The Golden rankings of RBO
|
Go
|
|
7
|
Indexing methodology in RBO
|
Go
|
|
8
|
The cause of ORA-00060 deadlock
|
Go
|
|
9
|
char(0) and varchar2(0)
|
Go
|
|
10
|
BFILE Limitations
|
Go
|
|
11
|
Interesting Row numbering
|
Go
|
|
12
|
How to retrieve only unlocked rows
|
Go
|
|
13
|
Select takes 10 minutes to retrieve 1 record from a table having 1 record only
|
Go
|
|
14
|
Explicit and implict convertion of datatypes
|
Go
|
|
15
|
How to rename an index?
|
Go
|
|
16
|
Allow me to hang and kill your SQL*Plus session
|
Go
|
|
17
|
The secret of FOR UPDATE OF clause
|
Go
|
|
18
|
The truth about DEFAULT values in a table
|
Go
|
|
19
|
Uncommitted data in Redo Logs
|
Go
|
|
20
|
The code that never was
|
Go
|
|
21
|
Working with database links
|
Go
|
|
22
|
Caching an index
|
Go
|
|
23
|
Preventing two routines from running simultaneously
|
Go
|
|
24
|
Number sizing fallacy
|
Go
|
|
25
|
Sessions Highwater mark
|
Go
|
|
26
|
Hiding crucial data in tables
|
Go
|
|
27
|
Undefined precision for a number column
|
Go
|
|
28
|
Rollback segments in Redo log files
|
Go
|
|
29
|
Adding DEFAULT and NOT NULL together for a column
|
Go
|
|
30
|
Minimum extents for a rollback segment
|
Go
|
|
31
|
Aligning output from dbms_output.put_line
|
Go
|
|
32
|
Primary key with non-unique index
|
Go
|
|
33
|
Random numbering
|
Go
|
|
34
|
Two Phase commit
|
Go
|
|
35
|
Impact of comparing varchar2 to a number value in the WHERE clause of a SELECT
|
Go
|
|
36
|
Resetting a sequence value
|
Go
|
|
37
|
Various types of segments
|
Go
|
|
38
|
Relation between Pctincrease and Next extent allocation (dictionary managed)
|
Go
|
|
39
|
Privileges/roles to connect to database
|
Go
|
|
40
|
Autonomous transactions
|
Go
|
|
41
|
Reducing switches between SQL and PL/SQL (Bulk Binds)
|
Go
|
|
42
|
Loading huge volume of data into PL/SQL table at one shot (Bulk Collect)
|
Go
|
|
43
|
Committing in Database triggers
|
Go
|
|
44
|
Definer and Invoker Rights for stored routines in the database (AUTHID)
|
Go
|
|
45
|
Execute Immediate
|
Go
|
|
46
|
Call by Reference parameters in PL/SQL (NOCOPY Hint)
|
Go
|
|
47
|
Understanding Locally Managed Tablespaces
|
Go
|
|
48
|
Oracle Optimizer: Moving to and working with CBO - Part 1
|
Go
|
|
49
|
Oracle Optimizer: Moving to and working with CBO - Part 2
|
Go
|
|
50
|
Oracle Optimizer: Moving to and working with CBO - Part 3
|
Go
|
|
51
|
Oracle Optimizer: Moving to and working with CBO - Part 4
|
Go
|
|
52
|
Oracle Optimizer: Moving to and working with CBO - Part 5
|
Go
|
