Oracle ArchitectualOracle ServerA. Oracle Database (Storage)A.1 PHYSICALa.
![]()
Redolog file: chua moi thay doi cua Oracle archived-log file ( 10 vi tri) - Log Group: it nhat 2, moi log group phai co it nhat 1 log member ( file) - Oracle tu van, 1 log group nen 3 logfile member. FIFA Online 4 is a free-to-play massively multiplayer online football developed by EA Spearhead and published by Nexon. It was announced on 2 November 2017, and released on 17 May 2018 in South Korea. In various Southeast Asia published by Garena and China published by Tencent.
Datafile: luu du lieu nguoi dung & luu du lieu Oracleb. Init parameter file: text & binarye.
Password filef. Archived log fileg. Backup fileA.2 LOGICALDatabase Tablespace Segments ( Table, Index) Extents Oracle Block OS blockB.
![]()
Oracle InstanceB.1 Memorya. SGA- Shared-pool Library Cache: shared sql hoac PLSQL Dictionary Cache: mo ta objects, privs.- Buffer-Cache: cache block duoc doc / ghi- Redolog-Buffer: ghi moi thay doi len data-block- Java-Pool: java- Large-Pool: big objectsb. PGA: khi server process sinh ra, chua thong tin noi bo server processB.2 Processa. Background processSMONPMONCKPTDBWR nLGWRARCH n: ARCHIVED LOG modeb. Server process- dedicated server: 1 server process = 1user process- shared server: 1 server process = 20 - 30 user process- General (Hybrid)L2: Getting Started With Oracle Server1. SQL.
PLUS: interactive & manipulate Oracle Server2. Oracle Universall Install (OUI): install & remove oracle software, create database (dbca)3. Dbca: create, delete, configure & manage template oracle databae4. Oracle Enterprise Manager (OEM)- single database (standalone): quan tri tung database rieng le, khong can cau hinh- Oracle Management Server (OMS): - quan tri nhieu database tren 1 giao dien chung thong nhat, chi can login 1 lan co the quan tri nhieu database,- phai cau hinh, phai cai Agent tren cac may Oracle can quan ly va phai cai Oracle Repository)L3. Managing Oracle Instance1. Pfile / spfile: tham so cau hinh Oracle Instance- pfile: text, duoc doc khi STARTUP- spfile: binary, ALTER SYSTEM set sharedpoolsize=200M scope=spfile memory both- spfile$ORACLESID.ora spfile.ora init$ORACLESID.ora init.ora- Vi tri file tham so:$ORACLEHOME/dbs/2.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |