自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(814)
  • 收藏
  • 关注

转载 Docker中离线配置python环境

----------------------------------------------------------环境纯净centos7镜像离线安装rpm包下载地址https://pkgs.org/download----------------------------------------------------------各种命令不能使用就直接下载rpm安装----------...

2018-12-28 16:06:00 298

转载 k8s使用经验

为了管理不同节点的docker容器,需要使用编排容器的工具。这里使用k8s k8s docker集群搭建https://blog.csdn.net/real_myth/article/details/78719244rpm包下载地址https://pkgs.org/download----------------------------------------------------...

2018-12-28 15:36:00 151

转载 Docker使用经验_安装配置

内网安装参考离线安装https://www.e-learn.cn/content/java/451760https://www.2cto.com/kf/201809/778643.html--------------------------------------------------------安装包列表 libtool-ltdl-2.4.2-22.el7_3.x86_64.rpm...

2018-12-28 14:58:00 115

转载 Redis安装使用

为scrapy-redis学习一下配置redis tar xzf redis-5.0.0.tar.gz cd redis-5.0.0 make PREFIX=/user/redis install mkdir /user/redis cp redis-server /user/redis cp redis-benchmark /user/redis cp redis-cli...

2018-12-28 14:33:00 67

转载 MongoDB配置教程

MongoDB是一个面向文档的非关系型数据库教程 http://www.runoob.com/mongodb/mongodb-tutorial.html https://www.cnblogs.com/mfmdaoyou/p/7121547.html1.配置环境变量将解压目录加入PATH中2.启动服务mongod --dbpath D:\MongoDB\Data --bind_ip 端口...

2018-12-28 14:28:00 67

转载 oracle18c相关

oracle 18c 新特性 https://blog.csdn.net/zhengcaihua0/article/details/79575133 Oracle Database 18c 的10大新特性一览 http://www.dataguru.cn/article-12241-1.html oracle18c&&12c新特性之alter system can...

2018-12-28 14:23:00 52

转载 VBS编辑文件夹下所有excel文档

Function newExcel(fPath) Dim x1sApp,xlsWorkBook,xlsSheet,xlsSheet1,xlsSheet2,x1sAppB,xlsWorkBookB,xlsSheetB Set x1sApp = CreateObject("Excel.Application") Set xlsWorkBook = x1sApp.Workbook...

2018-10-15 14:19:00 142

转载 oracle新增主键

create or replace function func_nextid(i_tab in varchar2,i_column in varchar2) return number as v_no number(10); v_tab varchar2(100); v_sql varchar2(4000); begin v_sql:='SELECT NVL(MA...

2018-07-02 10:07:00 91

转载 sqlldr加载字符问题

CTL文件 load data CHARACTERSET UTF-8 infile "F:\dmp\sqlldr\t_user.txt" append into table T_USER fields terminated by '|' trailing nullcols ( ID, NAME, AGE ) sqll...

2018-06-27 13:33:00 152

转载 ora-00257

ORA-00257归档日志写满的解决方法 这个错误是归档满了,首先查看一下归档使用情况。 select * from v$recovery_file_dest;    select * from v$flash_recovery_area_usage; 加起来99.7%了这时只能删除日志了 rman target sys/pwd@orcl cro...

2018-06-27 11:02:00 145

转载 百度数据开发面试题

