Database management, Oracle Variations on 1M rows insert (5): using ‘perf’ 18.05.2015 by Oracle Team By Franck Pachot . In previous post I explained that I’ve observed a 2x CPU usage when running my insert test case in 11.2.0.4 vs. 11.2.0.2 I discussed that with @martinberx @OracleSK @TanelPoder @xtner @Ycolin @fritshoogland @lleturgez @LucaCanaliDB on(…)
Database management, Oracle Variations on 1M rows insert (4): IN MEMORY 18.05.2015 by Oracle Team By Franck Pachot . Oracle In-Memory option is for reporting. Oracle has chosen an hybrid approach: maintain the In-Memory Column Store in addition of the buffer cache. Dont’ forget our In-Memory event, but for the moment, let’s try(…)
Database management, Oracle Matching SQL Plan Directives and queries using it 18.05.2015 by Oracle Team By Franck Pachot . This is another blog post I’m writing while reviewing the presentation I’m doing next week forSOUG and next month for DOAG. You have SQL Plan Directives used by several queries that have same(…)
Database management, Oracle Matching SQL Plan Directives and extended stats 18.05.2015 by Oracle Team By Franck Pachot . This year is the year of migration to 12c. Each Oracle version had its CBO feature that make it challenging. The most famous was the bind variable peeking in 9iR2. Cardinality feedback in 11g also(…)
Database management, Oracle Variations on 1M rows insert (4): APPEND_VALUES 18.05.2015 by Oracle Team By Franck Pachot . In the first variation I did a bulk insert with the PL/SQL FORALL statement. A comment suggests to add the APPEND_VALUES hint that appeared in 11gR2. APPEND_VALUES hint does the same than APPEND but(…)
Database management, Oracle Rebuilt index on increasing values after deletes? 18.05.2015 by Oracle Team By Franck Pachot . Yesterday while giving our Oracle tuning workshop I discussed with the customer about a job they have that rebuilds indexes every Sunday. Except in very rare cases Oracle indexes are maintained so that free(…)
Database management getting started with postgres plus advanced server (4) – setting up the monitoring server 18.05.2015 by Daniel Westermann If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server. Now we will add(…)
Database management When tempdb database may cause indirect issues 18.05.2015 by Microsoft Team A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can’t use his own information I decided to reproduce(…)
Database management Get the main Administration Information from SQL Server with PowerShell 18.05.2015 by Nathan Courtine In my previous blog Get SQL Server services with PowerShell, I presented you the first step of the SQL Server administration through an automated process. This blog is a follow-up of the previous one, and it will focus(…)
Database management Get SQL Server services with PowerShell 18.05.2015 by Nathan Courtine SQL Server Configuration Manager and SQL Server Management Studio are the main tools to administrate the components of SQL Server. They are very convenient to use and pretty complete. But as soon as you wish an automated process, these(…)