NAV: SLTechnology News&Howtos > Database >

• 

  ORACLE 12C installation

  Go to work more slowly, slowly update win2012R2+oracle12cr2 silent installation need to pay attention to the configuration, more options than 11G seems to have problems with template comments, silent configuration listening service for a long time

  2022-06-01 16:11:28 Views: 299
• 

  1Z0-051mi DDL-create synonyms and sequences

  Create synonyms and sequences 1. Synonyms (synonym) synonyms are alternative names for objects. It is divided into public synonyms and private synonyms. [create a public synonym] SQL > create public synonym emp for pb.em

  2022-06-01 16:11:26 Views: 243
• 

  Oracle index scan

  Index unique scan: it is for a large scan of a unique index. It is only applicable to the target SQL that is an equivalent query in the where condition. Because the scanned object is a unique index, only so many index blocks are scanned, and the result of the unique scan of the index returns at most one record, the index.

  2022-06-01 16:11:23 Views: 271
• 

  Unable to log in to the database after oracle installation

  Today, after silently installing the oracle11gr2 version and connecting to the database, the following occurs: [oracle@oracle response] $sqlplus / as sysdbaSQL*Plus: Release 1

  2022-06-01 16:11:23 Views: 270
• 

  HBase Rowkey design specification

  1.Rowkey is what can be understood as the primary key of the relational database MySQL Oracle, which is used to identify unique rows. Is entirely a string of non-repeating strings specified by the user. The data in HBase is always sorted according to the dictionary sort of Rowkey. 2.Ro

  2022-06-01 16:11:23 Views: 208
• 

  MongoDB startup script

  Today, when I studied mongodb, I found that the source package did not provide a startup script, so I wrote one that was easy to use. [root@controller mongodb] # cat / etc/init.d/mongodb #! / bin/b

  2022-06-01 16:11:22 Views: 238
• 

  Tuning RECORDS_PER_BLOCK parameters by case study

  Tuning through case study-the RECORDS_PER_BLOCK parameter RECORDS_PER_BLOCK parameter is used to set the maximum number of records in each BLOCK. It first finds the maximum number of rows contained in all BLOCK in the current table, and records this number.

  2022-06-01 16:11:22 Views: 274
• 

  Query whether the table space is automatically extended tablespace / auto

  Set pagesize 1000 TAC col tablespace_name for a 14x select d.tablespaceNamejemagol space "sum_space (m)", blocks s

  2022-06-01 16:11:22 Views: 281
• 

  JDBC database configuration question file

  Db.driver=com.mysql.jdbc.Driverdb.dialect=org.hibernate.dialect.MySQLDialectdb.maximumPoolSize=50db.

  2022-06-01 16:11:22 Views: 220
• 

  Linux install mongodb

  Wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.6.9.tgz decompresses tar xvf mongodb-linux-x86_64-2.

  2022-06-01 16:11:21 Views: 256
• 

  Core Theory and practice of MySQL Optimization

  Background description: friend unit OA system recently completed the upgrade and transformation, the back-end MySQL storage data, online for a month, complaining that phone calls began to come one after another, either here can not be opened, or there is no response, some people compare with the upgrade into an old car, more and more slowly, the problem is imminent

  2022-06-01 16:11:21 Views: 212
• 

  Oracle bubbling

  DECLARETYPE num_tt IS TABLE OF INT;num_t num_tt:=num_tt (); mid_val INT;BEGINnum_t.extend (20); FOR i IN

  2022-06-01 16:10:51 Views: 254
• 

  Principles of innobackupex backup and recovery

  Innobackupex full backup principle: 1. Execute checkpoint once to find the lsn2 of the last checkpoint. Record all generated redo log3.cp innodb data4.fl from this lsn

  2022-06-01 16:10:51 Views: 227
• 

  Detailed explanation of vCenter5.1 installation

  Background: at present, vSphere has launched the latest 6.5. however, in many production environments, the vSphere5.1 version is still used. This article will introduce the installation process of vCenter5.1 in detail. Implement step 1. Install .net framework3

  2022-06-01 16:10:51 Views: 226
• 

  Oracle lsnrctl

  1. Common commands 1. Lsnrctl commands if lsnrctl status cannot be executed, first of all, pay attention to whether you have switched to the oracle user and then go directly to the installation bin directory cd $ORACLE_HOME/bin./lsnrctl

  2022-06-01 16:10:45 Views: 246
• 

  Bounded Recovery description of GoldenGate

  First, let's look at two possible problems in OGG synchronization: the l oracle online log contains committed and uncommitted transactions, but OGG only writes committed transactions to the queue file. So, what will OGG do with uncommitted transactions, especially long ones?

  2022-06-01 16:10:36 Views: 228
• 

  Oracle Linux 6.8Setting local yum update source

  Unlike CentOS, Oracle Linux 6.8 update sources have synchronous update sources in China, ALIYUN and colleges and universities, and the updates are faster than others. Oracle Linux 6.8 if you want to update quickly, you need to install optical or ISO files to connect or COPY

  2022-06-01 16:10:36 Views: 215
• 

  Solutions to common errors in master-slave synchronization of MySQL 2

  The screenshot of the error is as follows: the error belongs to the SQL thread because the file path in relay- index.index and relay-log does not match. Solution: mysql > stop slave;mysql > reset

  2022-06-01 16:10:29 Views: 279
• 

  3.mongodb query

  MongoDB queries documents using the find () method. The find () method displays all documents in an unstructured way. The syntax format is as follows: db.collection.find (query, projection) query

  2022-06-01 16:10:29 Views: 224
• 

  Using DATABASE Log off to collect oracle wait event information

  Instance-level monitoring, always on and with low overhead: building basic tables: create table sys.sesstat_history tablespace EOL asSELECT c.username, c

  2022-06-01 16:10:26 Views: 236