COLLABORATE 08: Technology and Applications Forum for the Oracle Community
Denver, Colorado, April 13 - 17, 2008
COLLABORATE 08 will be an event like you’ve never seen before. Celebrating our third year, the Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest) have combined resources and ideas to bring you a global event in one location.
This event will deliver the same exceptional content that has become the standard for which the COLLABORATE conferences are known. Featuring the OAUG Forum, COLLABORATE 08 will bring you the best practices and user-driven training that the OAUG […]

[Read more →]

Just putting into words what I understand about how Oracle database handles the reading and writing of data.
Did some brain storming in a hope that it will be useful to somebody.
Reading in Oracle is completely handled by Server processes.
All instruction (reading or writing) from client’s processes first goes to server process.
Reading the Data

The server process first checks the buffer cache for the presence of data.
If not found then only copy the data from datafile to buffer cache.
Then send the data to the client.

DML operations
INSERT
A space is found in the block in the buffer cache and data is inserted into […]

[Read more →]

Scenario From Oracle Forum
I have a transaction table consists of duplicate records I success to write a sql
which get the duplicate records but unable to write the delete statement to delete
this record.
The sql query is as follows:
Select invoice_no, slip_no, drug_code
from transaction_detail
having count(*)>1
group by invoice_no, slip_no, drug_code
If anyone knows please let me know the delete statement. Thanks in advance.
Regards
This is what I think
DELETE transaction_detail td1
WHERE EXISTS ( select ‘x’ FROM
(Select MIN(invoice_no) invoice_no, MIN(slip_no) slip_no, MIN(drug_code) drug_code, MIN(rowid) t_rowid
from transaction_detail
having count(*)>1
group by invoice_no, slip_no, drug_code) td2
WHERE td1.invoice_no = td2.invoice_no
AND td1.slip_no = td2.slip_no
AND td1.drug_code = td2.drug_code
AND td1.rowid td2.t_rowid);
Check out following url for […]

[Read more →]

Oracle Audit Vault: Now it is more secure than ever before. Previously, skilled DBAs can view  or alter the data and can remove their footprints. By introducing one-way “lockbox”, once audit trail in , no one can do any change/alteration. It can be only view. One more thing about this is implemented using encryption techniques. Whoever will try to tamper can easily trashed the attempts.
Hot patching: This one the new feature in Oracle 11g which allows to apply updates to the running databse without shutting it down.
 More detail check: http://www.oracle.com/technology/oramag/oracle/07-sep/o57field.html 

Bookmark this post

[…]

[Read more →]

As per my experience when working with PL/SQL code, DBMS_OUTPUT is one of the most frequently used package to display debugging information.
But frequently when using 10G R1 and earlier versions, we come across something like as follows:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
Single line limit of 255 bytes exceeded.
ORA-20000: ORU-10027: buffer overflow, limit of bytes
Maximum amount of 1 million bytes per session exceeded.
10G R2 increases the single length line limit to 32,767 bytes and the overall session limit is removed altogether.
Note: Now myself and my team use our own procedure called LOGIT for debugging, I will […]

[Read more →]

Check out following:
SQL> select * from test;
COL1
———-
1
1
1
1
1
SQL> alter table test add constraint test_idx primary key(col1) disable;
Table altered.
SQL> create index test_idx on test(col1);
Index created.
SQL> alter table test enable novalidate constraint test_idx;
Table altered.
SQL> insert into test values(1);
insert into test values(1)
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.TEST_IDX) violated

Bookmark […]

[Read more →]

Oracle Database 11g on Windows is now available to download from OTN.

Bookmark this post

Hide Effect.BlindUp(’obsocialbookmark_bar143′);

[Read more →]

The Australian Oracle User Group (AUSOUG) and the Oracle Applications Users Group (OAUG) invite you to attend the Oracle with 20:20 Foresight National Conference Series 2007. This year’s conference series brings together the largest agenda of Oracle related presentations in Australia for 2007, if not the largest ever in Australia, by both independent speakers and Oracle’s own key staff.

Bookmark this post

[…]

[Read more →]

Recently at my client place I implemented RMAN script for maintenance of backups through RMAN, so that my team don’t have to use GUI to do the same.
When running the script everthing was smooth, except at the end of the script result was showing error ORA-19569 as follows:
RMAN> run
2> {
3> allocate channel c1 device type disk format ‘F:\rmanbackup\incrementalbackup\%d_DB_%u_%s_%p’;
4> delete archivelog until time ’sysdate-7′;
5> delete noprompt obsolete;
6> }
7>
using target database controlfile instead of recovery catalog
allocated channel: c1
channel c1: sid=202 devtype=DISK
deleted archive log
archive log filename=D:\ARCHIVE\BIZWIZ\ARC67474_0566156678.001 recid=106781 stamp=635438642
Deleted 2 objects
RMAN retention policy will be applied to the command
RMAN retention policy is set to […]

[Read more →]

In this blog entry let me introduce you to a new capability in Oracle 10g called Block Change Tracking, which can help DBA’s do faster incremental backups via RMAN (Recovery Manager).
Once this new capability in Oracle 10g is enabled it start recording the modified since last backup and stores the log of it in a block change tracking file.
Later while doing backup RMAN uses this file to determine which blocks are needed to be backed up?
Logically as we can see, this process improves the performance as RMAN does not have to scan whole datafile to detect which block in it […]

[Read more →]