- 博客(50)
- 资源 (2)
- 问答 (3)
- 收藏
- 关注
RSS订阅转载 linux ls -l命令详解
转自http://hi.baidu.com/yzzcheng/item/1a2141878447891dc31627f5以root的家目录为例:可以看到，用ls -l命令查看某一个目录会得到一个7个字段的列表。第1行:总计(total)Total后面的数字是指当前目录下所有文件所占用的空间总和。可以使用ls –lh查看，也可使用ls –alh
2015-11-04 15:49:11
1285
翻译 14.4 Using Index-Organized Tables forPerformance 使用索引组织的表
原文：An index-organized table differs from an ordinarytable in that the data for the table is held in its associated index. Changesto the table data, such as adding new rows, updating rows, or deleting rows,result only in updating the index. 译文：索引组织的表与普通
2015-10-26 17:46:18
560
翻译 14.3 Using Partitioned Indexes for Performance 使用分区索引
原文：Similar to partitioned tables, partitioned indexesimprove manageability, availability, performance, and scalability. They caneither be partitioned independently (global indexes) or automaticall
2015-10-26 12:13:51
555
翻译 14.2 Using Function-based Indexes for Performance 使用基于函数的索引
原文：A function-based index includescolumns that are either transformed by a function, such as the UPPER function, or included in an expression, such as col1 +col2. With afunction-based index, you
2015-10-26 12:10:49
569
原创 sublime 编辑器安装
1、从官网下载安装，官网地址：http://www.sublimetext.com/2、安装完成后再装个Package Control(包管理器)，用来方便以后插件的安装 Package Control安装地址：https://packagecontrol.io/installation，这个地址上已经说明了安装方法，比较简单3、Package Control安装完后就可以通
2015-10-21 17:40:09
404
原创 Redis学习笔记
基本介绍使用键值对（key-value）形式存储数据数据类型：String,List,Set,Zset为了保证效率，数据都是缓存在内存中，也可以周期性的把更新的数据写入磁盘或者把修改操作写入到追加的记录文件适用场合（新浪微博）：应用程序直接访问Redis数据库应用程序直接访问Redis，只有当Redis访问失败时候才访问MYSQL启动Re
2015-10-19 12:02:10
383
转载 oracle lead()和lag()
这两个函数，是偏移量函数，其用途是：可以查出同一字段下一个值或上一个值，并作为新列存在表中。1。 select * from tache_columns TCH_ID COL_NAME_CN COL_VALUE------------- -----------
2015-09-10 16:16:48
414
转载 mysql replication架构
前言MySQLReplicaion本身是一个比较简单的架构，就是一台MySQL服务器（Slave）从另一台MySQL服务器（Master）进行日志的复制然后再解析日志并应用到自身。一个复制环境仅仅只需要两台运行有MySQLServer的主机即可，甚至更为简单的时候我们可以在同一台物理服务器主机上面启动两个mysqldinstance，一个作为Master而另一个作为Slave来完成复制环境
2015-09-09 15:39:27
376
转载 使用MyBatis-Generator自动生成代码
一、MyBatis-Generator介绍二、MyBatis-Generator配置（1）检查是否安装MyBatis-Generator插件1.1 MyEclipse下检查是否安装1.2 Eclipse下检查是否安装（2）安装MyBatis-Generator插件2.1 离线安装MyBatis-Generator插件2.2 MyEclipse在线安装MyBatis-Ge
2015-09-07 11:59:00
1190
转载 Spring4整合Junit4 测试
Spring 提供便捷的测试，非常方便整合Junit导入 spring-test-3.2.0.RELEASE.jar ---- 提供与Junit的整合 @RunWith(SpringJUnit4ClassRunner.class) // 整合 @ContextConfiguration(locations="classpath:applicationContext.xml") /
2015-09-06 11:33:19
841
转载 AWR报告分析
今晚来分析一下awr报告，首先说一下什么是awr报告，它能给我们带来什么。* 定义：awr报告是oracle 10g下提供的一种性能收集和分析工具，它能提供一个时间段内整个系统资源使用情况的报告，通过这个报告，我们就可以了解一个系统的整个运行情况，这就像一个人全面的体检报告。如何分析：* 在看awr报告的时候，我们并不需要知道所有性能指标的含义，就可以判断出问题的所在，这些
2015-09-02 10:59:36
571
转载 synchronized 关键字
synchronized 关键字，它包括两种用法：synchronized 方法和 synchronized 块。1. synchronized 方法：通过在方法声明中加入 synchronized关键字来声明 synchronized 方法。如：public synchronized void accessVal(int newVal);synchronized 方法控制对类
2015-08-28 14:47:16
320
翻译 14.1 Understanding Index Performance 了解索引性能
14.1.1 Tuning the Logical Structure（优化逻辑结构） 不管查询是否使用，SQL引擎必须继续维护一个表上定义的所有索引，在写操作比较频繁的应用中，索引维护工作可能会占用大量的CPU和I/O资源，所以，不要建立不必要的索引。为了最优化性能，删除不必要的索引。在你的数据库执行有代表性的工作量时，使用ALTER INDEX MO
2015-08-07 16:41:38
747
原创 053第42题
42.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL TuningSet as a part of the workload capturing. What information is captured as part of this process? (Choos
2015-07-23 11:42:51
761
原创 053第482
482.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want toconvert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Whic
2015-07-20 17:38:29
820
原创 053第18
8.You create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following command:SQL> SELECT dbms_addm.get_report('my_instan
2015-07-20 11:12:46
776
原创 053第502题
502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each grouphas one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In th
2015-07-19 11:19:38
673
原创 053第450题
450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNALAnswer: A
2015-07-18 13:18:39
683
原创 053第478题
478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Reposit
2015-07-18 13:07:32
826
原创 053第401题
401.Which of the following are correct about block media recovery? (Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B.
2015-07-18 12:15:58
1296
原创 053第484题
484.Which steps are mandatory to enable Direct NFS?1. Mount all required file systems using the kernel NFS driver.2. Create an oranfstab file containing the attributes for each NFS server to be ac
2015-07-18 11:48:27
1365
1
原创 053第256题
256.Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data isadded to the table daily. To save disk space, you issued the following command:ALTER TABLE sal
2015-07-17 20:38:23
649
原创 053第279题
279.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenancewindow? (Choose all that apply.)A. generating the SQL profileThe safer , easier way to help yo
2015-07-17 10:45:06
1369
原创 053第449题
449.Which of the following objects can be directly referenced by a window object? (Choose all that apply.)A. Schedule objectB. Program objectC. Job objectD. Resource planE. Resource consumer
2015-07-16 12:41:33
723
原创 053第5
5.Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :REA
2015-07-16 11:03:09
798
原创 053第244题
224.You need to create a partitioned table to store historical data and you issued the following command:CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL(NUMTOYMINTERVAL(1,'mon
2015-07-15 12:14:28
641
原创 053第455题
455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DR
2015-07-15 10:05:00
797
原创 053 第500题
500.You opened the encryption wallet and then issued the following command:SQL>CREATE TABLESPACE securespaceDATAFILE '/home/user/oradata/secure01.dbf'SIZE 150MENCRYPTION USING '3DES168'DEFAU
2015-07-14 12:14:02
1036
原创 053第423题
423.Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the resumable conditions for the entiredistribute
2015-07-14 11:03:10
968
原创 053 第561题
561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alter database archivelog?A. The alter databas
2015-07-14 10:35:04
902
原创 053第383题
383.At the request of a user, you issue the following command to restore a dropped table: flashback table"BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop; Later, the user notifies you that the data i
2015-07-14 10:26:24
1089
原创 053第425题
425.Which of the following are included in a transportable tablespace set? (Choose all that apply.)A. The datafiles that make up a self-contained group of tablespaces required for copyB. The syste
2015-07-13 13:16:33
824
原创 053第495题
495.Which statement is true regarding the VALIDATE DATABASE command?A. It checks the database for intrablock corruptions only.B. It checks for block corruption in the valid backups of the database
2015-07-13 12:59:16
1010
1
原创 053第521题
521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which ofthese are valid reasons why that might occur?A. The job priority is 1 and the resource consumer gro
2015-07-12 13:05:00
947
原创 053第246题
246.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates aplan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are
2015-07-12 12:34:34
917
原创 053第386题
386.You have just performed a FLASHBACK TABLE operation using the following command:flashback table employees to scn 123456;The employees table has triggers associated with it. Which of the follow
2015-07-11 13:26:50
1182
原创 053第170题
170.ASM supports all but which of the following file types? (Choose all that apply.)A. Database filesB. SpfilesC. Redo-log filesD. Archived log filesE. RMAN backup setsF. Password filesG
2015-07-10 11:04:32
551
原创 053第85题
85.You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct? (Choose two.)A. All the objects of scott are moved to t
2015-07-10 10:55:39
875
原创 053第471题
471.Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data dictionary tablesD. NCHAR columnsE. C
2015-07-09 10:54:28
556
原创 关于053 第66题
66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?(Choose two.)A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET
2015-07-06 10:57:29
545
oracle 体系结构详解
2015-06-30
TA创建的收藏夹 TA关注的收藏夹
TA关注的人