51CTO博客开发卓越始于足下抚琴煮酒
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 (NUMTOYMINTERV
只对部分行建立索引 创建大表: create table t_big (id int,flag varchar2(5)); begin for j in 0..100 loop for i in 0..10000 loop execute immediate 'insert into t_big(id) values(:1) ' using i; end loo
--某网友给的建议 1.熟悉执行计划的各种操作,会看懂执行计划 2.熟悉表的数据分布,索引,分区等对执行计划的影响 3.熟悉各种SQL语句的写法,能等价改写各种SQL 4.能够利用业务特点改写和设计SQL 5.能利用ORACLE提供的各种工具,比如sql trace,dbms_xplan,sql tuning advisor,spm等优化sql 推荐书籍: 1. o
17.The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numto
16.Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECT
15.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery
14.Which two statements are true regarding hot patching? (Choose two.) A. It requires relinking of the Oracle binary. B. It does not require database instance shutdown. C. It can detect confli
12.You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the
10.Consider the following scenario for your database: -Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most recent backup to disk for the TOOLS tablespac
8.Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs? A. It cannot be done in parallel. B. It can be done at the table level or partition
7.You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which
6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog sch
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 Che
4.Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure Answer:
3.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA
2.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideratio
1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements desc
第一次收到备案变更通知邮件,当时没在意,第二次收到邮件时通知备案信息已被回收,域名直接不能访问.不折腾了,还是仍然放到51CTO上面来.可惜了前段时间写的一些日志,不想去导入了.
1、nginx编译参数: your_nginx_dir/sbin/nginx -v 2、apache编译参数: cat your_apache_dir/build/config.nice 3、php编译参数: your_php_dir/bin/php -i |grep configure 4、mysql编译参数: cat your_mysql_dir/bin/mysqlbug |gre
朋友手上一lenovo E42A 的笔记本,屏轴断了一根,今天去电脑市场修,没有熟人,直接到宏图三胞,技术人员看后说修修要280,当时也不清楚只是换一下屏轴,总以为要将整个底座都要换,也没想着讲价,就这么稀里糊涂就同意维修了,结果他们在拆机后,将要更换的部件拿出来后,才发现,太坑了,成本最多就50元的一对屏轴,硬敢开价280。只能说他们那拆笔记本的技术太值钱了,我日,下次一定先了解清
今天帮开发更新文件,使用 scp 从一台机器更新到另一机器,更新时包含了目录,结果悲剧的搞错了。 具体情况如下: A是开发服务器,B是正式服务器。现在由A上更新 /a/ 目录下的的b文件夹到B上的 /a/ 目录下。我先在B上新建文件夹b,然后直接在B上执行以下命令: scp -r user@A_ip:/a/b/ /a/b/ 结果,很意外的
Last Update: 2011-12-18ifconfig发现机器有很多错误包,如下:eth1 Link encap:Ethernet HWaddr 00:1e:67:07:ef:25 inet addr:192.168.0.146 Bcast:19
分布式部署应用软件,可批量通过ssh管理主机,修改配置。安装参考:http://www.linuxweblog.com/install-python-fabric-Centos通过安装页面安装好该软件,提供简单示例批量修改密码:hosts.cfg.sh#! /bin/bashexport ALL_HOSTS=192.168.200.139,192.168.200.140install.py#!/u
要给hadoop集群安装软件,发现从163下载还是比较的慢,直接 导致我批量安装部署软件等待时间过长,本想搭建本地的Debian源,后来发现,我主要就是为了apt-get安装些软件,如果下载debian源,光 64位的,就达到66G之多,最后找到这个个软件,还可直接给centos缓存,非常不错。这软件的作用就是当服务器上没有那软件的缓存,第一次安装会从163源下载,下一次就直接从缓存里面取。所以,
现象: asterisk1.4与asterisk1.6通过IAX2双机互联后,用1.4上分机拨打1.6上分机,1.4的cli提示: Everyone is busy/congested at this time (1:0/0/1) 1.6上分机可以呼叫1.4上分机,但1.4上分机呼叫1.6上分机不通.且在1.6上cli里面没有错误提示,只能在1.4上的cli里面查看到上述错误信息
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号