Database management, Oracle Oracle compression, availability and licensing 06.03.2015 by Oracle Team By Franck Pachot . Various methods of table compression have been introduced at each release. Some require a specific storage system Some requires specific options. Some are only for static data. And it’s not always very clear for the(…)
Database management, Oracle Generic query for multicriteria search – part II: BIND_AWARE (Adaptive Cursor Sharing) 03.03.2015 by Oracle Team 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(…)
Database management, Oracle Generic query for multicriteria search – part I: USE_CONCAT (OR Expansion) 03.03.2015 by Oracle Team 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(…)
Database management, Oracle RAC Attack! next month 12c in Las Vegas 03.03.2015 by Oracle Team 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(…)
Database management, Oracle Query the Enterprise Manager collected metrics 02.03.2015 by Oracle Team 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(…)
Database management, Oracle 12c online statistics gathering and startup restrict 21.02.2015 by Oracle Team 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(…)
Database management, Oracle How to set NLS for SQL Developer 21.02.2015 by Oracle Team 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(…)
Database management, Oracle Is CDB stable after one patchset and two PSU? 16.02.2015 by Oracle Team 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(…)
Database management, Oracle OracleText: deletes and garbage 15.02.2015 by Oracle Team 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(…)
Database management, Oracle OracleText: inserts and fragmentation 15.02.2015 by Oracle Team 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(…)