Oracle Cloud的技术新特性与创新

1、风云际会Oracle Cloud的新特性与创新31979年，Oracle数据库诞 生1998年，Oracle8i推出， 在中国开始大面积使用2006年左右，Oracle数据 库在中国的巅峰时刻2008年，去IOE名词被提 出2016年的Oracle12cR2开 始，最新版本总是首发 在Oracle Cloud中回顾 Oracle数据库的历史/wiki/Oracle_DatabaseOracle数据库仍然是最先进的数据库-没有之一Automatic Query RewriteAutomatic Undo ManagementAutonomous Health FrameworkAutomatic

2、 Diagnostic FrameworkAutomatic Refresh of ClonesAutomatic Memory ManagementAutomatic Segment Space MgmtAutomatic Statistics GatheringAutomatic Storage ManagementAutomatic Workload RepositoryAutomatic Diagnostic Monitor10g9i11gAutomatic SQL TuningAutomatic Workload Capture/ReplayAutomatic SQL Plan Ma

3、nagementAutomatic Capture of SQL MonitorAutomatic Data Optimization12c18cAutomatic Columnar FlashAutomatic IM populationAutomatic Application ContinuityAutomatic IndexesSQL QuarantineReal-Time Statistics19cOracle Spent Last 20 Years Automating Database TechnologySmart ScanInfiniband Scale-OutDatabas

4、e Aware Flash CacheStorage IndexesHybrid Columnar DataIO PrioritiesData Mining OffloadOffload DecryptionNetwork Resource MgmtPrioritized File RecoveryExadata Cloud ServiceIn-Memory Columnar in FlashSmart Fusion Block TransferDirect-to-wire ProtocolJSON and XML offloadInstant failure detection2008201

5、9Oracle Spent Last 10 Years Automating Database InfrastructureOracle数据库仍然是最先进的数据库-没有之一AutomatedData Center Operations and Machine LearningComplete Infrastructure AutomationComplete Database AutomationORACLE AUTONOMOUS DATABASEOracle CloudOracle数据库仍然是最先进的数据库-没有之一Oracle Cloud ConceptsOracle CloudTry i

6、t (with patience), and youll love itOracle Cloud TerminologyCloud Account (账户)kamusisUser (用户)kamusisTenancy (租户)kamusisOracle Cloud TerminologyWhen you login Oracle Cloud TerminologyWhen you logout Oracle Cloud TerminologyOracle Cloud Infrastructure is physically hosted in regions and availability

7、domains.Region (区域)Oci get regionJapan East (Tokyo)A region is a localized geographic areaAvailability Domain (可用性域)lOnA:AP-TOKYO-1-AD-1An availability domain is one or more data centers located within a regionAvailability domains are isolated from each other, fault tolerantUse multiple availability

8、 domains to ensure high availabilityOracle Cloud Infrastructure resources are either region-specific, such as a virtual cloud network, or availability domain-specific, such as a compute instance.Oracle Cloud TerminologyCompartments (区间)kamusis (root)A compartment is a collection of related resources

9、 (such as instances, virtual cloud networks, block volumes) that can be accessed only by certain groups that have been given permission by an administrator.A compartment should be thought of as a logical group and not a physical container.Ultimately, the goal is to ensure that each person has access

10、 to only the resources they need./iaas/Content/GSG/Concepts/settinguptenancy.htm?tocpath=Getting%20Started% 7C 14#twoHow to do Access Management(IAM) in Oracle CloudA policy simply allows aGROUP to work in certain ways with specific types ofRESOURCES in a particular COMPARTMENTIAM Example1. Gets Sta

11、rted with Oracle Cloud InfrastructureWe got the super user, or named by default administratorIAM Example2. The Default Administrator Creates Some Groups and Another AdministratorIAM Example3. The Default Administrator Creates Some Compartments and PoliciesIAM Example4. An Administrator Creates New U

12、sersIAM Example5. The Network Admin Sets Up the NetworkVCNtest instanceIAM ExampleCompartment Admins Set Up Their CompartmentsPut users in their users groupAttach a policy to their compartmentLaunch instances in their own compartmentVCNtest instanceOracle Cloud Always Free ServicesGeneral OverviewAn

13、nounced at OpenWorld 2019Oracle Cloud Always Free-eligible resources are:Compute (up to two instances)Autonomous Database (up to two database instances)Load Balancing (one load balancer)Block Volume (up to 100 GB total storage)Object Storage (up to 20 GiB)Are always free/iaas/Content/FreeTier/resour

14、ceref.htmCheck Limits and QuotasCheck Limits and QuotasOracle Autonomous DatabaseKey Features of New Free ServiceUp to 2 Always Free instances in every tenancys home regionUpgrade Always Free Database to Paid anytimeFixed configuration:1 OCPU (cannot be scaled)20 GB Storage (cannot be scaled)8 GB Me

15、moryMaximum Simultaneous Database Sessions: 20Includes key developer toolsOracle Application Express (APEX), Oracle SQL Developer, SQL Notebooks for Machine Learning, RESTFrom OCI console home page, click any of ATP/ADW quick actions tocreate free instanceCreating a new Always Free ADBCreating a new

16、 Always Free ADBSimple toggle to enable “Always Free”Creating a new Always Free ADBNote restriction - instances can only be created in accounts home regionFinding Home RegionHome region listed on tenancy page越近的站点，网络延迟更低很遗憾，仍然没有China Region目前比较好的选择：JapanWhat Region should I chooseCreating a new Alwa

17、ys Free ADBNote fixed configuration:1 OCPU20 GB StorageCreating a new Always Free ADBNew “Always Free” logo shown on console Check different Workload Type: ADW & ATPAlways Free ADB - Key RestrictionsMaximum of 1 OCPU per databaseMaximum of 20 GB Exadata storage per databaseMaximum of 20 simultaneous

18、 database sessionsMaximum of 2 Always Free databases per tenancy.No restriction on the workload typeBoth can have the same workload type or they can have different workload types.Both data warehouse and transactional workload types are supportedNo scale up/down, no Auto Scaling. Always Free Autonomo

19、us Databases cannot bescaled manually or automatically beyond the fixed resource restrictions describedabove.No support for full backups to OCI object storageNo support for restoring from full backupsAlways Free ADB - Key RestrictionsWarning message when trying to access a restricted featureInactivi

20、ty Monitoring - Database Stoppageautomatically, preserving its stored data.Inactivity measurements leading up to 7 days are based on database connections.Successfully making a SQL*Net or HTTPS connection resets these measurements tozero.Instance that stays inactive for 90 days, cumulative, may be re

21、claimedand permanently deleted.Inactivity measurements leading up to 90 days are based on the database beinginactive or in the stopped state.Starting a stopped database resets these measurements to zero.OCI console shows banner alerts prior to automatic stop and permanentdelete operations occurring.

22、Subscribing to OCI Alerts and Notifications triggers automatic email notifications.Persistently inactive instances are detected and handled as followsAfter being inactive for 7 days, the database will be stoppedDatabase Connec tion匹扣竺0 DB CONNECTIONAPPLICATION CONNECTIONYou will need the client cred

23、enitals and connection information to connect to you database.The client credentials include the wallet, which is requ什忒 for all types of connectionsDownload Client Credentials (Wallet)To download you client credentials, select the type of wallet, then click Download Wallet. You will be asked to cre

24、ate a password for the walletWALLET TYPE CD尸ance WalletvDownload WalletRotate WalletWallet last rotated: 一Connection StringsUse the followingconnection strings or TNS names fo your connections. See the documentation for details. Oracle recommendsusing TLS connections to connect to your Autonomous Da

25、tabase.TNS Name Connection String (DW HIGH.xcc_dbadw_ Show P-Y.c_dbadw_ Show RY.W LOW.4xcc dbadw ShowRY.CaptureIdentifyVerifyDecideMonitorAutomatic IndexingThe Automatic Indexing methodology is based on a common approach to manual SQL tuning.It identifies candidate indexes and validates them before implementing.The entire process is fully automatic.Transparency is equally important as sophisticated automation. A