Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

January 29, 2009

OraPub’s Free Technical Papers and Presentations

Filed under: Oracle How To — H.Tonguç Yılmaz @ 5:03 pm

Craig Shallahamer is someone we always listen from Danişment Gazi Ünal, who has written Microstate Response-time Performance Profiling paper at January 2003 and who is one of the most knowledgeable Oracle experts in Türkiye and world I have ever seen.

I saw Mr. Shallahamer’s recent Oracle Server Consolidation presentation, so here are the free publications of OraPub you might want to study.

Annual my favorites updates

Filed under: Oracle Other — H.Tonguç Yılmaz @ 8:40 am

During 2008 there were a lot of new Oracle blogs I tried to follow, nowadays it is so hard to catch up with all the information around us. Within our limited time resource it is very important to choose which blogs is your own favorites.

Until this morning I couldn’t manage to update my favorites, so if you want to take a look here are my favorites as of today.

January 28, 2009

Andrew Barry’s DBA Queries at shutdownabort.com

Filed under: Oracle Other — H.Tonguç Yılmaz @ 9:46 am

I loved the idea behind shutdownabort.com and wanted to share; handy scripts that a DBA may need daily are categorized by subject here, you can find and consume them easily.

Very similar to psoug quick test case idea I strongly believe this kind of a code library is also a basic and important need, after years we all have our own libraries.

So I think this idea can make an important difference for Oracle’s wiki if we all participate?

January 26, 2009

Improvements with 11.1 for the datatypes and table structures supported for asynchronous change data capture option

Filed under: Oracle 11g New Features — H.Tonguç Yılmaz @ 9:25 am

I was studying the Asynchronous Autolog CDC Cookbook, I am working on the S_AUDIT_READ Siebel source table, but the AUDIT_LOG column with CLOB datatype failed during the setup with ORA-31513: unsupported column type specified in change table error on 10.2.

As I found out that this limitation for LOBs is not a problem after 11.1 anymore, I wanted to share this information.

Oracle® Database Data Warehousing Guide 10g Release 2 (10.2)
Chapter 16 Change Data Capture: Datatypes and Table Structures Supported for Asynchronous Change Data Capture

Oracle® Database Data Warehousing Guide 11g Release 1 (11.1)
Chapter 16 Change Data Capture: Datatypes and Table Structures Supported for Asynchronous Change Data Capture

ps: if you are interested in CDC option of Oracle please check this previous post of mine for an introduction and a Hotlog option implementation example.

January 22, 2009

How to give positive feedback as an Oracle customer?

Filed under: Oracle Other — H.Tonguç Yılmaz @ 3:20 pm

Any company who value their profit must be after their customers’ feedbacks. So we as Oracle users, how do we give our feedback about things we experience? This experience can be a bug, an improvement need or a new feature request and after this feedback we need to receive a response back of course. Metalink is the place for official support, if you purchase of course, usually buggy/nasty situations are topics here. So can we say OTN forums, Oracle related blogs are the places to give our valuable feedback to Oracle? Since I believe so, I will be doing this with this post :)

Each individual is unique and as a result during our daily Oracle quests in our environments we all face different, interesting experiences. But think about somebody coming and requesting from you this kind of a feedback one day, you can get nervous or excited I guess, after all those fights what to say now? :)

I am a part of a telco organization who owns one of the most prominent data warehouses among all Oracle data warehouse customers, also a highly loaded Billing/CRM Oracle OLTP database. Within last ~10 years there were very interesting experiences we had as a team, some we could speak out loud and share, some we can not of course, some I can not remember now even they felt very scary and unforgettable once upon a time. So I tried to use my blog to produce this kind of a feedback.

WordPress has a very nice feature, the random post option at the top right menu, by clicking it several times and reviewing my own posts for the last two years within some minutes my list was ready to go.

In this list some items can be not so valid, some can be very interesting I know, but what I try to point out here is in order to come out with a list like this you need to document your daily experience, in a light fashion of course, blogging like a dairy can be very helpful for this kind of a need or “what did I do last year?” kind of a question’s answers.

So now I hope here comes your items, come on don’t be shy and comment, sky can be our limit here who cares right :)

January 21, 2009

Turkish Oracle Community Related Updates

Filed under: Oracle Other — H.Tonguç Yılmaz @ 12:53 pm

Just to prove I am still alive, I wanted to write a post :)

This May our Turkish Oracle Users group forum will be 10 years old. ~1500 memberships and ~5000 messages until now.

I always tried to support OracleTurk since there is a very limited amount of Turkish resources related to Oracle, also CeTurk is another forum I try to support in Turkish. Recently there was an announcement of a new Turkish forum http://oracleforum.info/ which is founded by the members of the local Oracle University team.

Türkiye has young and very talented software engineers, parallel to this fact as far as I can follow the Turkish Oracle Users community is also growing quietly. I am 32 and I feel like a dinosaur within these guys. So here is a small list that you may want to check which consists of Turkish Oracle Bloggers writing in English who are near 25, yes 25 :)

http://husnusensoy.wordpress.com/
http://bhatipoglu.com/
http://ozgurmacit.wordpress.com/
http://erturkdiriksoy.wordpress.com/
http://kamranagayev.wordpress.com/
http://sertaccamci.blogspot.com/
http://emreknlk.blogspot.com/
http://emrebaransel.blogspot.com/
http://afsungur.blogspot.com/
http://merveolamli.wordpress.com/
http://ora-exp.blogspot.com/
http://zengin.wordpress.com/
http://akdora.wordpress.com/

Yasin, Coşkan and Kubilay more popular Turkish bloggers who are older ones like me, near 30 lets say :)

Oracle had always tons of critiques in my country why they can not touch young poeple compared to IBM and Microsoft, so nowadays we may say things are changing and forums/blogs are the main drivers behind this change I guess.

ps: I am looking for anyone who has been ~10 years of Oracle DBA/Developer, liked to play with Oracle and than chose to continue their career in decision making side, to have their comments on this kind of a migration, are they cool or missing the feeling of being a doer?

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 79 other followers