Month: October 2010

RAC Tuning Tips

Posted on by zekeriyab

- 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 segment space management- Private Network/Interconnect 1/10 Gbit Ethernet Infiniband

Oracle Grid Infra / ASM Files and RMAN

Posted on by zekeriyab

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 XMLDBAccess via PLSQL,FTP and HTTP.You can access under /sys/asm, the folder hierarchy is defined by the structure of an ASMYou can run $ORACLE_HOME/rdbms/admin/catxdbdbca.sql or use Oracle enterprise managerAlso you can use … Continue reading Oracle Grid Infra / ASM Files and RMAN →

TROUG Turkish Oracle User Group / Oracle DAY 4 KASIM

Posted on by zekeriyab

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 Besiroglu14:45 – 15:30 Konu:Oracle 11g Database Developerlar için yeni özeliklerKonuşmacı:H.Tonguc Yılmaz15:30 – 16:00 Ara16:00 – 16:40 Konu: Oracle 11g çok büyük databaseler için yeni özellikler ve ExadataKonuşmacı:Husnu Sensoy 16:45 – 17:30 Panel:TROUG Round Table H.Tonguc Yılmaz moderatörlüğünde … Continue reading TROUG Turkish Oracle User Group / Oracle DAY 4 KASIM →

TROUG Turkey Oracle User Group

Posted on by zekeriyab

TURKEY ORACLE USER GROUP4 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 Oracle User Group Uye olmak icinhttp://www.troug.org/ adresindeki kayıt formunu doldurabilirsiniz.

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

Posted on by zekeriyab

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 Grid InfrastructureConfigure and manage ASM and ACFSInstall and configure Grid InfrastructureUse Oracle Clusterware to make applications … Continue reading Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2 →

oracle SYS_CONTEXT Examples;

Posted on by zekeriyab

Connect system /oracle@orclSET SERVEROUTPUT ONSQL> EXEC dbms_output.put_line(sys_context('USERENV', 'CURRENT_USER'));SYSTEMSQL> EXEC dbms_output.put_line(sys_context('USERENV', 'SESSION_USER'));SYSTEMSQL> EXEC dbms_output.put_line(sys_context('USERENV', 'IP_ADDRESS'));192.168.1.2SQL> SELECT sys_context('USERENV', 'IP_ADDRESS') FROM DUAL;192.168.1.2SQL> EXEC dbms_output.put_line(sys_context('USERENV', 'NETWORK_PROTOCOL'));tcpSQL> EXEC dbms_output.put_line(sys_context('USERENV', 'AUTHENTICATION_TYPE')); DATABASESQL> SELECT sys_context('USERENV', 'AUTHENTICATION_TYPE') FROM DUAL;DATABASESQL> SELECT sys_context('USERENV', 'CURRENT_USER') FROM DUAL;SYSTEMSQL> SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') FROM DUAL;TCP

Implementing Fine Grained Audit

Posted on by zekeriyab

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/oraclecreate table kullanici (schema varchar2(20), name varchar2(30), policyname varchar2(30));create procedure log (p_schema varchar2, p_name varchar2, p_policyname varchar2)asbegininsert into kullanicivalues(p_schema,p_name,_p_policyname);end;/BEGINdbms_fga.add_policy( object_schema =>'hr' object_name =>'employees' policy_name =>policyismi audit_condition =>null audit_column =>salary handler_schema =>'zekeriya' handler_module => … Continue reading Implementing Fine Grained Audit →

Sql Tunnimg Seminer Örnekler /Oracle Sql tunning seminer

Posted on by zekeriyab

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 scan şeklinde gitmektedir. Yani tabloya full ulaşıp full scan yapmaktadır. FTS cost'u yükseltir.set autotrace traceonly … Continue reading Sql Tunnimg Seminer Örnekler /Oracle Sql tunning seminer →