Database management Use a wallet to encrypt Oracle client passwords 17.03.2015 by Nicolas Jardot In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised, we can assume that any password stored in clear text are also compromised. I had(…)
Database management, Oracle 12c: shutdown abort a PDB? 16.03.2015 by Oracle Team By Franck Pachot . Can we shutdown abort a PDB? Let’s try: SQL> show con_id CON_ID ------------------------------ 3SQL> shutdown abort; Pluggable Database closed. But is it really a shutdown abort? The shutdown abort we know in non-CDB – or(…)
Database management, Oracle Index on trunc(date) – do you still need old index? 15.03.2015 by Oracle Team By Franck Pachot . Sometimes we have to index on ( trunc(date) ) because a SQL statement uses predicate on it instead of giving a range from midnight to midnight. When you do that you probably keep the index(…)
Database management ODA 12.1.X.X.X – add a multiplexed control file under ACFS 12.03.2015 by David Hueber Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA(…)
Database management Venturing into bulk insert a SQL Server error log and data order 12.03.2015 by Microsoft Team Have you ever attempted to bulk import a SQL Server error log in order to use the information inside a report for example? If yes, you have probably wondered how to keep data in the correct order in a query(…)
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(…)