All articles

ODA 12.1.X.X.X – add a multiplexed control file under ACFS

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(…)

Venturing into bulk insert a SQL Server error log and data order

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(…)

Analyzing easily the blocked process report

Which DBA has not yet face a performance problem issued by several blocked processes? In reality, I’m sure a very little number of them. Troubleshooting a blocked issue scenario is not always easy and may require to use some useful(…)

Oracle compression, availability and licensing

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(…)

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(…)