Infrastructure at your Service

DBA Archives - Page 3 of 5 - Blog dbi services

Nicolas Jardot

UKOUG Tech13 “Super Sunday”: dbi services is here!

By | Technology Survey | No Comments

Today was the first day of UKOUG Tech13: 4 days about Oracle Technology. This year, 7 streams started today (3 last years). I also had a slot to give my presentation about the Optimizer behavior in 12c. The day started with a little delay in registration: My collagues Pierre and Philippe were not correctly registered and didn’t get their badge right away, but everything was solved before the start of the sessions. Speaker time I…

 
Read More
Grégory Steulet

Oracle Database 12c new features: segregation of duties with new administrative roles

By | Database management | No Comments

Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.

Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data Guard status or to administrate some features of Oracle Transparent Data Encryption. Starting with this new Oracle release it is not anymore the case. We can grant limited administrative privileges to operate an Oracle 12c database.

 
Read More
Jérôme Witt

Wie kann ich Indexes und Daten mittels Data Pump trennen?

By | Database management | No Comments

Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies möchte ich anhand eines ganz normalen Datapump-Export–Files verdeutlichen. In folgendem Beispiel handelt es sich um einen einfachen Schema-Export, der wie folgt erzeugt wurde: oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/ [DB112] cat expdp_SalesApp.par SCHEMAS=sh DIRECTORY=data_pump_dir DUMPFILE=expdp_SH_2013-02-17.dmp LOGFILE=expdp_SH_2013-02-17.log PARALLEL=4 oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/…

 
Read More
Jérôme Witt

OOW Day 4: Dive in, Rock out – Oracle Party & Tomy Kyte’s 12 things on Oracle 12c

By | Technology Survey | No Comments

Well, this last day really was funny! We met some old friends (they will recognize themselves) and also Oracle guru Jonathan Lewis. We must confess Larry Ellison really has good friends. His America’s cup boat is really amazing (see picture below) as was last night’s party. Today, we were really tired and the speakers too. Most of today’s content was a review of what Pierre and I reported during the week. It fits exactly Tom…

 
Read More
Pierre Sicot

OOW Day 2: Enjoying Oracle’s Real World Performance show

By | Technology Survey | One Comment

I have had the pleasure to go the Real World Performance presentation with the famous Tom Kyte of the Ask Tom blog, Andrew Holdsworth, Head of Oracle’s Real World Performance Team, and Graham Wood, the legendary Oracle Database performance architect. This was not a session but more a show like in a theater! Each of them had a precise role, DBA, chief of development team, system administrator, and Enterprise Manager Cloud 12c showing us in…

 
Read More
Open source Team

PostgreSQL: Un aperçu des outils d’administration

By | Database management | No Comments

Nous avons dans les articles précédents vu comment installer PostgreSQL et quels étaient les composants d’une base. Nous abordons maintenant le point de l’action
sur le moteur avec deux outils orientés administration de la base, généralement utilisés par les DBAs. Il s’agit de psql et de PgAdmin. Nous aborderons aussi dans cet article la configuration de connexion au travers des fichiers de configuration du serveur.

 
Read More
Open source Team

PostgreSQL : Qu’ai-je installé, Où sont mes données ?

By | Technology Survey | One Comment

Dans mon dernier article sur PostgreSQL, j’ai présenté l’installation du logiciel en explorant les 2 solutions suivantes, l’installation Debian et l’installation EntrepriseDB. Ces deux installations créent immédiatement un cluster de base de données, Debian nous imposant le point de stockage et EntrepriseDB nous proposant de saisir une destination. Je vous propose maintenant d’explorer ce qui a été installé sur votre disque à la mise en route de ce cluster de base et d’analyser les différences entre les deux installations.

 
Read More
Stéphane Haby

Stéph@TechEd 2012: Episode 1 – the Pre-Conf. Seminar

By | Technology Survey | No Comments

This morning, I was very happy to go to my first TechEd. Between the 10 seminars, as I said yesterday, I started with SQL Server 2008R2/2012 performance, tuning and optimization session. The thing is that we had just one session for the whole day. I will not copy the presentation of the 2 speakers (Thomas LaRock and Denny Cherry) who presented remarkably this session despite the failure of air conditioning during the morning. Fortunately, it…

 
Read More
Stéphane Haby

SQL Server 2012: Feature Pack

By | Database Administration & Monitoring | 2 Comments

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are available but are not the final version. I have compiled all information in this blog to find it easily.

All DBA should know that Feature Pack exists, how to find it and of course use it.Wink

 
Read More