dieqiao8331-CSDN博客

转载 Docker中离线配置python环境

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

2018-12-28 16:06:00 784

转载 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 235

转载 Redis安装使用

为scrapy-redis学习一下配置redistar xzf redis-5.0.0.tar.gzcd redis-5.0.0make PREFIX=/user/redis installmkdir /user/rediscp redis-server /user/rediscp redis-benchmark /user/rediscp redis-cli...

2018-12-28 14:33:00 185

转载 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 172

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

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

2018-10-15 14:19:00 483

转载 oracle新增主键

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

2018-07-02 10:07:00 195

转载 sqlldr加载字符问题

CTL文件load dataCHARACTERSET UTF-8 infile "F:\dmp\sqlldr\t_user.txt" appendinto table T_USERfields terminated by '|'trailing nullcols( ID, NAME, AGE)sqll...

2018-06-27 13:33:00 301

转载 ora-00257

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

2018-06-27 11:02:00 145

转载 java8 Consumer

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

2018-06-13 17:36:00 175

转载 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 218

转载 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 419

转载 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 1186

转载 oracle查询日期列表

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

2018-03-23 10:07:00 392

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

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

2018-03-22 18:18:00 222

转载 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 77

转载 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 90

转载 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 113

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

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

2018-03-22 15:53:00 92

转载 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 DBA. Whil...

2018-03-22 15:32:00 73

转载 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 73

转载 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 118

转载 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 forwardB. uses Flashback Log for reco...

2018-03-22 15:05:00 63

转载 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 76

转载 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 user01IDENTIFIED BY oracleDEFAULT T...

2018-03-22 14:43:00 103

转载 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 86

转载 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 129

转载 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 80

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

QUESTION 238In 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 93

转载 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 91

转载 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 87

转载 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 L1St...

2018-03-22 10:58:00 91

转载 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 107

转载 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 93

转载 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 89

转载 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 100

转载 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 85

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

You decided to increase the value for the SHARED_SERVERS parameter by using the following command:SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;Which three values can be specified for the SCO...

2018-03-21 17:52:00 85

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

View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables.User A wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using following insert ...

2018-03-21 17:01:00 64

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

You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want toperform administrative tasks which include starting up and shutting down the d...

2018-03-21 16:57:00 99

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

You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database.Which type of script does the backup scheduler generate?A. SQL scriptB. PL/SQL scriptC....

2018-03-21 15:55:00 84

空空如也

空空如也