H.Tonguç YILMAZ Blog

nearly for a year now we have been playing hacking games -> http://tinyurl.com/4hfauk

so you know where to find me from now on -> http://tonguc.wordpress.com

In 2007 because of some technical reasons I am moving my Oracle Blog to here http://tonguc.wordpress.com Please dont forget to add my new blog to your rss reader http://reader.google.com

I will move and consolidate my Oracle related posts indexed here http://tonguc.blogspot.com and detailed here http://tonguc.oracleturk.org in several category series like;

- Oracle Expanded Supplied Packages with 10g Series
Like DBMS_APPLICATION_INFO, UTL_COMPRESS, DBMS_DB_VERSION etc.

- Oracle New Dictionary Enhancements with 10g Series
Like V$OSSTAT, V$SYSMETRIC_HISTORY, V$ACTIVE_SESSION_HISTORY etc.

- Oracle Built-in Functions Series
Like VSIZE, GREATEST, EXTRACT, NVL2, COALESCE etc.

- Oracle SQL Extentions Series
Like Analytic SQL, SQL Model Clause, Regular Expressions, Hierarchical Queries(Oracle Trees) etc.

- Oracle Database Concepts Series
Like ACID properties, Transaction Management, Concurrency, Read Consistency, Locking Mechanisms, Redo, Undo(Rollback), Latch, Enqueue etc.

- There are more than one NUMBER and Character Native Type Series
Like Other Character Datatypes, Other Numeric Datatypes, LOB Datatypes, RAW and LONG RAW Datatypes, ROWID and UROWID Datatypes, XML Datatypes, and also Data Conversion

- There are more than one TABLE Type Series
Like Partitioned Tables, Nested Tables, Temporary Tables, Object Tables, External Tables, Index Organized Tables(IOT)

- There are more than one INDEX Type Series
Like Unique and Nonunique Indexes, Composite Indexes, Function-Based Indexes, Reverse Key Indexes, Bitmap Indexes, Bitmap Join Indexes, Domain Indexes and also Indexes and Nulls

- Oracle Best Practices Series
Like Backup and Recovery with Recovery Manager, High Availability with Data Guard and Real Application Clusters, Automatic Manageability Features like Automatic Storage Management(ASM) and Automatic Segment Space Management(ASSM)

- Oracle Business Intelligence and Extraction, Transformation, Loading(ETL) Series
Like Materialized Views, Table Compression, Parallel Execution, OLAP Capabilities, Data Mining

- Oracle Content Management Series
Like XML in Oracle, LOBs, Oracle Text, Oracle Ultra Search, Oracle interMedia, Oracle Spatial

- Oracle Security Series
Like User Resource Limits and Profiles, Privileges and Roles, Fine-Grained Access(FGA) Control

- Oracle Information Integration Series
Like Distributed SQL, Oracle Streams, Oracle Transparent Gateways and Generic Connectivity

All these topics mentioned above which I plan to study during 2007 is very easy to get immediately familiar with by reading this chapter and guide;

Oracle® Database Concepts 10g Release 2 (10.2)
Chapter 1 Introduction to the Oracle Database

Also other important series will be;

- Oracle Linux and Shell Scripting Series
- Oracle Express Edition(XE) and Application Express Series

This migration will take some time and for me it will be really a great opportunity to study Oracle deeper. So this was the last warning and ending for this blog domain, waiting to meet you at the new one http://tonguc.wordpress.com

Best regards,
Tonguç

2006 was a great year for me, hope 2007 will be greater

I wish to have the oppotunities to meet more friends, have more challenging projects, and spend more time with my family and friends..

With the start of this blog on January 2006 I forced myself to study Oracle more than ever and now I am happy with the outcomes after all that hard time. 121 Posts in General and 395 posts in Oracle Category; more than one Oracle post a day during 2006

2007 the blogging stuff will of course continue but because of some technical reasons I am moving to here http://tonguc.wordpress.com dont forget to add me to your rss reader

Also in 2007 I will try to have OCM degree , more Internship support for young software engineers in my company, maybe meeting someone I admire for long time, a book in Turkish discussing how a starter get details of Oracle database concepts and features,maybe also a similar post like this

So this is my last post here, but previous enteries will remain. I wish everyone a healthy, successfull and happy new year

I have given a two day “application express development” education based on the “2 Day Plus Application Express Developer Guide” and a four day “10g sql statements and application tuning” education based on “Oracle® Database Performance Tuning Guide 10g Release 2 (10.2)” Parts I,II and IV, Thomas Kyte’s Expert-One-On-One and Jonathan Lewis’s Practical Oracle and Cost Based Optimizer Fundamentals books. These are internal educations planned by Turkcell Akademi for Turkcell employees and I am choosen as an internal educator some years ago related on Oracle educations.

My comany is the largest company in Turkey with ~30million customers and ~3000 employees. We use Oracle database on Unix systems. It always suprises me how people behave when learning about the feautes I mention in these internal educations. These features are nothing magic or very unknown really, all of them are mentioned in the strating document for Oracle database Concepts Guide which can be accessed freely from http://tahiti.oracle.com. But it seems that people really does not have a need or want to investigate and read these, the standart acuse is everytime-everybody is very stressed and busy, no time for something new which will make their life easier unfortunately.

