2 Day Oracle Index Internals Seminer with Richard Foote

July 15th, 2008

Richard will be in Istanbul this November and he announced this to the group, below is his announcement;

2008/7/4 <richard.foote@…>:

Hi All

Tonguc Yilmaz has kindly invited me to announce to you all that I’ll be visiting your wonderful country on 13-14 November to present my “Oracle Index Internals” Seminar in Istanbul as part of Oracle University’s Celebrity Seminar Series.

You can now book a place here: http://tinyurl.com/5ypj2e

It’s basically 2 very very packed days on anything and everything to do with Oracle indexes, that covers how Oracle actually implements it’s various index structures such as B-Tree, Bitmap, itmap-Join, Partitioned, Reverse, Index Organized Tables, Secondary Indexes on IOT, Invisible, Virtual, Function-Based, Linguistic and Compressed indexes in lot’s of detail.

It’s also covers how the Cost Based Optimizer uses and costs indexes, how one determines when an index should (or should not) be used, what are all the various index related access paths, how does one troubleshoot problematic index related issues, with lots of tips and tricks to get the most out of your indexes.

It of course also discusses how the various index structures should be maintained, when one should rebuild or coalesce or shrink an index, what are the differences between the strategies, when and how do indexes become fragmented, how does one detect problematic indexes and lot’s lot’s more.

You can visit here for a general outline of the seminar: http://richardfoote.wordpress.com/oracle-index-internals-seminar/

For lot’s of information and useful tips on Oracle indexes, you can also visit my Blog: http://richardfoote.wordpress.com/

If you have any questions, don’t hesitate to ask.

Hopefully, I’ll get the opportunity to meet a lot of you in Istanbul in November !!

Regards
Richard Foote

Oracle 10g AWR-ADDM-ASH modülleri mimari Graham Wood Türkiye’de :)

April 15th, 2008

Merhaba,

Günümüz modern Oracle veritabanı iyileştirme yöntemlerinin mimari olan Wood Oracle Türkiye’nin katkıları ile 21 Nisan Pazartesi aksam 19:00′da, Istanbul Maslak Park Orman’da bizlerle sohbet ediyor olacak. Onu dinlemek yaninda Oracle kullanıcıları Developer ve DBA ler olarak beklentilerimizi de birinci agizdan iletmek için de iyi bir firsat olacak bu :)

Katılım ilk 100 kişi ile sınırlandırılacaktır, dolayısı ile ücretsiz seminere katılım için bu uygulamadan kayıt yaptirabilirsiniz: http://apex.oracle.com/pls/otn/f?p=12680:2 Teyit geri dönüşü için e-posta adresinizi belirtmenizi rica ediyoruz. Sunumlar 19:30 gibi başlayacak, 19:00 itibari ile yemekli sohbet bölümü olacak.

Graham Wood is an architect in the database development group at Oracle. Most of his 20 years at Oracle has been spent in performance related areas, including designing and tuning large high-performance systems, building monitoring tools such as Statspack, and in architecting performance and scalability features into the database itself. Most recently Graham has worked as part of the Oracle Manageability team tasked with simplifying the process of tuning the operation of the database which resulted in the development of AWR, ASH and ADDM to provide automatic tuning. Graham has presented at Oracle and third party conferences around the world primarily on topics of Oracle database design and performance.

10g AWR-ADDM-ASH modullerine giriş;

http://www.oracle.com/technology/pub/articles/10gdba/week6_10gdba.html

Jonathan Lewis Optimising Oracle Performance By Design Semineri 22-23-24 Nisan, Istanbul

March 21st, 2008

Day 1:

* Parser and Optimiser costs
* critical jobs that are supported by the implementation of the undo (rollback) segments
* features and costs of redo
* effects of latching

Day 2:

* Locking and Queueing
* Application Overheads.
* Trouble-shooting - Why are we waiting
* Trouble-shooting - How to avoid work

Day 3:

* Cost-based Optimisation - How the arithmetic works
* Cost-based Optimisation - How to use and abuse it
* Understanding EXPLAIN PLAN
* Open Forum and round-up

Tarih: 22-24 Nisan 2008
Fiyat: 1.575 YTL+KDV*
Yer: Istanbul
Kayıt formu: tıklayınız
Detay bilgi
Lewis’in son kitabı
Lewis’in blog’u

Telefon 0212 329 68 48
Email educations_tr@oracle.com
http://www.oracle.com/tr/education

Steven Feuerstein 11-12 Şubat 2008 İstanbul Semineri - The Best of Oracle PL/SQL

November 29th, 2007

Steven Feuerstein Oracle prosedür dili PL/SQL konusunda dünyanın önde gelen ve en çok tanınan uzmanlarından. Çok şanslıyız ki kendisi Şubat ayında iki günlük bir seminer için İstanbul’da olacak. Detaylı bilgi için; Writing High Quality PL/SQL Code with Steven Feuerstein

