Month: May 2011

Instrumentation packages

At CIBER we are doing a series of knowledge sessions where several colleagues are doing a one-hour presentation about one or two package of their choice. We have already heard several very interesting presentations about DBMS_HPROF, DBMS_PARALLEL_EXECUTE, UTL_DBWS, UTL_TCP and DBMS_FGA. And this evening a colleague will do a presentation about DBMS_PREPROCESSOR and DBMS_WARNING, and I will do one

Instrumentation packages

At CIBER we are doing a series of knowledge sessions where several colleagues are doing a one-hour presentation about one or two package of their choice. We have already heard several very interesting presentations about DBMS_HPROF, DBMS_PARALLEL_EXECUTE, UTL_DBWS, UTL_TCP and DBMS_FGA. And this evening a colleague will do a presentation about DBMS_PREPROCESSOR and DBMS_WARNING, and I will do one

Data Guard 11.2.0.2 – update

In March, Oracle MAA has published a white paper for implementing Data Guard on Exadata platforms. (http://www.oracle.com/technetwork/database/features/availability/maa-wp-dr-dbm-130065.pdf) Although the paper is focused on Exadata, some information can be applied to non-Exadata systems as well: Corruption Protection: Primary: DB_BLOCK_CHECKSUM=FULL, DB_BLOCK_CHECKING=FULL, DB_LOST_WRITE_PROTECT=TYPICAL (Physical) Standby: DB_BLOCK_CHECKSUM=FULL, DB_BLOCK_CHECKING=OFF, DB_LOST_WRITE_PROTECT=TYPICAL Network Tuning: TCP Send/Receive Buffers: 3 x Bandwith Delay Product […]

Compression and SE

While researching a corrupt block on 11g SE, we came across a number of objects that were compressed according to the data dictionary.

How could that be?  Compression is not a feature of SE, or so we thought.

The objects in question were all indexes…

Finally on Twitter

Overheard in an IRC chat room (Freenode#oracle) this morning… [24 May 11 09:30] * cheboygan: glad to see that someone read the  blog post though.  at least i know one person read it. [24 May 11 09:30] * rizzo: it got re-tweeted a lot last week [24 May 11 09:30] * rizzo: get yourself on […]

Presentation in ilOUG

I’ll be in Tel Aviv on Wednesday (18/05) to present our last exadata project. Thanks to Israel Oracle User Group for their kind invitation. It would also be a great chance for me to learn their experiences both on exadata and oracle user group activities. For more information : http://www.iloug.org.il/Event_Page.php?EventID=104 Knowledge will increase when it […]

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569