NAV: SLTechnology News&Howtos > Database >

• 

  Build materialized view and complete query rewrite,refresh function

  1. Create materialized view TEST8@ odb > create materialized view v_wuhua as select * from gaoshuiwei;create materialized

  2022-06-01 17:17:46 Views: 224
• 

  Construction and configuration of Data Guard physical standby Database in Oracle Database 11g

  Oracle Data Guard is a set of high availability database solution provided by Oracle company. Data Guard ensures high availability of enterprise data and enables data protection and disaster recovery. Data Guard provides a comprehensive set of creation

  2022-06-01 17:17:46 Views: 210
• 

  MySQL5.6 CREATE TABLE source code analysis

  Previous versions of MySQL5.6, DDL, were non-atomic. That is to say, for composite DDL, such as DROP TABLE T1, T2; if server crash is encountered during execution, it is possible that table T1 is dropped by DROP, but T2 is not

  2022-06-01 17:17:43 Views: 272
• 

  MySQL implicit type conversion causes index invalidation

  A problem was found today. There is an index on the column of the where condition, but the execution plan is still full table scan mysql > explain select task_id FROM mostop_xiaodai_collection_.

  2022-06-01 17:17:40 Views: 226
• 

  Left and right join of tables in oracle

  Select tp.technic_product_code,tp.technic_product_name,mp.marketproduct_code,mp.marketproduct_namefr

  2022-06-01 17:17:40 Views: 259
• 

  Import and export of relational database

  As a tool of data transmission, Sqoop acts as a bridge between Hadoop and traditional database, so how to import and export data in the end? First: use the MapReduce job to perform the import: (1) Sqoop first checks the table 1 to be imported

  2022-06-01 17:17:32 Views: 246
• 

  Big data MongoDB replication set Management

  MongoDB replication set MongoDB replication is the process of synchronizing data on multiple servers. Replication provides redundant backup of data, and stores copies of data on multiple servers, which improves the availability of data and ensures the security of data. Replication also allows you to learn from hardware failures and servers

  2022-06-01 17:17:29 Views: 230
• 

  Lamp+xcache completes the specified service

  (1) CentOS 7, apm+xcache, rpm package, php module;a) one virtual host provides phpMyAdmin, and the other virtual host provides wordpress;b) for phpMyAdmim

  2022-06-01 17:17:12 Views: 301
• 

  Awk command (2)

  1. The regular expression of awk. Common use of regular expressions [Amurz] one uppercase letter [amurz], one lowercase letter [0-9], one number [^ Amurz] in addition to uppercase letters [^ a-zA-Z] A non-English alphabet [^ a-zA-Z]

  2022-06-01 17:17:11 Views: 259
• 

  RHEL5.6 install WebLogic

  Linux version: RHEL5.6WebLogic version: 10.3.3.01. Build the JDK environment, where version 1.6 is installed # mkdir / app/jdk1.6.0_31/#vi / etc/profileexport

  2022-06-01 17:17:05 Views: 260
• 

  OGG synchronizes ORACLE data to KAFKA

  Environment: source side: oracle12.2 ogg for oracle 12.3 Target side: KAFKA ogg for bigdata 12.3 synchronize the data in oracle to KAFKA source side configuration through OGG: 1.

  2022-06-01 17:17:05 Views: 258
• 

  Mysql common operation commands

  # mysql common operation commands # 1. Install mysqlyum install mysql mysql-server/etc/init.d/mysqld start #

  2022-06-01 17:17:05 Views: 274
• 

  The OEM of Oracle cannot enter the problem properly.

  After installing the database, enable OEM. Emctl start dbconsole if there is a login problem, http://oracle11g:5500/em/console tries to rebuild oem first emctl stop dbco

  2022-06-01 17:17:05 Views: 219
• 

  How do I set the Oracle database to archive mode?

  Is the archiving mode really that important? For the Oracle database, must be set to archive mode, especially the production database, the only way to achieve effective full recovery of the database, for security, keep in mind. This is dangerous for some databases that may be in non-archive mode after they have just been installed. So what on earth?

  2022-06-01 17:16:49 Views: 288
• 

  AIX 7 installation 11.2.0.4 RAC- (hostname uppercase pit)

  When we install Oracle RAC, it is required that the hostname of the operating system should be lowercase, within 8 characters, and do not use an underscore, otherwise we will fail when configuring mutual trust verification, and there may be problems when configuring EMCC. AIX + 11G RAC

  2022-06-01 17:16:49 Views: 268
• 

  [MongoDB Learning Notes 6] in-depth creation / insertion of MongoDB (insert)

  Simple single document insertion using insert method: > db.post.insert ({"bar": "baz"}); WriteResult ({"nInserted": 1}) batch insertion, using insert method

  2022-06-01 17:16:49 Views: 247
• 

  Detailed explanation of MySQL performance analysis and tuning tools

  This article summarizes some tools used in the daily work of MySQL DBA, which are convenient for beginners and easy for themselves to consult. First introduce the tools for checking infrastructure (CPU, IO, network, etc.): vmstat, sar (sysstat toolkit), mpstat, opro

  2022-06-01 17:16:19 Views: 258
• 

  How to install MySQL 5.7 on CentOS 7.3

  Automatic installation of mysql 5.7based on centos 7. By the way, some of the defined parameters in my.cnf, such as the following two innodb_buffer_pool_dump_at_shutdown=1 # turn off hot data

  2022-06-01 17:16:19 Views: 265
• 

  Expdp/impdp Export Import

  Create the export file location folder create directory dir_dump as'/ home/oracle'; to authorize the user to grant read, write on directory dir_dum

  2022-06-01 17:16:18 Views: 226
• 

  Linux/Centos mysql5.1 upgrade to 5.6 (mysql upgrade installed by rpm)

  Before upgrading, back up the entire database and back up the database as a precaution. Upgrading MySQL usually does not lose data, but to be on the safe side, we need to do this step. Enter command: mkdir / software create a folder to store backup files mysqldum

  2022-06-01 17:16:12 Views: 208