List All Pages
Top
Oracle関連
OCM
Oracle10g 新機能
Oracle11g 新機能
常用SQL文収蔵
EBS R12
OAS
探し中
Wait Events
Internal Tables
Hidden Init...
[http://download.oracle.com/docs/cd/B19306_01/install.102/b28052/toc.htm|公式ガイド]
注意点
RPMパッケージリスト
xterm
xhost
gnome-session[startx][startkde]
201試験： 出題範囲の詳細
version. 0.9/...
202試験： 出題範囲の詳細
version. 0.9/...
Automatic Offsets
Withholding Tax
Disbursement
Voucher
encumbrance accounting
Liability
Expenses Clearing
PO Rate Variance Gain/Loss
Retainage
Commitment and Obligation
Interest Expense
Interest...
AutoAccounting
receipt
Installments
Remit To Address
Freight or Charges chargeback
Instrument Number
balance forward bill number
Sold To Customer
ship-to customer
bill-to customer
Tax...
em
@?/rdbms/admin/addmrpt.sql
alter system switch logfile
alter system archive log all
...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i58728
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i58728
To enable automatic memory management
SHOW PARAMETER TARGET
select value from v$pgastat where name='maximum PGA allocated';
memory_target = sga_target + max(pga_aggregate_target, maximum PGA...
alter system set sga_max_size=200m scope=spfile;
alter system set sga_target=200m scope=spfile;
alter system set sga_max_size= 0 scope=spfile;
alter system set sga_target=0 scope=spfile;
begin DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(10080,60); end;
Restoring the Server Parameter File
SET DBID
STARTUP FORCE NOMOUNT;
RUN
{
SET UNTIL TIME 'SYSDATE-7';
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE disk TO...
...
check connectivity
cd /mountpoint/crs/Disk1/cluvfy/
./runcluvfy comp nodereach -n node1,node2 -verbose
pre crsinst
./runcluvfy stage -pre crsinst -n node1,node2
Set up printers
Resize your database
Set up National Language Support (NLS)
Set up Unicode Character Sets
Complete Oracle Workflow Notification Mailer configuration
Set up and implement Oracle...
The connection between the client and the E-Business Suite forms is provided through an applet in the client Web browser.
Instead of using the browser's own JVM, Oracle Applications Release 12 uses...
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/listenercfg.htm#sthref962
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=...
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/naming.htm#sthref692
sales=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=...
手動データベースを作成する手順：
1. ocm.sh
mkdir -p /u01/app/oracle/admin/ocm/adump
mkdir -p /u01/app/oracle/admin/ocm/bdump
mkdir -p /u01/app/oracle/admin/ocm/cdump
mkdir -p...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/network.102/B19269-04/apdvcntx.htm#593716
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/logs/my/redo01a.log','/u02/logs/my/redo01b.log') SIZE 100M...
BEGIN
sys.dbms_scheduler.create_job_class(
logging_level => DBMS_SCHEDULER.LOGGING_RUNS,
resource_consumer_group => 'OLTP',
comments => 'MY_JOB_CLASS',
job_class_name =>...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/appdev.102/B19247-01/toc.htm
CREATE TABLE "ZQ"."LOB01" ( "TID" NUMBER, "TNAME" VARCHAR2(50), "TLOB" CLOB) TABLESPACE "OLTP" LOB...
CREATE MATERIALIZED VIEW "ZQ"."MV01" TABLESPACE "OLTP" NOLOGGING CACHE USING INDEX TABLESPACE "OLTP" REFRESH FORCE ON DEMAND ENABLE QUERY REWRITE AS select count(*) from tbl2
BEGIN...
CREATE SMALLFILE TABLESPACE "OPTTBS" DATAFILE '/u02/oradata/PROD/opttbs_01.dat' SIZE 10M AUTOEXTEND ON NEXT 1024K MAXSIZE 10M NOLOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref298
CREATE DATABASE rbdb1
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
UNDO...
startup mount
alter database flashback on;
select flashback_on from v$database;
ora_12514
startup nomount pfile='/home/oracle/works/initcompany.ora'
create spfile from...
...
BEGIN
sys.dbms_scheduler.create_schedule(
repeat_interval => 'FREQ=MINUTELY;INTERVAL=60',
start_date => to_timestamp_tz('2009-05-05 11:39:00 +9:00', 'YYYY-MM-DD HH24:MI:SS...
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"PERFSTAT"."JOB_PERFSTAT"',
program_name => '"PERFSTAT"."PROGRAM_PERFSTAT"',
schedule_name =>...
create tablespace tbs_local_01
datafile '/u04/oradata/PROD/tbs_local_01_01.dbf' size 50m
extent management local
segment space management auto
create tablespace tbs_local_02
datafile...
BEGIN
DBMS_SCHEDULER.CREATE_WINDOW(
window_name=>'"PERF_WEEKDAY_WINDOW"',
resource_plan=>'PERF_PLAN',
start_date=>systimestamp at time zone '+9:00',
duration=>numtodsinterval(720,...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i67520
1 primary
alter database force logging;
2 primary
ALTER DATABASE ADD STANDBY...
alter database recover managed standby database cancel;
alter database open;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY...
...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19211-01/dp_export.html#13445
expdp user/user tables=table dumpfile=data_pump_dir:table.dmp
expdp user/user...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19211-01/dp_import.html#9247
impdp hr/hr TABLES=employees DIRECTORY=dpump_dir1NETWORK_LINK=source_database_link...
Create Database Manually
To enable automatic memory management
Performing RMAN Recovery
dcmctl deployApplication –file /private/myapp.war –a myapp –co home –rcmyapp
dcmctl redeployApplication –file /private/myapp.war –a myapp –co home –rc myapp
dcmctl...
...
Install and Configuration EBS R12
EBS 核心业务模块实施的难易程度
EBS R12 Default User
Configure Client Software
Conditional Tasks Specific to Your Installation
Oracle Homes
Oracle...
Well, the two are processed very very differently.
Select * from T1 where x in ( select y from T2 )
is typically processed as:
select *
from t1, ( select distinct y from t2 ) t2
where t1.x =...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19211-01/et_concepts.html#671
create directory default_directory as '/u04/oradata/PROD/directory';
create table...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/et_concepts.htm#i1009391
グーグル辞書は素晴らしいですね、簿記関連用語全部調べてくれました。超うれしい～！
http://www.google.cn/dictionary
日商簿記2級
http://bokimasa.blog110.fc2.com/blog-entry-30.html
グーグル辞書は素晴らしいですね、簿記関連用語全部調べてくれました。超うれしい～！
http://www.google.cn/dictionary
日商簿記2級
http://bokimasa.blog110.fc2.com
グーグル辞書は素晴らしいですね、簿記関連用語全部調べてくれました。超うれしい～！
http://www.google.cn/dictionary
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/network.102/B19269-04/cfgaudit.htm#138840
alter system set audit_sys_operations=true scope=spfile;
alter system set...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/network.102/B19269-04/cfgaudit.htm#140653
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dfiles.htm#i1106090
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr005.htm
show parameter db_recovery
alter system set db_recovery_file_dest='/u01/oracle/app/flash_recovery_area' scope=both;
alter system set db_recovery_file_dest_size=10G scope=both;
select * from v$recovery_file_dest;
select * from v$flash_recovery_area_usage;
select current_scn from v$database;
select * from v$flashback_database_log;
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/backup.102/B19193-02/flashptr.htm#1748
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr004.htm#BRBSC01511
SQL> define _editor=vi
DROP
Any user with drop privileges over the object can drop the object,...
http://www.oracle-base.com/articles/10g/Flashback10g.php
You must have either the FLASHBACK ANY TABLE system privilege or have FLASHBACK object privilege on the table.
You must have SELECT,...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm#PFGRF003
credit hold
balancing segment
parent account
summary account
unapplied receipt
unidentified receipt
on-account receipt
[CHN] 过账
[JPN]
[ENG] posting
[CHN] 帐套
[JPN]
[ENG] ledger...
创建帐套和定义职责
定义会计科目结构
定义会计期间
选择记帐本位币
定义职责...
凡例を表示
凡例を非表示
△：勉強中 ▲：把握した
自動記憶域管理(ASM)
[△] ASMのアーキテクチャの理解
[ ] ASMインスタンスの管理
[ ]...
http://download.oracle.com/docs/cd/B19306_01/em.102/b40103/getting_started_with_enterprise_manager.htm#CHDDGHAF
http://download.oracle.com/docs/cd/B19306_01/em.102/b40103/getting_started_with_enterprise_manager.htm#CIHFFBBB
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/scheduse.htm#sthref3530
http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/sizing.htm
http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/repository.htm#sthref778
SQL>@?/$ORACLE_HOME/rdbms/admin/dbmspool.sql
alter system set session_cached_cursors=200 scope=spfile;
alter system set aq_tm_processes=1 scope=spfile;
Dispatchers set to 0...
http://download.oracle.com/docs/cd/B19306_01/em.102/b40103/installing_enterprise_manager.htm#sthref220
SQL>@?/$ORACLE_HOME/rdbms/admin/dbmspool.sql
alter system set session_cached_cursors=200...
If this is your first site
Then there are some things you need to know:
You can configure all security and other settings online, using the Site Manager. When you invite other people to help build...
If you are allowed to edit pages in this Site, simply click on edit button at the bottom of the page. This will open an editor with a toolbar pallette with options.
To create a link to a new page,...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#CIACJGDI
control_files = (/u0d/lcg03/control.001.dbf,...
EBS:R12.1.1
OS:Enterprise Linux 4 Update7
GL_BUDGET_INTERFACE
Self Study Memo
Assignment Objectives
Section 1: The Servlet Technology Model
For each of the HTTP Methods (such as GET, POST, HEAD, and so on) describe the purpose of the method and the technical...
Please change this page according to your policy (configure first using Site Manager) and remove this note.
Who can join?
You can write here who can become a member of this site.
Join!
So you...
JasonさんのDBAメモ
Yangさんの技術サイト
YuanYuanさんの技術サイト
たんちゃんの技術サイト
mount shared folder from windows
mount -t smbfs -o username=user,password=pass //ipaddr/\sharedfolder /mnt/mountpoint
query rpm package information
rpm -q...
LISTENER_PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = atom04-10g)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = atom04-10g)(PORT = 1621))
)
)
PROD =
(DESCRIPTION =
(ADDRESS =...
201試験： 出題範囲の詳細
202試験： 出題範囲の詳細
lsnrctl status
lsnrctl status listener2
lsnrctl stop listener2
lsnrctl start listener2
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/partiti.htm#sthref2700
ALTER TABLE sales
ADD PARTITION jan96 VALUES LESS THAN ( '01-FEB-1999' )
TABLESPACE tsx;
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/partiti.htm#sthref2628
CREATE INDEX loc_dept_ix ON dept(deptno) LOCAL;
CREATE INDEX hgidx ON tab (c1,c2,c3) GLOBAL
PARTITION...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i53187
...
Oracle EBS R12 Applications Database Administrator Certified Professionalを気になって勉強してみようと思っています。
J.Testの受験を準備しておきたいかなと考えています。
Oracle Database 11g Certified Master Upgrade...
サイトガイド
ニュース
当サイトは個人勉強メモです。
勉強内容は皆さんと共有致します。
2009/11/26 当サイトにGoogle...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/partiti.htm#sthref2610
1 Creating a Range Partitioned Table
CREATE TABLE sales
( invoice_no NUMBER,
sale_year INT NOT...
Database Administration
Availability
Automatic Block Repair
New SET NEWNAME Clauses and Format Options
SET NEWNAME FOR TABLESPACE <tsname> TO <format>;
SET NEWNAME FOR DATABASE TO...
Stop and Start the middle tier
Deploying Web Application
Troubleshooting
Cluster Verification Utility
rpm -q --queryformat="%{NAME}-%{VERSION}-%{ARCH}\n" setarch
[root@OCM RPMS]# cat /etc/hosts
# Do not remove the following line, or various...
受験前提条件
試験環境について
試験環境公式ページ
試験内容公式ページ
テスト内容チェックリスト
Database, RMAN, EM and Network Configuration
[ ] Configure...
Oracle Applications Release 12 utilizes three Oracle homes:
Oracle 10g Release 2 RDBMS ORACLE_HOME:
Used by the Oracle database server
Application Server 10.1.2 ORACLE_HOME:
Known as the Tools, C,...
In and Exists
rman snippet
rman Backup&Restore
RMAN Clone Instance
PX Deq Credit:send blkd
SELECT t.SQL_TEXT
FROM V$SESSION s, V$SQLAREA t, V$STREAMS_APPLY_SERVER a
WHERE a.APPLY_NAME =...
Oracle Workflow provides an infrastructure for communication of data between products, to:
Manage enterprise business processes
Support standard and personalized business rules
Streamline and...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19224-02/partiti.htm#463154
レンジ・パーティション化
ハッシュ・パーティション化
リスト・パーティション化
レンジ-ハッシュ・コンポジット・パーティション化
レンジ-リスト・コンポジット・パーティション化
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/indexes.htm#sthref396
CREATE INDEX emp_ix ON emp(deptno)
LOCAL STORE IN (ts7, ts8, ts9);
CREATE INDEX month_ix ON...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i49320
mailto:WilliamZhao1979@hotmail.com
Just a few days ago a got to two Oracle DBAs discussing why the have so much “PX Deq Credit : send blkd” on a system. And if that is causing their performance problems.
The are some blog on the...
http://forums.oracle.com/forums/thread.jspa?threadID=499495
Actually, these packages are already there in the OS but the higher versions. It is evident from the above messages that first it...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/backup.102/B19193-02/rpfbdb.htm#2933
alter system set db_recovery_file_dest_size=2G scope=both;
alter system set...
http://www.eygle.com/faq/How.To.Backup.and.Recreate.Controlfile.htm
alter database backup controlfile to trace
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS ARCHIVELOG...
BEGIN
dbms_resource_manager.clear_pending_area();
dbms_resource_manager.create_pending_area();
dbms_resource_manager.create_consumer_group(consumer_group => 'oltp', comment => 'oltp',...
...
backup database plus archivelog delete all input
backup as compressed backupset database plus archivelog delete all input
backup.rman
run {
crosscheck archivelog all;
allocate channel t1 type disk;
backup
full
tag hot_db_bk_full
filesperset 10
format '/u03/oradata/atom/rman/current/bk_%U.bkp'
(database);
sql 'alter...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/backup.102/B19192-03/rcmcatdb.htm#i1011365
create tablespace rman
datafile '/u02/oradata/ybb/rman.dbf' size 50m autoextend on...
Rman Clone Instance in Linux
Step1
orapwd file=/u01/oracle/app/oracle/product/10.2.0/db_1/dbs/pwdsid.ora password=oracle entries=5
Step2
export ORACLE_SID=sid
sqlplus "/ as sysdba"
startup...
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO...
startup mount
restore database;
recover database;
Backup Flash Recovery Area
rman>backup recovery files;
<html>
<!--
[[=]]
[[module Search button="new page"]]
[[/=]]
-->
<form action="http://www.google.com/cse" id="cse-search-box">
<div>
<input type="hidden"...
http://www.oracle.com/technology/obe/obe10gdb/security/approles/approles.htm
1
connect system/oracle
drop role ots_role;
create role ots_role IDENTIFIED USING sec_roles;
2
connect oe/oe
grant...
Important Point
Develop Custom Tag Library
JSTL&EL
Web Security
Filter
You need to understand these points when using filters:
There is one filter per <filter> entry in the web.xml...
http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/tdppt_realtime.htm#CHDJEGHG
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#05_01
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19217-02/usingpe.htm#sthref2322
ALTER TABLE orders PARALLEL 4;
ALTER INDEX iorders PARALLEL 4;
SELECT /*+...
$ vi $ORACLE_HOME/sqlplus/admin/glogin.sql
登陆sqlplus后会自动执行
$ vi ~/login.sql
登陆sqlplus后会自动执行
$ vi ~/.login.sql
登陆sqlplus后得手工执行
define _editor=vi
set...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19217-02/usingpe.htm#i1007196
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/network.102/B19208-02/dispatcher.htm#342761
alter system set dispatchers='(PROTOCOL=TCP)...
当サイトは個人勉強メモです。
勉強内容は皆さんと共有致します。
Members:
Moderators
Admins
2009/11/26 当サイトにGoogle Analytics機能を付けました。
2009/10/12 当サイトにGoogle AdSense機能を付けました。
2009/10/12 Welcomeページはoracle-abcのように改造しました。
2009/10/12 Oracle英文公式サイトがリニューアルされました。簡素化された気がします。
DECLARE
taskname varchar2(30);
task_desc varchar2(256);
task_or_template varchar2(30);
task_id number;
wkld_name varchar2(30);
saved_rows number;
failed_rows number;
num_found...
date mask
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_field_list.htm#i1016161
Specifying Field...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19211-01/toc.html
http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/tdppt_sqlid.htm#BJEEHAEC
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9010.htm#SQLRF01601
SQL>...
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19277-01/ch12.html#25409
Set Enviroment Variable
http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/tdppt_sqltune.htm#CAEFFIEE
1. Use OPMN to stop all processes:
$ORACLE_HOME/opmn/bin/opmnctl stopall
2. Use emctl to stop the Application Server Console:
$ORACLE_HOME/bin/emctl stop iasconsole
3. Use OPMN to start all...
1. Use OPMN to stop all processes:
$ORACLE_HOME/opmn/bin/opmnctl stopall
2. Use emctl to stop the Application Server Console:
$ORACLE_HOME/bin/emctl stop iasconsole
Stream Troubleshooting
Summary
SELECT CAPTURE_NAME, STATUS_CHANGE_TIME, ERROR_NUMBER, ERROR_MESSAGE
FROM DBA_CAPTURE WHERE STATUS='ABORTED';
@?/demo/schema/mkplug.sql
select * from...
...
# Is the Capture Process Enabled?
SELECT CAPTURE_NAME, STATUS_CHANGE_TIME, ERROR_NUMBER, ERROR_MESSAGE
FROM DBA_CAPTURE;
select capture_name,queue_name,status,captured_scn,applied_scn from...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/et_params.htm#i1009506
Each business event that has accounting impact is called an accounting event.
Receivables Accounting Event Model
An accounting event is a business event in Oracle Receivables that has...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/role_management.htm#i1026464
http://www.dbasupport.com/forums/showthread.php?p=256729
SQL> COLUMN NAME FORMAT A18
SQL> COLUMN...
Oracle
OCM
Scripts
Linux
Command
contact
1
execute dbms_tts.transport_set_check('example',true);
SELECT * FROM TRANSPORT_SET_VIOLATIONS;
2
expdp system/oracle dumpfile=expdat.dmp directory=data_pump_dir...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/usingpe.htm#i1009828
http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/tdppt_sqltune.htm#CAEBFCFJ
1800second(1hour)に設定する
alter system set undo_retention=1800 scope=both;
NAME TYPE VALUE
------------------------------------ -----------...
link
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/statspac.htm#34837
create tablespace perfstat
datafile '/u02/oradata/PROD/perfstat.dbf' size 100m autoextend on maxsize...
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/naming.htm#sthref783
CONNECT username/password@[//]host[:port][/service_name]
sqlplus system/pwd@host:1521/PROD
According to Wikipedia, the world largest wiki site:
A Wiki ([ˈwiː.kiː] <wee-kee> or [ˈwɪ.kiː] <wick-ey>) is a type of website that allows users to add, remove, or otherwise edit...
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i49320
http://arjudba.blogspot.com/2008/05/about-pgaaggregatetarget-parameter.html
• PGA_AGGREGATE_TARGET specifies the...
[*] External Table
[*] Materialized View
[*] SQL Loader
[*] LOB
[*] Flashback Drop
[*] Flashback Database
ORACLE MASTER Platinum Oracle Database 10g(OCM) 実技試験
3～4年間 Oracle の専門家として企業レベルのデータベース管理者経験を有していること。
http://bokimasa.blog110.fc2.com/
ORACLE MASTER Platinum Oracle Database 10g(OCM) 実技試験 (2007/7/1～）
Oracle Database 10g Rel. 2 (10.2.0.2)
Oracle Enterprise Manager Rel. 2 (10.2.0.1)
Oracle Database 10g Rel. 2 (10.2.0.1)...