事后HR回邮件被刷,总结下面试经历。面试比较全面,主要是oracle的sql开发,博主傻傻的把数据结构和各种算法看了一上午,下午去完全没问。话说面试大叔记忆力真的好,啥都记得清清楚楚的。 一、Oracle开发1.取差集not in、not exists不去重(not in() 中有null值则查询结果为空)minus去重集合操作符总结(UNION:由每一个查询 选择的 全部不反复的行组...

2018-06-25 14:20:00 233

转载 java8 Consumer

@FunctionalInterface public interface Consumer<T> { /** * Performs this operation on the given argument. * * @param t the input argument */ void accep...

2018-06-13 17:36:00 74

转载 javax.el.PropertyNotFoundException: Property 'Email' not found···

1.有空格 javax.el.PropertyNotFoundException: Property 'name' not found on type java.lang.String 在jstl标签属性中的""中间不能有空格,真实死都不知道怎么死的。 原:<c:forEach items="${userlist} " var="user"> 把"${use...

2018-05-23 18:08:00 126

转载 informatica导出整个目录

参考http://blog.itpub.net/62592/viewspace-1022477/ 1.首先找到地址信息http://IP:端口/adminconsole/这里替换成自己的地址http://localhost:8443/adminconsole/ 选中Repository后,在Actions下选择Back Up Contents,按照界面提示进行备份。 2.使用pmr...

2018-05-16 11:00:00 263

转载 Backup database plus archivelog delete input;

Backup database plus archivelog会备份归档日志Backup database plus archivelog delete input;会备份归档日志并且会在备份结束后删除默认目录下的归档日志、datafile copy还有backup set。适用于单个归档dest路径如FRA。Backup database plus archivelog delete...

2018-04-19 12:18:00 266

转载 oracle查询日期列表

--月份 SELECT TO_CHAR(ADD_MONTHS(SYSDATE, - (ROWNUM - 1)), 'yyyy-mm') yyyymmdd FROM DUAL CONNECT BY ROWNUM < MONTHS_BETWEEN(SYSDATE, TO_DATE ('201711', 'yyyymm'))+1 --天 select to_char(sysd...

2018-03-23 10:07:00 91

转载 oracle建立不同块大小的表空间

实验: Specifying Nonstandard Block Sizes for TablespacesDB_nK_CACHE_SIZE DB_BLOCK_SIZE ALTER SYSTEM set DB_CACHE_SIZE = 8M scope=BOTH; ALTER SYSTEM set DB_16K_CACHE_SIZE =4M scope=BOTH; ...

2018-03-22 18:18:00 207

转载 052-251(新增70题2018)

Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)A. It is possible to have tablespaces of different block sizes in a database.B. A data block...

2018-03-22 16:49:00 65

转载 052-250(新增70题2018)

Which three statements are true about the stages of database startup? (Choose three.) A. Data files and redo log files can be renamed at the MOUNT stage. B. Control files are required to bring ...

2018-03-22 16:29:00 67

转载 052-249(新增70题2018)

Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)A. renaming of control filesB. multiplexing of control filesC. dropping the database userD. con...

2018-03-22 16:13:00 41

转载 052-248(新增70题2018)

You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct regarding the connection string? (Choose three...

2018-03-22 15:53:00 76

转载 052-247(新增70题2018)

You have been recently hired as a database administrator. Your senior manager asks you to study the production database serverand submit a report on the settings done by the previous DB A. Whil...

2018-03-22 15:32:00 60

转载 052-246(新增70题2018)

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line...

2018-03-22 15:19:00 58

转载 052-245(新增70题2018)

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shutdown before synchronizing all the database files. Which two s...

2018-03-22 15:13:00 56

转载 052-244(新增70题2018)

One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it? A. uses undo data for roll forward B. uses Flashback Log for reco...

2018-03-22 15:05:00 51

转载 052-243(新增70题2018)

Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30minutes and the collection level is set to Typical i...

2018-03-22 14:56:00 56

转载 052-242(新增70题2018)

You execute the following set of commands to create a database user and to grant the system privileges in your productionenvironment. SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT T...

2018-03-22 14:43:00 66

转载 052-241(新增70题2018)

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redologs are filled and database activity is halted. Database wr...

2018-03-22 14:41:00 48

转载 052-240(新增70题2018)

You are using the following command to clear the log file group:ALTER DATABASE CLEAR LOGFILE GROUP 2;In which case would the command be successful?A. Group 2 is the active group.B. Group 2 is the...

2018-03-22 14:37:00 46

转载 052-239(新增70题2018)

You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added afew tablespaces, and dropped a couple of tablespaces. This morn...

2018-03-22 14:29:00 42

转载 052-238(新增70题2018)

QUESTION 238 In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows ofthe ORDERS table. Because of the configuration, the ...

2018-03-22 14:00:00 68

转载 052-237(新增70题2018)

Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available,...

2018-03-22 13:48:00 52

转载 052-236(新增70题2018)

The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writingof queries. These views are stored in _____. A. user table...

2018-03-22 11:31:00 50

转载 052-235(新增70题2018)

You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listenerprocess, you get the following error message: LSNRCTL> start L1 St...

2018-03-22 10:58:00 53

转载 052-234(新增70题2018)

In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be resetto sequence number 1. You want to avoid the overwriting of old log f...

2018-03-22 10:53:00 46

转载 052-233(新增70题2018)

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario? A. The operation would fail if t...

2018-03-22 10:29:00 58

转载 052-232(新增70题2018)

The following are the details of your database: Instance name : test Host name : tech1.us.oracle.com IP address : 145.33.230.186 Enterprise Manager Console HTTP Port number : 5500 You starte...

2018-03-22 10:21:00 64

转载 052-231(新增70题2018)

You find today's performance of your production database to be the best ever. Therefore, you want to be notified in the futurewhenever the performance degrades by 10% of today's performance. Wh...

2018-03-22 10:13:00 66

转载 052-230(新增70题2018)

Your application demands frequent connection and disconnection from the database. You have three listener processes that arelistening for the database PROD. While setting up the connect string ...

2018-03-22 10:04:00 68

转载 052-229(新增70题2018)

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In theprocess of defragmentation you lose the redo log member, which...

2018-03-22 09:32:00 52

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除