Hi, I discovered the powerful, not officially documented, hint OPT_ESTIMATE about 12 years ago. Recently I discovered the following officiel document about it: Oracle Support Document 2402821.1 (How To Use Optimizer Hints To Specify Cardinality For Join Operation) My question: is...

Hello, I'd like to write a query based on dba_source/all_identifiers/all_dependencies to find all the queries/cursors that have more than x joins involved. Can you help me ? Regards Hans

Hi, Could you please have a look at below table structure drop table child purge / drop table parent purge / create table parent (id number(11,0) ,dt date ,constraint pk_parent primary key (id) ) partition by range (dt) ( partition

Hi Tom, In one of the interview, interviewer asked me about the scenario where bitmap index is useful in OLTP system. and I was totally clueless..... I wasn't able to think any of the scenario. Later I googled every possible combination to get some info about the scenario. But di...

I would like to know your advice about migrating a database from WE8ISO8859P15 to AL32UTF8. We have a DB running WE8ISO8859P15 properly with a lot of applications, but a client suggests that it would be a good idea to change it so it is the same in their Java applications. These ...