- 博客(17)
- 资源 (3)
- 问答 (1)
- 收藏
- 关注
翻译 dba_segments各字段的含义
字段说明SEGMENT_TYPE:段的类型,可能是table,index,logindex,lobsegment等。header_file:表示这个段的头在哪个数据文件里,因为段可以跨数据文件。header_block:表示这个段的头在数据文件的第几个block里。bytes:段的大小(目前占用的大小?)blocks:段占用了多少个blockextents:分配了多少个extent。
2014-07-27 21:29:35 5380
转载 PLSQL Developer win7 64位 安装方法
文章l安装Oracle 11g 64位 安装32位的Oracle客户端( instantclient-basic-win32-11.2.0.1.0)。Win7 64位系统暂无PLSQLDeveloper,所以下一个32位的。 下载instantclient-basic-win32-11.2.0.1.0.zip (一定得是32位的,不要下错
2014-07-27 21:18:00 687
原创 表空间利用率
SQL> select sum(bytes/1024/1024) from dba_data_files 2 where TABLESPACE_NAME='APP_SZYTH';SUM(BYTES/1024/1024)-------------------- 200317.891SQL> select sum(bytes/1024/102
2014-07-15 13:38:46 685
原创 通过network_link导出含有long字段的表
查看数据库中的含long字段的表:SQL> select table_name from dba_tab_columns where data_type='LONG' and owner='PHSI';TABLE_NAME---------------PLAN_TABLEQUEST_SL_TEMP_EXPLAIN1SMP_LONG_TEXTSMP_LONG_TEXT_
2014-07-15 10:35:27 1445
原创 133. Which three statements are true? (Choose three.)
133. Which three statements are true? (Choose three.) A. Only one LONG column can be used per table. B. A TIMESTAMP data type column stores only time values with fractional seconds. C. The BLO
2014-07-13 18:26:44 858
原创 single-row functions
130. Which three statements are true regarding single-row functions? (Choose three.) A. They can accept only one argument. B. They can be nested up to only two levels. C. They can return multi
2014-07-13 17:03:55 1245
原创 group functions
129. Which three statements are true regarding group functions?(Choose three.) A. They can be used on columns or expressions. B. They can be passed as an argument to another group function.C.
2014-07-13 16:33:58 675
原创 kill session
An active session cannot be interrupted whenit is performing network I/O or rolling back a transaction. Such a session cannot beterminated until the operation completes. In this case, the session
2014-07-13 11:17:11 537
转载 判断oracle连接是专用模式/共享模式方法(dedicated/shared)
文章来自:http://blog.chinaunix.net/uid-22539324-id-2644082.html
2014-07-12 10:13:46 1336
转载 ocp-043
52、You have a read-only tablespace on read-only media. You want to perform. a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the s
2014-07-10 22:19:55 556
转载 oracle 10.2.0.1升级到10.2.0.4
Oracle 10g R2 安装配置Oracle 10.2.0.4 Patch Set for Windows 32BIT升级步骤升级测试环境:服务器:P4 3.0 1G RAM操作系统:Windows 2003 Server EE SP2 32BIT数据库:Oracle 10.2.0.1升级补丁包:Oracle 10.2.0.4(Oracle 10g R2 Patch S
2014-07-08 14:22:44 677
转载 使用expdp导出时评估所需存储容量大小
我们在使用expdp进行数据导出时,可以事先评估需要存储大小容量(bytes),Oracle可以通过两种方式进行容量估算:[@more@]1)、通过数据块数量2)、通过统计信息中记录的内容估算具体是通过制定参数estimate_only和estimate来评估导出的性能参数estimate_only=y|n 指定是否仅作评估不会导出数据参数estimate=st
2014-07-08 10:02:14 1652
转载 ocp-047 delete
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table where in it is crea
2014-07-07 20:32:13 827
转载 ocp-047 natural-join
89. View the Exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.To retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME,the following
2014-07-07 20:00:08 625
转载 ocp-043 Flashback Drop feature
14. Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)A.Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.B.You can fla
2014-07-06 21:28:45 549
原创 impdp中遇到的两个问题
impdpProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name "DW01" prematurely terminatedORA-31672:
2014-07-06 15:06:27 5697
原创 自然连接 natural join
74. View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANTITY), wher
2014-07-02 10:23:42 735
oracle 11.2.0.1升级到11.2.0.4
2015-02-05
TA创建的收藏夹 TA关注的收藏夹
TA关注的人