2010-12-28

h

Nu inseamna deloc ca-i ajuti pe oameni daca incerci sa faci intotdeauna pentru ei ceea ce ar putea face si ei insisi.

2010-12-21

how to export to csv an oracle table

The original  script can be found here : http://www.oracle-base.com/dba/miscellaneous/csv.sql

learn db2 by oracle concepts

http://www.ibm.com/developerworks/data/library/techarticle/dm-0401gupta/

ORA-00060: Deadlock detected

In an OLTP environment, when you encounter this error check if you have bitmap indexes on you transactional tables.

This type of index may be a cause for ORA-60 .See also : http://www.oratechinfo.co.uk/deadlocks.html

2010-12-20

'row cache lock' Causing Slowness On 11.2 Databases

Many Processes Waits Too Short For 'row cache lock' Causing Slowness On 11.2 Databases [ID 1162566.1]


problems with new feature in 11g : failed login delay

In Oracle Database 11G there is a new 'feature' related to hacking prevention:
Logon Delays:
A hacker may attempt a brute force hack to break into your Oracle Database. In this case they try constant logons to the database using some form of a word list. Oracle 11g includes a logon delay that takes effect after the third failed password entry attempt. This makes the brute force hacking more difficult. After the third failed logon attempt, Oracle will incrementally delay subsequent logon or password prompts up to a maximum of 10 seconds. No delay will occur if the logon is successful.

BUT there is a problem/bug , until OracleDatabase version 11.2.0.2  ( or 11.1.0.7.5 - not yet released ) . You can encounter this bug and experience high library cache contention , when you have both users connecting with good passwords and users connecting with bad passwords :

RMAN compressed backups contain corrupted blocks

RMAN compressed backups contain corrupted blocks for non-standard block sizes [ID 1273902.1]


2010-12-15

Oracle Database 11g - Architecture Diagram

http://jhdba.wordpress.com/2010/12/15/oracle-database-11g-interactive-quick-reference/

2010-12-14

kxtotolc_lobopt

ORA-00600 [kxtotolc_lobopt] When Getting An Explain For a Statement With Bind Variables (Doc ID 1050592.1)

2010-12-13

PARALLEL_MAX_SERVERS

 Default value Derived from the values of CPU_COUNT, PARALLEL_THREADS_PER_CPU, and PGA_AGGREGATE_TARGET

2010-12-10

how to authentificate oracle users in active directory

Configuring Oracle Advanced Security Option (ASO) with Microsoft Windows Server 2003 Active Directory Kerberos KDC (Doc ID 331252.1)

 

How to create OracleContext in Microsoft Active Directory

Creating an OracleContext in Microsoft Windows 2003 Active Directory [ID 361192.1]


 

2010-12-08

kksfbc child completion

Database Hung With "kksfbc child completion" and "Cursor: Pin X" Waits (Doc ID 430555.1)