1 / 10

V ERİTABANI M İMARİSİ

V ERİTABANI M İMARİSİ. 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 OCE, 10g OCA, 10g /11g OCP Oracle Blogger

donny
Download Presentation

V ERİTABANI M İMARİSİ

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. VERİTABANI MİMARİSİ TalipHakan ÖZTÜRK BANKASYA – ORACLE DBA OCE, 10g OCA, 10g/11gOCP http://taliphakanozturk.wordpress.com

  2. Talip Hakan ÖZTÜRK • 2000-2005 AzerbaycanTeknikÜniversitesi – BilgisayarMüh. • BANKASYA - Oracle DBA • OCE, 10g OCA, 10g/11gOCP • Oracle Blogger • http://taliphakanozturk.wordpress.com • http://taliphakanozturken.wordpress.com • CETURK Oracle Forum SorumlusuveEditörü • http://www.ceturk.com • “Oracle Database 11g R2” Kitabının Yazarı http://taliphakanozturk.wordpress.com

  3. Gündem: • Oracle Veritabanı Mimarisi • Oracle Veritabanı Memory Yapısı • Oracle Veritabanı Process Yapısı • Oracle Veritabanı Storage Yapısı http://taliphakanozturk.wordpress.com

  4. System Global Area (SGA) Genel Oracle Veritabanı Mimarisi Instance Memory structures Process structures Background processes Database files Storage structures http://taliphakanozturk.wordpress.com • 10

  5. Redo Log Buffer Shared SQL Area Database Buffer Cache Server Data File Raw Device USER Oracle Database Memory Structure D000 SMON RECO S000 PMON P000 SGA TL-812 CKPT LGWR DBW0 ARCH Redo Log File http://taliphakanozturk.wordpress.com

  6. PMON SMON SGA Database Buffer Cache Redo Log Buffer Offline Storage Device DBWR LGWR ARCH User Process CKPT Control Files Redo Log Files Data Files Oracle Background Processes Dedicated Server Process http://taliphakanozturk.wordpress.com

  7. Redo Logve Archive Log LGWR LGWR Disk1 1a 3a 1b 3b Disk2 Disk3 2a 4a 2b 4b Disk4 LGWR LGWR ARC ARC ARC ARC ARCH Disk5 ARCH Disk6 http://taliphakanozturk.wordpress.com

  8. Storage Structure Mantıksal Fiziksel Database Data file Schema Tablespace Segment Extent OS block Oracle datablock http://taliphakanozturk.wordpress.com

  9. Segment 96K Extent 24K Extent 72K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K 2K Database Blocks Storage Structure Tablespace http://taliphakanozturk.wordpress.com

  10. 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

More Related