Tag: Oracle

OLTP type 64 compression and ‘enq: TX – allocate ITL entry’ on Exadata

Recently we’ve seen a strange problem with the deadlocks at the client database on Exadata, Oracle version 11.2.0.4 . Wait events analysis showed that sessions were waiting for “enq: TX – allocate ITL entry” event. It was strange because there…

Read More >

Performance Issues with the Sequence NEXTVAL Call

Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn’t expect a sequence select to be a significant problem but recently we saw that it was—and in two different ways….

Read More >

ORA-28043: Invalid Bind Credentials for DB-OID Connection

Have you ever encountered this error connecting to a DB using global authentication against OID? Was re-registration a temporary workaround, but the issue came back after some time? Check out this solution for ORA-28043: invalid bind credentials for DB-OID connection….

Read More >

Join Us For a Networking Event at UKOUG

Ask not what you can do for your data. Ask what your data can do for you! Join us for an informal networking event alongside Rittman Mead on Monday December 8th during UKOUG. We will be discussing how to leverage…

Read More >

What Does “Backup Restore Throttle Speed” Wait Mean?

After migrating a 10g database to 11g, I asked the Application team to start their tests in order to validate that everything was working as expected. I decided to keep an eye on OEM’s Top Activity page while they were…

Read More >

Pythian at UKOUG 14

UKOUG Blog Graphic

Will you be joining us at the UKOUG Conference and Exhibition in Liverpool, UK? Over 200 world-class speakers and industry experts will be in attendance, including some of our very own. Michael Abbey, Oracle ACE and Team Lead at Pythian notes…

Read More >

New leafmisscount Option in Flex Cluster 12c

In the Oracle RAC previous version we have worked with the option “misscount” of crsctl, which applies for all the servers because there was only one kind of servers, but in the new version of Oracle (12c) we have a new kind of…

Read More >

The Power of the Oracle Database Proxy Authenticated Connections

We recently received this inquiry from a client: “Can an Oracle database account support two passwords at once so we can roll out updated credentials to application servers gradually rather than having to change them all at the same time?…

Read More >

High System Time on Windows Running in a VM

Recently I’ve seen an issue with CPU usage on a server running Windows 2003 Server in a VMware. This is a small Virtual Machine with just 2 cores allocated (which are possibly mapped to “threads” on a host level but…

Read More >

An Introduction to Extended Data Types in Oracle 12c

One of the lesser known new features that comes as a boon to many developers and DBAs is the provision of implicit handling of large data strings using scalar data types like VARCHAR2 and RAW. When creating tables, each column…

Read More >
Page 4 of 141« First Page...23456...10...Last Page »