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(…)
Database management, Oracle Never gather WORKLOAD stats on Exadata… 09.02.2015 by Oracle Team 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(…)
Database management, Oracle Oracle multitenant dictionary: rowcache 08.02.2015 by Oracle Team By Franck Pachot . I’ve not finished with my investigation on 12c multitenant dictionary. Here, I’m checking how metadata links are managed by the dictionary cache (aka rowcache). As I did previously, I’ll create a metadata link function(…)
Operating systems, Oracle IOUG Collaborate #C15LV 03.02.2015 by Oracle Team By Franck Pachot . The IOUG – Independant Oracle User Group – has a great event each year: the COLLABORATE. This year it’s in April 12-16, 2015 at The Mandalay Bay Resort & Casino in Las Vegas. I’ll be(…)
Database management, Oracle Flush one SQL statement to hard parse it again 29.01.2015 by Oracle Team By Franck Pachot . If you want a statement to be hard parsed on its next execution, you can flush the shared pool, but you don’t want all the cursors to be hard parsed. Here is how to flush(…)
Database management, Oracle Stay with non-CDB or go to CDB? 28.01.2015 by Oracle Team By Franck Pachot . This is a question that starts to be raised quite frequently. Oracle released the multitenant architecture 1.5 year ago. And now says that the previous architecture – known as non-CDB – is deprecated. What does(…)
Database management, Oracle When to gather workload system statistics? 23.01.2015 by Oracle Team By Franck Pachot . This month we started to give our Oracle Tuning Workshop. And with a new workshop comes new questions. We advise to give to the optimizer the most accurate statsistics that we can have. That(…)