How to append to datasets in Toad Intelligence Central

In the previous installment of this series we looked at four reasons from gv$sql_shared_cursor view and explained the situations and criteria for which Oracle is forced to compile a new execution plan...

Yesterday evening I received an email titled 'Invitation to Developer Champion Program'. What a surprise! The Oracle Developer Champion program was setup just a year ago and is aimed at people who ar...

Introduction Before Oracle 12.1.0.1, whenever a table partition was dropped all the global indexes that were created on that table became UNUSABLE unless we specified the clause UPDATE INDEXES in the ...