Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    The Hint OPT_ESTIMATE is 20 years old: can we use it now ?

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Identify cursors/query with more than x joins involved

    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
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Drop Foreign Key from Referenced-Partitioned Child table

    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
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Bitmap index and OLTP

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Sergiusz Wolicki

    Migration from WE8ISO8859P15 to AL32UTF8

    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 ...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more