Oracle

Generic query for multicriteria search – part II: BIND_AWARE (Adaptive Cursor Sharing)

By Franck Pachot . In the previous post I explained the performance issue encountered when using a generic query to deal with optional search criteria on multiple columns. The statement was shared by all executions, was marked as(…)

Generic query for multicriteria search – part I: USE_CONCAT (OR Expansion)

By Franck Pachot . You have a multicriteria search screen on the EMPLOYEE table where you can enter an employee id, a department id, a manager id or a job id. Either you put the value you want to(…)

RAC Attack! next month 12c in Las Vegas

By Franck Pachot . RAC is the most complex installation you can have for an oracle database. A RAC DBA is involved not only on database, but storage, network, and system as well. It involves also(…)

Query the Enterprise Manager collected metrics

By Franck Pachot . Enterprise Manager (Cloud Control for example) gathers a lot of metrics. You can display them from the GUI, but you can also query the SYSMAN views directly. Today, I wanted to get the history of(…)

12c online statistics gathering and startup restrict

By Franck Pachot . I’ve written about 12c online statistics gathering in a UKOUG OracleScene article. My opinion is clear about it: you sill need to gather stale stats afterwards or you have mising, stale and inconsistent object(…)

How to set NLS for SQL Developer

By Franck Pachot . I’m using Oracle SQL Developer 4.1 Early Adopter for a while and I like it. That version comes with a command line (in beta) which goal is to be fully compatible with sqlplus but(…)

Is CDB stable after one patchset and two PSU?

By Franck Pachot . There has been the announce that non-CDB is deprecated, and the reaction that CDB is not yet stable. Well. Let’s talk about the major issue I’ve encountered. Multitenant is there for consolidation. What is the major(…)

OracleText: deletes and garbage

By Franck Pachot . In the previous post we have seen how the OracleText index tables are maintained when new document arrives: At sync the new documents are read up to the available memory and words are inserted(…)

OracleText: inserts and fragmentation

By Franck Pachot . I plan to write several posts about OracleText indexes, which is a feature that is not used enough in my opinion. It’s available in all editions and can index small text or large documents to(…)

Never gather WORKLOAD stats on Exadata…

By Franck Pachot . For Exadata, oracle has introduced an ‘EXADATA’ mode which sets a high transfer rate (with IOTFRSPEED as in NOWORKLOAD statistics) and set a MBRC (as in WORKLOAD statistics). Those values are set rather than gathered(…)