amar on web

My writeups on Oracle database

72 Identifying the exact locked record a session is waiting for (06-Sep-08)
71 Easy Connect Naming Method (18-feb-08)
70 Secure Application Roles
69 Drop Database Joke
68 DDL Event Security in Oracle Database
67 Virtual Indexes in Oracle
66 Oracle's SPFILE - Part 2
65 Oracle's SPFILE - Part 1
64 Inserting Custom Messages in Oracle Alert/Trace files
63 Bulk Binds and Collects in PL/SQL - Part - 2
62 Bulk Binds and Collects in PL/SQL - Part - 1
61 Creating NOT NULL Columns in Huge Oracle Tables
60 Oracle Background Processes
59 Oracle's CASE Expression
58 Parsing in Oracle
57 The Mutation error in Oracle Database Triggers
56 Oracle's DBMS_PROFILER: PL/SQL Performance Tuning
55 Sending E-mails from Oracle Database (external link)
54 Oracle Optimizer: Moving to and working with CBO - Part 7
53 Oracle Optimizer: Moving to and working with CBO - Part 6
52 Oracle Optimizer: Moving to and working with CBO - Part 5
51 Oracle Optimizer: Moving to and working with CBO - Part 4
50 Oracle Optimizer: Moving to and working with CBO - Part 3
49 Oracle Optimizer: Moving to and working with CBO - Part 2
48 Oracle Optimizer: Moving to and working with CBO - Part 1
47 Understanding Oracle's Locally Managed Tablespaces
46 Call by Reference Parameters in PL/SQL (The NOCOPY Hint)
45 EXECUTE IMMEDIATE option for Dynamic SQL and PL/SQL
44 Definer and Invoker Rights for stored routines in Oracle
43 Committing in Database triggers
42 Loading huge volume of data into PL/SQL table at one shot (Bulk Collect)
41 Reducing switches between SQL and PL/SQL (Bulk Binds)
40 Autonomous transactions
39 Privileges/roles to connect to database
38 Relation between Pctincrease and Next extent allocation (dictionary managed)
37 Various types of segments
36 Resetting a sequence value
35 Impact of comparing varchar2 to a number value in the WHERE clause of a SELECT
34 Two Phase commit
33 Generating random numbers and strings in Oracle
32 Primary key with non-unique index
31 Aligning output from dbms_output.put_line
30 Minimum extents for a rollback segment
29 Adding DEFAULT and NOT NULL together for a column
28 Rollback segments in Redo log files
27 Undefined precision for a number column
26 Hiding crucial data in tables
25 Sessions Highwater mark
24 Number sizing fallacy
23 Use Oracle's DBMS_APPLICATION_INFO to Prevent Routines from Running Simultaneously
22 Caching an index
21 Working with database links
20 NULL value in NOT IN list
19 Uncommitted data in Redo Logs
18 The truth about DEFAULT values in a table
17 The secret of FOR UPDATE OF clause
16 Allow me to hang and kill your SQL*Plus session
15 How to rename an index?
14 Explicit and implict convertion of datatypes
13 Select takes 10 minutes to retrieve 1 record from a table having 1 record only
12 How to retrieve only unlocked rows
11 Interesting Row numbering
10 BFILE Limitations
9 char(0) and varchar2(0)
8 The cause of ORA-00060 deadlock
7 Indexing methodology in RBO
6 The Golden rankings of RBO
5 Table positioning in from clause, for rule based optimizer...Myth breaking
4 Creating table with null and not null columns
3 Implicit Vs Explicit Cursors
2 Locking Down SQL*Plus Security
1 The other deadlock ORA-4020

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was create on 15-dec-2000 and last updated on 01-feb-2007.
please forward all queries to amar@amar-padhi.com