Monthly Archives: November 2010

11gR2 ASM Intelligent Data Placement

This is very good new features. If you set Intelligent Data Placement you will gain many performance benefits. You can set frequently accessed data to hot region. Intelligent Data Placement also allows the placement of primary and mirror extents in … Continue reading

Posted in Intelligent Data Placement | Leave a comment

Ferhat Sengonul Podcast

Ferhat is one of the most valuable members of our TROUG(Turkish Oracle User Group).I wanted to share with you this nice to podcast. http://streaming.oracle.com/ebn/podcasts/media/9547030_Turkcell_111810.mp3http://ferhatsengonul.wordpress.com/

Posted in podcast | Leave a comment

Grid Clusterware-Diagnostics Collection Script

I suggest you use diagcollection.pl script to collect diagnostic information from an Oracle Grid Infrastructure installation.This script is located u01/app/11.2.0/grid(Grid_Home)/bin/diagcollection.plConnect root user then run above mention script.When invoked script •crsData_hostname_date.tar.gz contains log files•coreData_host_name_date.tar.gz contains core files•ocrData_hostname_date.tar.gz files contains ocrdump and … Continue reading

Posted in diagcollection.pl | Leave a comment

SCAN – SINGLE CLIENT ACCESS NAME

11g r2 grid infranın en onemli ozeliklerinden biride SCAN. bu ozellik sayesinde cluster node eklerken ve cikarirken her defasinda tnsnames.orayı modifiye etmek zorunda kalmiyoruz. Artik cluster son derece kolay kurulabilen ve ozellikle cluster baglanan sunucu sayisi gunden gune artan bir … Continue reading

Posted in SCAN - SINGLE CLIENT ACCESS NAME | Leave a comment

Oracle Day My Presentation/11g New features For DBA

Turkish Oracle User Group Session. Click Link for See My presentation

Posted in Oracle Day | Leave a comment

Vakit Tamam,TROUG Avrupa’nın en buyugu olmak için yola çıkıyor

Vakit Tamam,Turkish Oracle User Group Avrupa’nın en buyugu olmak için yola çıktı. Sizlerle TROUG nasıl hayata geçtiğini ve bu konudaki izlenimlerimi paylaşmak istiyorum. Türkiye’de H.Tonguç Yılmaz’ın yıllar önce kurduğu ve bugun 10 yılı aşan süresine rağmen hayatta olan insanların birçok … Continue reading

Posted in turkish oracle | Leave a comment

4 November Oracle Day-My Presentation Subjects

11g Database Most important New Features 1- Grid Computing 2- Data Guard New Features 3- SQL Performance Analyzer 4- Flashback Data Archive 5- Management New Features 6- Compress 7- Grid infra ACFS,ADVM 4 November 2010 Istanbul Lutfu Kırdar TROUG-Turkish Oracle … Continue reading

Posted in Oracle day istanbul | Leave a comment

ORA-12838: cannot read/modify an object after modifying it in parallel

SQL> ALTER SESSION FORCE PARALLEL DML PARALLEL 4; Session altered. SQL> DELETE sh.customers1 WHERE cust_id>10000; 32000 rows deleted. SQL> select * from sh.customers1; select * from sh.customers1 * ERROR at line 1: ORA-12838: cannot read/modify an object after modifying it … Continue reading

Posted in ora-12838 | Leave a comment

Datawarehouse Turkiye

Türkiye’de özelikle Türkçe kaynak bulmak yönündeki zorlukları biliyoruz. Bu konuda birçok dokuman yayımlayan biri olarak http://datawarehouse.gen.tr gormenizi tavsiye ederim.

Posted in Datawarehouse turkiye | Leave a comment