SE veled SE nélküled: Mi mindenre jó a Standard változat - Izsák Tamás (HOUG)

Hogyan tovább, ha nem akarunk Enterprise licencet venni? Megmutatjuk a Standard változat hogyan használható hatékonyan az Enterprise változat "árnyékában". Olyan kérdésekre keresünk választ, mint a mikor és miért elegendő a SE/SEONE? Hogyan lehet visszalépni EE -ről? Milyen HA megoldások állnak rendelkezésre? Licenc különbségek?

Transcript

1. izsak.tamas@houg.hu
2. Budapest Database Meetup
3. Az Oracle Budapest Database Meetup
4.  Express Edition (XE)  Standard Edition One (SE1)  Standard Edition (SE)  Enterprise Edition (EE) Budapest Database Meetup INGYENES
5. Budapest Database Meetup http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html Oracle Database
6. Budapest Database Meetup
7.  Named User Plus Minimum: 25 NUP  Processor CPU = core-ok core faktor Oracle Processor Core Factor Table: http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf Enterprise Edition Budapest Database Meetup
8.  Named User Plus Minimum: 5 NUP  Socket [ ] Standard Edition One (SE1): 2 socket-ig Standard Edition (SE): 4 socket-ig Standard Edition (One) Budapest Database Meetup
9. ?    Budapest Database Meetup
10. SOFT: HARD: Budapest Database Meetup
11.  Standard Edition One (SE1)  Standard Edition (SE)  Enterprise Edition (EE) Az Oracle Budapest Database Meetup 5 800$ - 1 334 000HUF 17 500$ - 4 025 000HUF 47 500$ - 10 925 000HUF Oracle Price List: http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf
12. Budapest Database Meetup
13.    Block change tracking    Bitmap index  Query cache  Data Guard  Fine Graind Auditing  Transportable Tablespaces    Enterprise Manager: performace tab Enterprise Edition Budapest Database Meetup
14.  RAC (2 node) (csak SE)  teljes SQL, PL/SQL motor   Data Encryption Toolkit (DBMS_CRYPTO)    Standard Edition (One) Budapest Database Meetup
15. Budapest Database Meetup
16.   partitioned view: -   Oracle 7  Budapest Database Meetup
17.  JOB-   Budapest Database Meetup
18.     Stb. Enterprise Manager Performance tab Budapest Database Meetup
19. Budapest Database Meetup
20. Data Guard Architecture ( ) Budapest Database Meetup 4 Automatic outage resolution Oracle data files Oracle Instance (in memory) Primary Database Oracle data files Recovery data Oracle Instance (in-memory) Remote Replica 3 1 SYNC or ASYNC Recovery data 2
21. Manual StandBy Standard Edition (One) Budapest Database Meetup Oracle data files Oracle Instance (in memory) Primary Database Oracle data files Recovery: Nem automatikus, időzíteni kell Oracle Instance (in-memory) Remote Replica archive logok átmásolása: manuális scriptek segítségével Recovery data
22. Oracle GoldenGate [ 17 500$ ] Budapest Database Meetup Capture Trail Pump Delivery Trail Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs. Trail: stages and queues data for routing. Pump: distributes data for routing to target(s). Route: data is compressed, encrypted for routing to target(s). Delivery: applies data with transaction integrity, transforming the data as required. Source Oracle & Non-Oracle Database(s) Bi-directional Target Oracle & Non-Oracle Database(s)
23. Budapest Database Meetup
24. Oracle Fail Safe Budapest Database Meetup
25. Oracle RAC (2 node) Budapest Database Meetup
26. Budapest Database Meetup
27. SE - EE:   EE - SE:   export-import Oracle Database Edition Budapest Database Meetup
28. Budapest Database Meetup
29. Budapest Database Meetup KAPCSOLAT izsak.tamas@houg.hu WWW.HOUG.HU
30. Budapest Database Meetup nek