Posts by Babette Turner-Underwood

DBMS_SCHEDULER and Implicit Commits

As usual, Oracle introduces new features, and we read the documentation about how they work and we start using them… but what about what is not in the documentation? That we find out by practice, experience, or accident. And that is exactly what happened to me today.

Babette at UKOUG – day 3

Yesterday I attended Julian Dyke’s session on Inside Rac and had the good fortune to be node 2 in a 4way node cluster. And Julian clearly demonstrated the importance of a good network in RAC, particularly for the internode interconnect.

Babette at UKOUG – day 3 1/2

It’s lunchtime and have attended three excellent sessions today. Jonathan Lewis’s Moving from RBO to CBO, James Morles Storage Internals for the Oracle Architect, and Joze Senegacnik’s Tuning with SQL Profiles. And although it was difficult to get up so early this morning, it was definitely worth it!

Babette at UKOUG – day 2

started the morning with Julian Dyke’s session on library cache. It was quite informative. I just attended both of Tanel Poder’s sessions and he had some very radical Oracle research techniques definite don’t do this at home material.

LOBs Can Break Your Standby

Typically, we monitor the v$datafile to ensure there are no NOLOGGING operations that will break our standby database. So it is important that we confirm that this mechanism actually works. ut for some reason, it is showing nothing under v$datafile for the YESLOG tablespace. I know this operation will break the standby database (because of a break in archive-log activity). I am just not sure how to confirm in the data dictionary.

Page 3 of 41234