Blog - comments

Hi goog article can we install avdf firewall with flat network if it's possible please let me know ?

First, thank you for your interrest in this blog.Yes, the byte code will be interpreted each time bu...
BIEHLER Stephane
Pretty sure this is wrong:> already said that JVMs interprets the generated byte code - that's true...
Michael, great article, however, I would disagree on DRS/Host Affinity. You are legally only requir...
David Bradshaw
Hi lauri, db_file_multiblock_read_count is still used in exadata smartscan because it defines the si...
Blog dbi bloggers Franck Pachot

Franck's Oracle blog

Blog of Franck Pachot, Consultant at dbi services

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Franck Pachot

Franck Pachot

I'm a Senior Consultant, and Oracle Technology Leader at dbi services (Switzerland).

Certified DBA (OCM 11g, OCP 12c, Performance Tuning Expert, Exadata Implementation) I cover all database areas: architecture, data modeling, database design, tuning, operation, and training.

My preferred area is troubleshooting oracle and performance tuning, especially when I acheive to enable an efficient collaboration between the developers and the operational team.
Besides this blog, I participate in the Oracle Community in forums, blogs, articles and presentation.

All that is referenced from my twitter account:


Do you know why Oracle Database is leading the database market for more than 30 years? Do you know any other software that is still the main solution after decades? It think that it is because Oracle is a good software from the get go. Many early decisions in the software architecture have revealed later how they were the right decision. Several decisions, such as the C language that made it portable to all platforms that were relevant during those 30 years, or the parallel server that has brought RAC when standalone servers were not able to scale anymore. Here I'll illustrate a decision made 15 years ago that has made the whole 12c pluggable databases stuff possible.

Hits: 217
Rate this blog entry:
Continue reading 0 Comments

I have recently published a script to check index fragmentation. But then, do you COALESCE or REBUILD? Well, there also is another option: ALTER INDEX SHRINK SPACE. Let's compare all those index defragmentation operations.

Hits: 221
Rate this blog entry:
Continue reading 0 Comments

When can we use IOT? That's a question I had when giving recently the Oracle DBA essentials workshop. the DBA Essential is very dense and there is only half a day about performance. We have the Oracle Performance Tuning workshop to go into those details. But IOTs are under used in my opinion, so I'll post a use case for them where they are a good idea.

Tagged in: Data modeling Oracle
Hits: 295
Rate this blog entry:
Continue reading 0 Comments

System statistics can be gathered in NOWORKLOAD or WORKLOAD mode. Different values will be set depending on that and the others will be calculated - derived from them. We can see defined values from SYS.AUX_STATS$ but here is a script that shows the calculated ones as well.

Tagged in: Optimizer Oracle
Hits: 345
Rate this blog entry:
Continue reading 2 Comments

At Oracle Open World 2014, or rather the Oaktable World, Chris Antognini has presented 'Indexes: Structure, Splits and Free Space Management Internals'. It's not something new, but it's still something that is not always well understood: how index space is managed, block splits, fragmentation, coalesce and rebuilds. Kyle Hailey has made a video of it available here.
For me, it is the occasion to share the script I use to see if an index is fragmented or not.

Hits: 333
Rate this blog entry:
Continue reading 0 Comments

Oracle's OpenWorld has ended. It was the fist time I attended this great event and it really is a "great" event:

  • 60000 attendees from 145 countries
  • 500 partners or customers in the exhibit hall
  • 400 demos in the DEMOgrounds
  • 2500 sessions
Hits: 465
Rate this blog entry:
Continue reading 0 Comments

This is the session I preferred at Oracle Open World. Well, I'm writing that before going to @ludodba one and I'm sure I'll have then two preferred sessions... So Vit Spinka has presented the internals of the new multitenant architecture. It's always good to play with some internals things. Not only for the geeky fun of it but also because it helps understand how it work and address issues later.

Hits: 301
Rate this blog entry:
Continue reading 0 Comments

I'm currently following the session 'Real-World Performance of Star and Snowflake Schemas' with Michael Hallas, Andrew Holdsworth, John Clarke. It's really a good presentation. the Real Performance team tries to spread messages about how to design for performance. But today I'll not blog about what I've seen but about what I've not seen. Everybody talks about those nice 12c features that are useful in BI workloads, such as adaptive joins, adaptive parallel distribution, vector 'in-memory' aggregation, etc. Nobody talks about Adaptive Bitmap Pruning.

Hits: 296
Rate this blog entry:
Continue reading 0 Comments

Usually, the logical replication of changes uses the primary key. Each row updated or deleted generate a statement to be applied on the target, which affects only one row because it accesses with the primary key. If there is no primary key, we need to have something unique and at worst it is the whole row. But sometimes old applications were designed before being implemented into relational database and have no unicity. It it a problem for logical replication? We will see that Dbvisit replicate can address that.

Hits: 385
Rate this blog entry:
Continue reading 0 Comments

Do you know Delphix? The first time I heard of it was from Jonathan Lewis. And from Kyle Hailey of course. So it's not only about agile and virtualization. It's a real DBA stuff. So as I did yesterday with Dbvisit #repattack let's install the demo.

Hits: 1150
Rate this blog entry:
Continue reading 1 Comment
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter