untitled

Similar documents

意外と簡単！？ Oracle Database 11g -バックアップ・リカバリ編-

クラウド時代のインフラ構成/変更管理とコンプライアンス管理

Windowsユーザーの為のOracle Database セキュリティ入門

すぐに使える！Essbase キューブ開発テクニック集

雲の中のWebアプリケーション監視術！～いまなら間に合うクラウド時代の性能監視入門～

KWCR3.0 instration

Windows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved.

Visual Studio Oracle Database 11g アプリケーション開発入門

<Insert Picture Here> Oracle Business Intelligence 2006/6/27

データ連携がこんなに簡単に！？Oracle Data Integratorのご紹介

Microsoft PowerPoint _SQLDeveloper.ppt [互換モード]

Copyright 2008 All Rights Reserved 2

ハピタスのコピー.pages

相続支払い対策ポイント

150423HC相続資産圧縮対策のポイント

<Insert Picture Here>

What's Oracle WebLogic Server　～なぜWebLogic Serverが選ばれるのか～

Oracle Direct Seminar <Insert Picture Here> システム管理者必見! ~ 乱立する DB と OS のユーザー / 権限管理の改善方法日本オラクル株式会社 Fusion Middleware 事業統括本部 Security SC 部大森潤

オラクルのバックアップとリカバリの必須要件

Oracle Enterprise Manager 10g R2 Grid Control: データベース管理の新機能

<Documents Title Here>

初心者にもできるアメブロカスタマイズ新2016.pages

- 2 Copyright (C) All Rights Reserved.

今さら聞けない!? Oracle入門　～後編～

Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005との技術的比較

Oracle Database 10g Release 2を使用したデータベース・パフォーマンス

アジェンダ ORACLE MASTER Oracle Database 11g 概要 Gold DBA11g 試験紹介ポイント解説無償技術サービス Oracle Direct Concierge SQL Server からの移行アセスメント MySQL からの移行相談 PostgreSQL から

Copyright All Rights Reserved. -2 -!

IPA:セキュアなインターネットサーバー構築に関する調査

Microsoft Word - 最終版　バックせどりismマニュアル .docx

自己管理型データベース: アプリケーションおよびSQLチューニング・ガイド

意外と簡単!?

日本語タイトルを入力

! Copyright 2015 sapoyubi service All Rights Reserved. 2

橡ExCtrlPDF.PDF

HULFT-DataMagic Ver2.2.0 製品対応OS

Oracle Direct Seminar <Insert Picture Here> 体感型セミナー SQL をクイズ感覚で学ぶ! SQL クイズ日本オラクル株式会社

<Documents Title Here>

日本オラクル株式会社

Agenda Windows ServerとOracle Databaseについて最低限知っておいてほしいセキュリティ面でのポイント Windowsユーザー向け.NET 開発者向け Copyright 2011, Oracle. All rights reserved. 2

Windows SE RAC 10g 構築手順書

Web Microsoft 2008 R2 Database Database!! Database 04 08

FileMaker Oracle Microsoft SQL Server MySQL Salesforce.com ROI TCO RAD IT FileMaker Pro RAD RAD TCO RAD Microsoft Visual Studio 2008 Oracle Developer

今さら聞けない!? Oracle入門　～前編～

Oracle Database 10gのOracle Data Guard

keysql42_usersguide

<Documents Title Here>

Oracle Locator Oracle Database 10g Standard Edition Standard Edition One Oracle Database 10g Release 1 Oracle Locator : Enterprise Edition Oracle Loca

ハイウォーターマークを知る

Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイドリリース2.2

Oracle Database 11g × Hitachi Storage Solutionsのベストプラクティス

健康保険組合のあゆみ_top

リバースマップ原稿2

Oracle Direct Seminar <Insert Picture Here> 試験対策ポイント解説 11g SQL 基礎 Ⅰ 日本オラクル株式会社

Oracle Database Connect 2017 JPOUG

Recovery Managerのバックアップおよびリカバリの最適化

Oracle XML DB によるスケーラビリティおよびパフォーマンス検証 - MML v.3.0

BC4J...4 BC4J Association JSP BC4J JSP OC4J

Oracle Application Server 10g( )インストール手順書

DS_BIG-IP LTM VE_jp.indd

Oracle Lite Tutorial

Agenda Oracle Database の概要 Oracle Databaseの内部構造 Oracle Databaseの処理の仕組み Oracle Database の管理メモリの管理領域の管理 Oracle Database の運用ポイント ( 概要 ) データベースの起動と停止デー

はじめにコース概要と目的 Oracle を使用した開発管理を行う上でのファーストステップとしてリレーショナルデータベース管理ソフトウェアである Oracle の役割基本機能基本アーキテクチャを幅広く理解することを目的としています受講対象者これから Oracle を使用する方データ

やよいの顧客管理

弥生給与/やよいの給与計算

弥生シリーズ

弥生会計プロフェッショナル/スタンダード/やよいの青色申告

弥生会計/やよいの青色申告

弥生会計ネットワーク/プロフェッショナル2ユーザー

IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Informati

Copyright 2008 NIFTY Corporation All rights reserved. 2

<Documents Title Here>

