1 / 24

ORACLE

ORACLE. Architektura serwera bazy danych. Wyrocznia delficka. Wyrocznia redwoodzka. ORACLE_HOME. sqlplus / as sysdba Connected to an idle instance. SQL> startup. STARTUP. PLIKI KONTROLNE. PLIKI DANYCH. INSTANCJA. INSTACJA ORACLE. S( ystem ) G( lobal ) A( rea ). ?. ?.

burton-mcguire
Download Presentation

ORACLE

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. ORACLE Architektura serwera bazy danych

  2. Wyrocznia delficka Wyrocznia redwoodzka

  3. ORACLE_HOME

  4. sqlplus / as sysdba Connected to an idle instance. SQL> startup

  5. STARTUP PLIKI KONTROLNE PLIKI DANYCH INSTANCJA

  6. INSTACJA ORACLE S(ystem) G(lobal) A(rea) ? ? SharedPool ? ? ? ?

  7. Library cache • Dictionary cache • Result cache • SharedPool

  8. SELECT * FROMLODOWKA WHEREPRODUKT=‘PIWO’ AND MARKA=‘PERŁA’ AND STATUS=‘ZIMNE’ Library Cache

  9. SELECT * FROMLODOWKA WHEREPRODUKT=‘PIWO’ AND MARKA=‘ŻUBR’ AND STATUS=‘ZIMNE’ Library Cache

  10. SELECT * FROMLODOWKA WHEREPRODUKT=‘PIWO’ AND MARKA=‘ŻYWIEC’ AND STATUS=‘ZIMNE’ Library Cache

  11. SELECT * FROMLODOWKA WHEREPRODUKT=‘PIWO’ AND MARKA=:v_marka AND STATUS=‘ZIMNE’ Library Cache :v_marka:=‘PERŁA’

  12. SELECT * FROMLODOWKA WHEREPRODUKT=‘PIWO’ AND MARKA=:v_marka AND STATUS=‘ZIMNE’ Library Cache :v_marka:=‘ŻUBR’

  13. SELECT * FROMLODOWKA WHEREPRODUKT=‘PIWO’ AND MARKA=:v_marka AND STATUS=‘ZIMNE’ Library Cache :v_marka:=‘ŻYWIEC’

  14. Library cache • Dictionary cache • Result cache • SharedPool

  15. SELECT /*+ result_cache*/ osoba_id, AVG(ilosc) FROMSTATYSTYKA_IMPREZY WHEREPRODUKT=‘PIWO’ GROUP BYosoba_id Result Cache

  16. SELECT /*+ result_cache*/ osoba_id, AVG(ilosc) FROMSTATYSTYKA_IMPREZY WHEREPRODUKT=‘PIWO’ GROUP BYosoba_id Result Cache

  17. Library cache • Dictionary cache • Result cache • SharedPool

  18. INSTACJA ORACLE S(ystem) G(lobal) A(rea) SharedPool ? ? Buffer Cache ? ? ?

  19. Buffer Cache Workingspace 1 Workingspace 2 E B F F A C D D C A B E LRU CKPT LRU CKPT CKPT CKPT DW PLIKI DANYCH PS

  20. INSTACJA ORACLE S(ystem) G(lobal) A(rea) ? Log Buffer Buffer Cache SharedPool ? ? ?

  21. Log Buffer LGWR Redo 1 Redo 2 Redo 3

  22. INSTACJA ORACLE S(ystem) G(lobal) A(rea) Log Buffer Buffer Cache SharedPool ? ? ? LargePool StreamsPool Java Pool

More Related