Monthly Archives: October 2010

11gR2 Clusterware tips

Grid home consists of the Oracle Clusterware and ASM. But Grid Infra and RAC DB must be install different home. First install clusterware then install RAC If you want to use ASM and Oracle Restart GI can be installed in … Continue reading

Posted in 11g r2 cluster | Leave a comment

RAC Tuning Tips

– Tuning single instance first – SQL Tuning is most beneficial – Buffer cache size is very important – Use sequence cache – Use partition table – Reduce long full table scan (OLTP) – Use selective,correct index – Use automatic … Continue reading

Posted in Rac tuning tips | Leave a comment

Oracle Grid Infra / ASM Files and RMAN

RMAN> BACKUP AS COPYDATAFILE “+DATA/rdbms/datafile/tbs_1.252.234234”FORMAT “+DATA”; RMAN>Backup as copy database format “+DATA”; Rman canbe used to migrate database into ASM you can access ASM files using XMLDB Access via PLSQL,FTP and HTTP. You can access under /sys/asm, the folder hierarchy … Continue reading

Posted in ASM files | Leave a comment

TROUG Turkish Oracle User Group / Oracle DAY 4 KASIM

4 Kasım Oracle Day’de Haliç salonundayız. 14:00 – 14:40 Konu: Oracle 11g DBA ler için yeni özellikler Konuşmacı:Zekeriya Besiroglu 14:45 – 15:30 Konu:Oracle 11g Database Developerlar için yeni özelikler Konuşmacı:H.Tonguc Yılmaz 15:30 – 16:00 Ara 16:00 – 16:40 Konu: Oracle … Continue reading

Posted in Uncategorized | Leave a comment

TROUG Turkey Oracle User Group

TURKEY ORACLE USER GROUP 4 Kasım Oracle Day Haliç salonu saat 14.00-1730 arasında11g Yeni özellikler seminerleri ve Uzmanlara soru sorabileceğiniz özel panelimize hepinizi bekleriz. Ayrıca 4 Kasımda Standımızı ziyaret eden ve panele katılan arkadaşlarımız hediye TROUG termos bardağı kazanacaklar. Turkey … Continue reading

Posted in Turkey Oracle User group | 1 Comment

Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

I delivered below mention course two weeks ago. I recommend this course who want to know Oracle ASM, Oracle Grid infrastructure, Oracle Clusterware. This course is based on Oracle Database 11g Release 2. Learn To: Describe the Oracle Database 11g … Continue reading

Posted in Manage clusterware and ASM | Leave a comment

oracle SYS_CONTEXT Examples;

Connect system /oracle@orcl SET SERVEROUTPUT ON SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘CURRENT_USER’));SYSTEM SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘SESSION_USER’));SYSTEM SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘IP_ADDRESS’));192.168.1.2 SQL> SELECT sys_context(‘USERENV’, ‘IP_ADDRESS’) FROM DUAL;192.168.1.2 SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘NETWORK_PROTOCOL’));tcp SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘AUTHENTICATION_TYPE’)); DATABASE SQL> SELECT sys_context(‘USERENV’, ‘AUTHENTICATION_TYPE’) FROM DUAL;DATABASE SQL> … Continue reading

Posted in sys_context | Leave a comment

Implementing Fine Grained Audit

conn / as sysdbacreate user zekeriya identified by oracle;grant session,resource to zekeriya;grant execute on dbms_session to zekeriya;grant execute on dbms_fga to zekeriya; conn zekeriya/oracle create table kullanici (schema varchar2(20), name varchar2(30), policyname varchar2(30)); create procedure log (p_schema varchar2, p_name varchar2, … Continue reading

Posted in fine grained audit | Leave a comment

Sql Tunnimg Seminer Örnekler /Oracle Sql tunning seminer

1. Bölüm:Bir SQL’in planını nasıl görüntülenir, nasıl okunur?Start –> Run –> Cmdsqlplus /nologconn /as sysdbaconn sh/shset autotrace traceonly explainselect * from salessorgusu çalıştırıldığında Sql çalışma yolu ekranda görüntülenir. Sales tablosunda 1 milyon kayıt olduğunu düşünelim.bu tabloya yazılan select full table … Continue reading

Posted in Uncategorized | Leave a comment

ORACLE ASM TAVSIYELERI-Oracle Asm Suggestion

ASM Best suggestionhttps://docs.google.com/present/edit?id=0ASMnK-SgaHxiZGZ3dGZydGhfMTczZ2p4NmRnZ3Q&hl=en&authkey=CPma87UH

Posted in ASM advise | Leave a comment