So these internal educations are a plathform which I meet with lots of different people with different profiles and backgrounds work on Oracle in their daily work life. I show them how to use Application Express and build web based database apllicaitons in minutes, easily. We talk on 10046/10053 sql trace techniques, autotrace and custom tools like Mr.Kyte’s runstats or Mr.Unal’s itrprof. Also new feautes of 10g like Regular Expressions, dbms_errlog, flashback and recyclebin. Some things which are not new but unfortunately needs mentioning like other table and index types rather than heap table and b*tree, analytical functions, merge and insert all statements, pipelined functions, hierarchical sql, plsql bulk operations, xmltype, large object support, oracle text, intermedia and spatial options and even partitioning and materialized views.

Also fundamental things like using otn, tahiti, installing XE in minutes and using for tests during the education, NULL values and their uncertainities with Oracle and of course Transaction and Exception management techniques. And some things different like “Question Authority” from Mr.Kyte and “Google Search Syndrome”.

These educations are not my primary responsibility but I always work hard for the content because after my six years with Turkcell I believe that it is a must that I have to give this extra time to improve the efficiency by showing employees how Oracle can be effectively used. I use Oracle database and tools for the last 8 years, but I feel like a student still when I read a post in Mr.Lewis blog on CBO, Mr.Kyte’s experimentational answers on asktom or Mr.Feuerstein’s poetry like plsql code. This feeling is very special I know.

Turkcell is one of the biggest customer of Oracle world wide and seeing how this inefficiency is becoming as a company culture is my primary motivation in this fight. Two things made me sad during my recent educations; 1) oracle dba and developers are not coming, attendants are coming from operation groups and their primary focus is writing performant reporting sql statements with tricks like exist versus in or hinting. when I start talking on sql trace or analytical functions this is usually percieved as overloading by most of the group members unfortunately 2) a story begins here; Einstein told one of his collegues one day that if he can make the waiteress surving them understand the relativity theorem only with the material on the table they are having lunch, it is a proof than that he understood all. This comment was shared with me because I am not always able to educate people with making things more simple. This is always in my mind, I know simple is always the best. The challenge is how can I make an analytical function or sql model clause subject simple to be educated. I know this is not impossible, for this challenge I use the experimentation technique of Mr.Kyte’s. I give attendants the chance to experiment the features mentioned on XE they installed on Sql*Plus with simple scnerios mostly taken from tahiti documentation set, otn sample code sections or Mr.Daniel’s library psoug. But last time this also didn’t help, I had several hard time in class, this showed me I need extra time to work on some examples of the education.

So what is the moral of this story than; I must confest that my primary concern is not my company’s inefficiency with my collegues’s limited Oracle knowledge degree, it is my own knowledge degree in fact. It is really a great challenge to work on a topic and educate it or write and publish an articale to internet by knowing that it can be accessed and criticised by Mr.Kyte or Mr.Lewis I love this feeling, I love learning, I love sharing. And this is why this blog, internal educations or summer internship programmes are important for me.

After all, I know some of my collegues will read this post and I hope to meet more Oracle dba and developers in the scheduled internal educations for new challenges.

http://ririanproject.com/2006/11/03/22-ways-to-overclok-your-brain/

Reference
http://tkyte.blogspot.com/2006/12/two-interesting-articles.html

Some months ago I was wanted to write an article on our software development trainee programme.

In this article I wanted the help of our trainees and with their comments today the article was published to all Turkcell employees in the weekly internal magazine called HaberCELL.

The whole article can be accessed from below link, and I want to mention two more things ;
1- It is and will be always an honour and joy for me to work with these brilliant young engineers, I want to thank them all for their blief in this process and me.
2- I am sorry that comments of previous years trainees were not in the published article, it was perceived too long to be published I guess.

I hope with the support of the management and the previous trainees who are now an employee of Turkcell this project will enlarge and help lots of Turkish young engineers with their career startup.

http://tonguc.oracleturk.org/wp-content/uploads/2006/12/Staj-Published.zip

http://www.savageclassical.com/music/mp3/sorrowofangels_128.mp3

..
There are two pieces to being successful in my definition. I define successful as;

• Being happy with what you do.
• Doing the best you can at what you do.

How to become better at what you do. For me, the formula was simple:

Help

Help, such a simple word yet it pays back many times, maybe this is a better way to say it:

Participate
..

http://tkyte.blogspot.com/2005/05/success.html

http://www.phenoelit.de/dpl/dpl.html

…
With arms wide open
Under the sunlight
Welcome to this place
I’ll show you everything
With arms wide open
With arms wide open

Well I don’t know if I’m ready
To be the man I have to be
I’ll take a breath, I’ll take her by my side
We stand in awe, we’ve created life

With arms wide open
Under the sunlight
Welcome to this place
I’ll show you everything
With arms wide open
Now everything has changed
I’ll show you love
I’ll show you everything
With arms wide open
…

CREED-With Arms Wide Open