Kendisinin eğitim ve sunumlarına bu adresten ulaşabilirsiniz, ayrıca yine kendisinin OracleTURK grubuna yazdığı iletiyi aşağıda bulabilirsiniz;

Dear Oracle technologist in Turkey -

At the urging of H.Tonguç Yılmaz, I am writing a quick “Save the Date”
email to all of you regarding a visit I will be making to Istanbul on
February 11-12, 2008!

I will be doing a two-day training for Oracle Corporation and I very
much hope to see lots of you there.

This training will involve two days of intensive work with PL/SQL
(well - I will lecture, you will watch, ask and answer questions,
etc.). It will, I believe, be a great opportunity for you to learn
more about how to make the best use of PL/SQL in your applications,
whether you are a developer or a DBA.

I will post another email regarding this training when Oracle provides
more specifics. In the meantime, if you want to be sure to get an
invitation, please send me an email: steven@stevenfeuerstein.com

And, of course, I am VERY excited about visiting Istanbul!

Warm regards,
Steven Feuerstein
PL/SQL Evangelist, Quest Software
www.ToadWorld.com/SF - PL/SQL Obsession
www.quest.com/code-tester-for-oracle
www.stevenfeuerstein.com

Joze Senegacnik 23-24 Ağustos 2007 Semineri - Optimizing for Performance

July 17th, 2007

Bu seminer, optimizasyonu ve optimizasyon işlemlerininin veritabanı performans problemlerinin çözümünde kullanılmasını öğrenmek isteyen DBA ve Developer’lar için hazırlanmıştır. Seminerde, temel veritabanı mekanizmaları detaylı olarak tartışılacak, daha sonra da maliyet bazlı optimizasyonun konusu incelenecektir. Seminerin 2.gününde ise; wait events, response time analysis, index internals, access path optimization, SQL Profiles ve veritabanı optimizasyonundaki ipuçları gibi konular işlenecektir.

Seminerin detaylarına buradan ulaşabilirsiniz.

Joze Senegacnik

Uluslararası bir konuşmacı ve Performance Tuning uzmanı olan Joze Senegacnik, 1988 yılından beri Oracle ürünleri üzerinde çalışmaktadır. Slovenian Oracle Users Group (SIOUG) kurulu üyesi olan Jose aynı zamanda Oak Table Network’ün de üyesidir.. http://dbprof.com/

Lutz Hartmann 14-15 Mayısda Istanbul’da

March 26th, 2007

Inside Oracle with Lutz Hartmann

Abstracts: This 2 day seminar gives an overview of key new features of the Oracle Database 10g (releases 1 & 2) their usage and possible pitfalls. Lutz Hartmann points out how to aviod possible problems forehand when upgrading from an older release. The seminar covers memory management, upgrade issues, new performance tuning methodes, flashback functionalities and new backup & recovery features and recommended strategies.

Day 1:
1. Memory management in Oracle 10g
2. Upgrade issues with Oracle 10g
Day 2:
3. The new Performance Tuning approach in Oracle 10g
4. Flashback any Error with Oracle 10g?

Lutz Hartmann as sysdba

Oracle RAC Gurusu JULIAN DYKE 20-21 Subat’ta Istanbul’da

January 23rd, 2007

Lewis’den sonra bir ağır top haberi daha bugün bomba gibi gündeme düştü :)

Detay bilgiler

Oracle Gurusu Jonathan Lewis 27-28 Şubat tarihlerinde İstanbul’da!

January 10th, 2007

Oracle University Türkiye Ocak-Nisan 2007 Eğitim Programı

“Oracle database konusunda Oracle Gurusu olan Jonathan Lewis “Cost Based Optimization, Indexing Strategies and Explain Plan” adlı eğitim semineriyle 27-28 Şubat tarihlerinde İstanbul’da olacak. Eğitim semineri içeriğine bu linki tıklayarak ulaşabilirsiniz.

Eğitim Adı: Cost Based Optimization, Indexing Strategies and Explain Plan
Eğitim Tarihi: 27-28 Şubat 2007

Daha fazla bilgi için, lütfen 0212 329 68 48 numaralı telefondan veya educations_tr@oracle.com e-posta adresinden bizlere ulaşınız.”

Oracle10gR2 has taken the lead in the 10 TB scale TPC-H arena partnering with HP

December 17th, 2006

http://tpc.org/results/FDR/tpch/hp_tpch_sd_10TB_061204_fdr.pdf

Oracle® Technology Network Community Surpasses Five Million Members

December 11th, 2006

Oracle® Technology Network Community Surpasses Five Million Members