Infrastructure at your Service

 
Franck Pachot

Oracle lateral inline view, cursor expression and 12c implicit statement result

By | Database management, Oracle | No Comments

By Franck Pachot . I’ll present here 3 ways to run a query for each result of another query. Let’s take an exemple: get all executions plan (select from dbms_xplan.display_cursor) for each of my queries (identified from v$sql). The 90’s way was to run the first query, which generates the second queries into a spool file, and execute that file. Here are easier ways, some of them coming from 12c new features lateral join and…

Read More
Franck Pachot

Oracle 12c: Can we disable logging for DML?

By | Database management, Oracle | No Comments

By Franck Pachot . If we don’t mind about loosing our changes, then can we disable logging for DML? This is a question I’ve heard a lot. Ok, you don’t need to recover your changes but Oracle may want to recover the consistency of its datafiles anyway. And that’s why datafiles blocks changed though the buffer cache always generate redo. But yes, in 12c you can do DML and generate only minimal redo. All DML:…

Read More
Microsoft Team

SQL Server 2014 : sortie du livre “DĂ©velopper et administrer pour la performance”

By | Technology Survey | No Comments

Un billet en cette fin d’annĂ©e qui approche Ă  grand pas pour vous annoncer la sortie prochaine (fin dĂ©cembre 2014) du livre SQL Server 2014 : DĂ©velopper et administrer pour la performance en français et auquel j’ai eu l’immense plaisir de participer avec FrĂ©dĂ©ric Brouard (alias SQLPro – MVP SQL Server), Nicolas Souquet (alias Elsuket – MVP SQL Server) et Christian Soutou. Ce livre est destinĂ© aussi bien aux dĂ©veloppeurs qu’aux administrateurs dĂ©butants ou confirmĂ©s…

Read More
Stephane Biehler

UKOUG 2014 – Middleware Day 3

By | Application integration & Middleware | No Comments

Today, no more sessions on middleware, but a lot of ADF, APEX, developments sessions that looks like really interesting! Unfortunately I can’t attend each one but here are some I selected! The picture that paints a thousand words: Data Visualization (ADF) Duncan Mills (Oracle) In this session Duncan was talking about my favorite topic: data visualization. I am quite used to ADF as I developed an interface for my Capacity Planning project. It was sometimes…

Read More
Grégory Steulet

Taskset: a useful tool to set CPU affinity

By | Application integration & Middleware | No Comments

Today at the #ukoug_tech14 I had the chance to attend to the Christo Kutrovky’s session @kutrovsky (Pythian) about “Measuring Performance in Oracle Solaris & Oracle Linux”. This session aimed to present how to measure system utilization in the Linux and Oracle Solaris operating systems and how to use these information for tuning and capacity planning. During this session we had a very good introduction to a bunch of performance monitoring tools that can be categorized…

Read More
Stephane Biehler

UKOUG 2014 – Middleware Day 2

By | Application integration & Middleware | No Comments

Today the sessions were more “high level” so don’t expect deep information and concrete implementations. Roadmap to Cloud Infrastructure and Service Integration with cloud application foundation and SOA Suite Frances Zhao-Perez and Simone Greib(Oracle) Here Frances was talking about CAF (Cloud Application Foundation) which regroup products like weblogic, coherence and so on. She introduced the Oracle’s strategic investments list for this topic: – #1 Mobile – Fusion Middleware and applications – Continuous availability – Multitenancy…

Read More
Franck Pachot

SQL*Plus COPY Command is back as BRIDGE

By | Database management, Oracle | No Comments

By Franck Pachot . Did you ever use the COPY command in sqlplus? It’s very old, and documentation says : The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8i. The COPY command is likely to be deprecated in a future release. Deprecated? But it is back, with a new name, in the new SQL Developer based SQL*Plus (currently called sdsql in beta) SQL*Plus COPY Documentation is here….

Read More
Stephane Biehler

UKOUG 2014: News on Oracle WebLogic, Fusion Middleware, SOA Suite

By | Application integration & Middleware | No Comments

Today I went to UKOUG 2014 at Liverpool. In this blog, you’ll find the sessions on Oracle WebLogic, Fusion Middleware, SOA Suite, and EDG I attended and a little resumĂ© about it. Administration of SOA Suite – A few tips Jon Petter Hjulstad (SYSCO Middleware) Jon Petter’s general advice was to make the monitoring stronger. You have to be pro-active in your administration of SOA Suite. You have several tools for monitoring SOA such as…

Read More
Grégory Steulet

FIO (Flexible I/O) – a benchmark tool for any operating system

By | Operation systems | No Comments

I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I had the opportunity to discover some interesting commands and tools such as FIO (Flexible I/O). FIO is a workload generator that can be used both for benchmark and stress/hardware verification. FIO has support for 19 different types of I/O engines (sync, mmap, libaio, posixaio,…

Read More
Stéphane Haby

SQL Server tips: how to list orphaned logins

By | Database management | One Comment

I read a lot of about orphaned database users in SQL Server, but I have almost never read about orphaned logins. Many of my customers migrate or remove databases in SQL Server. They forget – not every time but often – to remove the logins and jobs associated with these databases. I have created a script – without any cursors, YES, it is possible – allowing to search all logins who are not “attached” to…

Read More
Oracle Team

Creating Custom reports with BI Publisher

By | Database management | No Comments

BI Publisher offers you the possibility to create your own custom reports, I will describe you how to create a report displaying the tablespace size and used size in a simply way. It is advised to create a specific folder in which we will create our reports, because in case of upgrade you won’t lose your BI reports. In the catalog window, you select create folder: We have to grant permissions to this folder to…

Read More