select SID, SERIAL#, OPNAME, TARGET, SOFAR, --- SOFAR: ジョブ実行中に転送された数 TOTALWORK, --- TOTALWORK: ジョブ内の推定総数 UNITS, --- UNITS: sofarおよびtotalworkを表す単位 START_TIME, LAST_UPDATE_TIME, TIME_REMAINING, ELAPSED_SECONDS, --- ELAPSED_SECONDS 操作の開始からの経過時間 MESSAGE, USERNAME, SQL_ID from v$session_longops where USERNAME <> 'SYS' order by START_TIME;
select schema_name, occupant_name, occupant_desc, space_usage_kbytes/1024 as space_usage_mb from v$sysaux_occupants order by 4;
ALTER TABLE <テーブル名> MOVE PARTITION <パーティション名> TABLESPACE SYSAUX;
ALTER INDEX <インデックス名> REBUILD PARTITION <パーティション名> TABLESPACE SYSAUX;
SQL> set long 1000 SQL> set pages 1000 SQL> SELECT DBMS_METADATA.GET_DDL('TABLE', 'TEST_TABLE') from dual;
select o.object_name, count(*) blocks, decode(b.lru_flag, 0, 'mushi', 2, 'oidasi', 4, 'free', 8, 'kotei', b.lru_flag) as lru_flag from x$bh b left outer join dba_objects o on b.obj = o.object_id where o.owner = 'DEFRAG' group by o.object_name, b.lru_flag order by 1, 3;
sales.us.acme.com= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-server)(PORT=1521) (SEND_BUF_SIZE=11784) (RECV_BUF_SIZE=11784)) (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-server)(PORT=1521) (SEND_BUF_SIZE=11784) (RECV_BUF_SIZE=11784)) (CONNECT_DATA= (SERVICE_NAME=sales.us.acme.com))) hr.us.acme.com= (DESCRIPTION= (SEND_BUF_SIZE=11784) (RECV_BUF_SIZE=11784) (ADDRESS=(PROTOCOL=tcp)(HOST=hr1-server)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=hr.us.acme.com)))
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
SQL> @?/rdbms/admin/awrrpt.sql
select SNAP_ID from DBA_HIST_SNAPSHOT;
ALTER SYSTEM FLUSH SHARED_POOL;
ALTER SYSTEM FLUSH BUFFER_CACHE;
ALTER SYSTEM SET control_management_pack_access = "DIAGNOSTIC+TUNING" SCOPE=MEMORY SID='*'
SQL> startup restrict mount ORACLE instance started. Total System Global Area 4.0486E+10 bytes Fixed Size 2235216 bytes Variable Size 2.0133E+10 bytes Database Buffers 2.0267E+10 bytes Redo Buffers 84635648 bytes Database mounted. SQL> drop database; Database dropped. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
TESTDB:/home/oracle/app/oracle/product/11.2.0/dbhome_1:N
alter system set cluster_database=false scope=spfile;
SELECT OSUSER, MACHINE, SID, SERIAL# FROM V$SESSION WHERE SID IN ( SELECT SID FROM V$LOCK WHERE TYPE IN ('TM','TX') );
[oracle@dbserver dump]$imp PTEST/PTEST@RAC ignore=y file=test_tab.dmp tables=\(TEST_TABLE\) Import: Release 11.2.0.2.0 - Production on Thu Mar 22 21:49:09 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Tes Export file created by EXPORT:V11.02.00 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses WE8MSWIN1252 character set (possible charset conversion) . importing PTEST's objects into PTEST IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: -- ommit importing PTEST's objects into PTEST Import terminated successfully with warnings.
[oracle@dbserver dump]$imp PTEST/PTEST@RAC buffer=10485760 ignore=y file=test_tab.dmp tables=\(TEST_TABLE\) Import: Release 11.2.0.2.0 - Production on Thu Mar 22 21:53:17 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Tes Export file created by EXPORT:V11.02.00 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses WE8MSWIN1252 character set (possible charset conversion) . importing PTEST's objects into PTEST . importing PTEST's objects into PTEST . . importing partition "TEST_TABLE":"TEST_TABLE_P001" 72624 rows imported . . importing partition "TEST_TABLE":"TEST_TABLE_P002" 0 rows imported 〜〜 . . importing partition "TEST_TABLE":"TEST_TABLE_P109" 0 rows imported . . importing partition "TEST_TABLE":"TEST_TABLE_P110" 0 rows imported Import terminated successfully without warnings.
select TABLE_NAME,PARTITION_NAME, HIGH_VALUE from dba_tab_partitions;
SQL> select TABLE_NAME, PARTITIONING_TYPE, SUBPARTITIONING_TYPE, REF_PTN_CONSTRAINT_NAME from user_part_tables; TABLE_NAME PARTITION SUBPARTIT REF_PTN_CONSTRAINT_NAME ------------------------------ --------- --------- ------------------------------
セグメントのサイズ | エクステントのサイズ |
1MB以内 | 64KBずつ |
1MBより大きく、64MB以内 | c1MBずつ |
64MBより大きく、1GB以内 | 8MBずつ |
1GBよりも大きい | 64MB |
SQL> @$ORACLE_HOME/rdbms/admin/spcreate.sql
SQL>@$ORACLE_HOME/rdbms/admin/sppurge.sql
./runInstaller -silent -responseFile /path/to/your_response_file.rsp
Edit $oracle_archive/client/response/client_install.rsp
Set values for the variables listed below.
UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/home/oracle/oraInventory SELECTED_LANGUAGES=en,ja ORACLE_HOME=/home/oracle/app/product/11.2.0/client_1 ORACLE_BASE=/home/oracle/app oracle.install.client.installType=Administrator
〜省略〜 Interim patches (1) : Patch 12827726 : applied on Tue Nov 15 15:00:05 JST 2011 Unique Patch ID: 14016281 Created on 21 Sep 2011, 06:46:41 hrs PST8PDT Bugs fixed: 10158965, 10031806, 12635537, 9746210, 9744252, 9956713, 10356513 〜省略〜
Patch description: "Database Patch Set Update : 11.2.0.2.7 (13923804)" Created on 11 Jun 2012, 07:29:27 hrs PST8PDT Sub-patch 13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"
set timing on
このデータ型は NUMBER データ型のエイリアスであり、OracleDataReader が浮動小数点数値ではなく System.Decimal または OracleNumber を返すことを目的として用意されています。 .NET Framework データ型を使用することで、オーバーフローが発生する場合があります。