Oracle Application Server 10g(9

自己管理データベース: 自動SGAメモリー管理

Microsoft Word - J doc

Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21

Oracleの領域管理～トラブル防止のテクニック～

外部SQLソース入門

Transcription:

Oracle Direct Seminar <Insert Picture Here>!? Oracle Database 11g - -

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 2

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 3

( ATM ) Copyright 2009, Oracle. All rights reserved. 4

Microsoft Windows 2003 + Service Pack1 RDBMS Oracle Database 11g Release 1 Enterprise Edition for Windows Copyright 2009, Oracle. All rights reserved. 5

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 6

Copyright 2009, Oracle. All rights reserved. 7

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 8

EM EM EM EM EM EM Enterprise Manager Copyright 2009, Oracle. All rights reserved. 9

A Oracle Copyright 2009, Oracle. All rights reserved. 10

A B C Copyright 2009, Oracle. All rights reserved. 11

SYS ( ) SYSTEM: SYSMAN, DBSNMP, (HR,OE,SH ) Copyright 2009, Oracle. All rights reserved. 12

Copyright 2009, Oracle. All rights reserved. 13

Copyright 2009, Oracle. All rights reserved. 14

LOCKED Copyright 2009, Oracle. All rights reserved. 15

HR Copyright 2009, Oracle. All rights reserved. 16

SCOTT Copyright 2009, Oracle. All rights reserved. 17

Copyright 2009, Oracle. All rights reserved. 18

Copyright 2009, Oracle. All rights reserved. 19

SCOTT Copyright 2009, Oracle. All rights reserved. 20

Copyright 2009, Oracle. All rights reserved. 21

Copyright 2009, Oracle. All rights reserved. 22

ORADIRECT ORADIRECT DEFAULT USERS TEMP Copyright 2009, Oracle. All rights reserved. 23

Copyright 2009, Oracle. All rights reserved. 24

CPU: CPU / I/O Copyright 2009, Oracle. All rights reserved. 25

Copyright 2009, Oracle. All rights reserved. 26

Copyright 2009, Oracle. All rights reserved. 27

Copyright 2009, Oracle. All rights reserved. 28

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 29

EM EM EM Public Enterprise Manager Copyright 2009, Oracle. All rights reserved. 30

Copyright 2009, Oracle. All rights reserved. 31

CREATE SESSION CREATE TABLE GRANT SELECT ON TO ; CREATE TABLE CREATE SESSION SELECT ORACLE Copyright 2009, Oracle. All rights reserved. 32

ORADIRECT CREATE SYNONYM CONNECT CREATE SYNONYM CREATE TABLE CREATE TABLE CREATE VIEW ORADIRECT CREATE VIEW ORADIRECT Copyright 2009, Oracle. All rights reserved. 33

EM EM EM PUBLIC Enterprise Manager Copyright 2009, Oracle. All rights reserved. 34

(SELECT ) ORADIRECT EMPLOYEES SCOTT Copyright 2009, Oracle. All rights reserved. 35

Copyright 2009, Oracle. All rights reserved. 36

Copyright 2009, Oracle. All rights reserved. 37

ADMIN OPTION GRANT OPTION CREATE TABLE ADMIN OPTION DBA YAMADA UMINO CREATE TABLE CREATE TABLE Copyright 2009, Oracle. All rights reserved. 38

Copyright 2009, Oracle. All rights reserved. 39

Copyright 2009, Oracle. All rights reserved. 40

Copyright 2009, Oracle. All rights reserved. 41

Copyright 2009, Oracle. All rights reserved. 42

Copyright 2009, Oracle. All rights reserved. 43

Copyright 2009, Oracle. All rights reserved. 44

Copyright 2009, Oracle. All rights reserved. 45

CREATE TABLE PUBLIC GRANT CREATE TABLE TO PUBLIC; Copyright 2009, Oracle. All rights reserved. 46

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 47

EM EM Enterprise Manager Copyright 2009, Oracle. All rights reserved. 48

SGA ( ) REDO Copyright 2009, Oracle. All rights reserved. 49

Copyright 2009, Oracle. All rights reserved. 50

Copyright 2009, Oracle. All rights reserved. 51

Copyright 2009, Oracle. All rights reserved. 52

Agenda <Insert Picture Here> Copyright 2009, Oracle. All rights reserved. 53

EMP_ID 100 EMP_NAME YAMADA SALARY 6000 SALARY 101 KAWADA 5500 102 UMINO 4000 103 TSUTIYA 3000 EMP_ID 100 EMP_NAME YAMADA EMP_ID EMP_NAME 101 KAWADA 102 UMINO 103 TSUTIYA Copyright 2009, Oracle. All rights reserved. 54

Copyright 2009, Oracle. All rights reserved. 55

EMPVIEW ORADIRECT SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME FROM EMPLOYEES Copyright 2009, Oracle. All rights reserved. 56

Copyright 2009, Oracle. All rights reserved. 57

EMPLOYEES EMPLOYEE _NAME ADDRESS SALARY EMPLOYEES EMPLOYEE_NAME ADDRESS Copyright 2009, Oracle. All rights reserved. 58

Copyright 2009, Oracle. All rights reserved. 59

Copyright 2009, Oracle. All rights reserved. 60

Oracle Direct Seminar 100 Wendy2010 11 122!! a. b. c. d. a,b,c,d http://www.oracle.com/technology/global/jp/membership/index.html ORD_SEMINAR_JP@ORACLE.COM 2009 11 12 Oracle Direct Copyright 2009, Oracle. All rights reserved. 61

OTN!! Oracle Technology Network(OTN) http://otn.oracle.co.jp/forum/index.jspa?categoryid=2 OTN OTN Oracle 100% http://www.oracle.com/technology/global/jp/ondemand/otn-seminar/index.html OTN OTN OTN Copyright 2009, Oracle. All rights reserved. 62

IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database Copyright 2009, Oracle. All rights reserved. 63

Oracle Direct Oracle Direct IT / Web 0120 155 096 ~ 9:00~12:00 13:00~18:00 Copyright 2009, Oracle. All rights reserved. 64

Oracle Direct Seminar Oracle Direct Seminar!? Database 11g!! Oracle By Example Transparent Database Encryption OTN(Oracle Technology Network)!? : : http://www.oracle.com/technology/global/jp/columns/index.html Copyright 2009, Oracle. All rights reserved. 65

Oracle PeopleSoft JD Edwards Siebel