Blog - comments

Hello. I have a tablespace with 4 datafiles. The name is mail_ts.dbf. It had grown to over 90gb. I ...
Pureprecepts
Hi Franck Pachot, my DBA-Village friend :-)When I try to login to grid I am getting the error su: ca...
Newbie
Its great Article. can you please share a a tsql proc on encryption key management for good backup ...
mpr
Hi Matthieu,No I never used QlikSense so far but I'm pretty sure I will in a near future as it's a q...
Note that the parameter helps to workaround the non-system datafile issue. But the instance still cr...
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.


As an Oracle Ace, I participate in the Oracle Community in forums, blogs, articles and presentation. You can follow my activity on this blog: RSS and my twitter account: @FranckPachot


O_Database12c_Admin_Professional_clrOCE_ODb11gPerfTun_clr11gocm_logoO_ACELogo_clr


 


 


 




I've written about 12c online statistics gathering in a UKOUG OracleScene article. My opinion is clear about it: you sill need to gather stale stats afterwards or you have mising, stale and inconsistent object statistics. This post is about cases where online statistics gathering does not occur (and are not documented) - which is another reason why we can't rely on it.

Tagged in: Oracle 12c
Hits: 180
Rate this blog entry:
0
Continue reading 0 Comments

I'm using Oracle SQL Developer 4.1 Early Adopter for a while and I like it. That version comes with a command line (in beta) which goal is to be fully compatible with sqlplus but running in java, and having a lot more features. 

Becuse it's connecting with thin java driver by default, it doesn't use NLS_LANG. It's java. It's unicode. So here is how to set the language and characterset with the java options.

Tagged in: Java Oracle
Hits: 67
Rate this blog entry:
0
Continue reading 0 Comments

There has been the announce that non-CDB is deprecated, and the reaction that CDB is not yet stable.

Hits: 377
Rate this blog entry:
1
Continue reading 4 Comments

In the previous post we have seen how the OracleText index tables are maintained when new document arrives: At sync the new documents are read up to the available memory and words are inserted in the $I table with their mapping information. Now we will see how removed documents are processed. We will not cover updates as their are just delete + insert.

Tagged in: Oracle
Hits: 114
Rate this blog entry:
0
Continue reading 0 Comments

I plan to write several posts about OracleText indexes, which is a feature that is not used enough in my opinion. It's available in all editions and can index small text or large documents to search by words. When you create an OracleText index, a few tables are created to store the words and the association between those words and the table row that contains the document. I'll start to show how document inserts are processed.

Tagged in: Oracle
Hits: 291
Rate this blog entry:
0
Continue reading 0 Comments

For Exadata, oracle has introduced an 'EXADATA' mode which sets a high transfer rate (with IOTFRSPEED as in NOWORKLOAD statistics) and set a MBRC (as in WORKLOAD statistics). Those values are set rather than gathered because all the SmartScan optimization done at storage cell level, which makes the multiblock reads less expensive, is difficult to measure from the database.
Here I will explain what I stated in a previous blog: direct-path reads are not counted as multiblock reads for the MBRC system statistic. And direct-path read should be the main i/o path in Exadata as you probably bought that machine to benefit from SmartScan.

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

I've not finished with my investigation on 12c multitenant dictionary. Here, I'm checking how metadata links are managed by the dictionary cache (aka rowcache).

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

IOUG Collaborate #C15LV

Posted by on in Operating System & Cluster

The IOUG - Independant Oracle User Group - has a great event each year: the COLLABORATE. This year it's in April 12-16, 2015 at The Mandalay Bay Resort & Casino in Las Vegas.

I'll be a speaker and a RAC Attack Ninja as well.

alt  IOUG COLLABORATE provides all the real-world technical training you need – not sales pitches. The IOUG Forum presents hundreds of educational sessions on Oracle technology, led by the most informed and accomplished Oracle users and experts in the world, bringing more than 5,500 Oracle technology and applications professionals to one venue for Oracle education, customer exchange and networking.         
Tagged in: Oracle Performance RAC
Hits: 187
Rate this blog entry:
0
Continue reading 0 Comments

If you want a statement to be hard parsed on its next execution, you can flush the shared pool, but you don't want all the cursors to be hard parsed. Here is how to flush only one statement, illustrated with the case where it can be useful.
During the performance training, here is how I introduce Adaptive Cursor Sharing, here is how I show the bind variable peeking problem that is well known by everyone that was DBA at the times of 9iR2 upgrades.

Tagged in: Oracle Performances
Hits: 585
Rate this blog entry:
1
Continue reading 3 Comments

This is a question that starts to be raised quite frequently. Oracle released the multitenant architecture 1.5 year ago. And now says that the previous architecture - known as non-CDB - is deprecated. What does it mean? Do we have to go to the CDB architecture even if we dont want to use/pay multi-tenant?

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

Contact

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