Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
By Franck Pachot . We experienced the first planned outage this week-end, so let’s see how it is notified and what happens. EMEA Commercial 2 – Amsterdam Outage notification before: subject: Announcement: Upcoming Mandatory Maintenance for Oracle Cloud e-mail date: 16 Octobre 2015 1:49 message: Start Time / End Time: Saturday, October 17, 2015 9:00:00 PM CEST – Sunday, October…
By Franck Pachot . A previous blog post explaining what happens for those in ‘Standard Edition One’ had a “don’t worry” in the title because you can upgrade to SE2 with minimal additional cost – except when you have to buy new NUPs – and get only small additional limitation. I didn’t made such a post for people in Standard…
By Franck Pachot . Customers reluctant to go to 12c before 12.2, in addition to Standard Edition contract changes when going to 12c, has lead to lot of upgrades to 11.2.0.4 but what about support? Don’t worry. It’s supported for no additional cost until May 2017 Support levels Do you know why you pay support (per year about 20% of…
The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until SQL Server 2016, DBAs didn’t use often the Maintenance Plan provided by SQL Server for indexes. In fact, those two…
When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c. An interesting way to solve this problem is to create a metric…
Goal We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database. This migration will be executed with Data Pump and transportable tablespace method. We will migrate the tablespace “FOR_TRAVEL” with a table from Windows Oracle 11g database to Linux Oracle 12c PDB Database. On-Premise Database You must…
In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since SQL Server 2014, this estimation has been good! See the PS from Paul Randal’s blog for this information, here But…
By Franck Pachot . In the previous post we have seen how In-Memory Compression Unit map to the physical persistent storage – table extents. Let’s see now how they are mapped to column values, allowing to optimize the scan in a similar way as Exadata Storage Indexes. The examples below will illustrate IMCU pruning and IMCU skip filtering. Here are…
By Franck Pachot . Oracle In-Memory is an hybrid solution: an In-Memory Column Store in addition to the traditional Row Store. In the IMCS, data is stored in IMCU (In-memory compression units) and metadata is in SMU (Snapshot Metadata Units) In the row store, data is stored in datafile extents and metadata is stored in the dictionary (and in datafile…
By Franck Pachot . In the ‘traditional’ row store, the indexes are maintained at the same time as rows are changed. It’s different with the In-memory Column Store. Changes are maintained by background processes. When rows are changed, the Snapshot Metadata Units (SMU) logs the changes and In-Memory Compression Units (IMCU) are re-populated asynchronously. Let’s see an example. test case…
Tuesday, October 6th 2015, I attended to MongoDB Days France in Paris. The presentation was directly organized by MongoDB (10gen). Several presentations have be done to show how to use and deploy MongoDB in real cases. MongoDB is a NoSQL database that provide high availability, data sharding and good performances in specific contexts. The event started with 2 global sessions…
Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB. We will use a SQL Developer to unload data from tables of the CDB_MY_PDP_PREMISE PDB of the on-premises PDB MY_PDB, and to load data into table of…
