90 likes | 308 Views
Okuma Tutarlılığı ( Read Consistency ). Talip Hakan ÖZTÜRK B ANK ASYA – ORACLE DBA OCE, 10g OCA, 10g /11g OCP http://taliphakanozturk.wor dpress.com. Talip Hakan ÖZTÜRK. 2000-2005 Azerbaycan Teknik Üniversitesi – Bilgisayar Müh . B ANK ASYA - Oracle DBA 10g /11g OCP
E N D
Okuma Tutarlılığı (ReadConsistency) TalipHakan ÖZTÜRK BANKASYA – ORACLE DBA OCE, 10g OCA, 10g/11gOCP http://taliphakanozturk.wordpress.com
TalipHakan ÖZTÜRK • 2000-2005 AzerbaycanTeknikÜniversitesi – BilgisayarMüh. • BANKASYA - Oracle DBA • 10g/11gOCP • Oracle Blogger • http://taliphakanozturk.wordpress.com • http://taliphakanozturken.wordpress.com • Oracle Forum SorumlusuveEditörü • http://www.ceturk.com • “Oracle Database 11g R2” Kitabının Yazarı http://taliphakanozturk.wordpress.com
Read Consistency http://taliphakanozturk.wordpress.com
Read Consistency http://taliphakanozturk.wordpress.com
Read Consistency http://taliphakanozturk.wordpress.com
DML Locks Session 1: UPDATE scott.emp SET ename = 'KING1' WHERE ename = 'KING'; (don NOT commit) Session 2: SELECT ename FROM scott.emp WHERE ename='KING' FOR UPDATE OF ename wait 10; after 10 seconds : * ERROR at line 1: ORA-30006: resource busy; acquire with WAIT timeout expired http://taliphakanozturk.wordpress.com
Deadlocks http://taliphakanozturk.wordpress.com
http://taliphakanozturk.wordpress.com http://oracleforum.info http://troug.org http://www.ceturk.com http://tahiti.oracle.com http://forums.oracle.com http:/otn.oracle.com http://asktom.oracle.com http://taliphakanozturk.wordpress.com
TEŞEKKÜRLER Talip Hakan ÖZTÜRK Bilgisayar Mühendisi 10g/11g Oracle CertifiedProfessional 10g Oracle CertifiedAssociate OracleCertifiedExpert talip_hakan_ozturk@hotmail.com http://taliphakanozturk.wordpress.com • http://taliphakanozturken.wordpress.com