NAV: SLTechnology News&Howtos > Database >

• 

  Virtual column (Virtual Column), one of the new features of Oracle 11g

  One of the new features of Oracle 11g-- Virtual column (Virtual Column) Oracle 11G Virtual column Virtual Column introduction in the old Oracle version, when we need to use expressions or some calculation formulas, we

  2022-06-01 07:28:27 Views: 277
• 

  Matters needing attention in building oracle11g R2 rac under oracle linux6.5 (64bit)

  1. The name (hostname) of each node should be set. 2. It is recommended that the network card used for private communication should be bound with two network cards, and the names of the network cards of each node should be the same. 3. Public ip, virtual ip and scan ip must be on the same network segment, and private ip must be on another network segment, virtua

  2022-06-01 07:28:27 Views: 236
• 

  Oracle-ASM installation tutorial

  There are a lot of repetitions between the steps of installing ASM database and the steps of installing RAC, so the previous installation documents of RAC are modified and the database based on ASM management is successfully installed. The environment for installation is CENTOS6.5_64 bit, and the database to be installed is 11gr2 version

  2022-06-01 07:28:27 Views: 290
• 

  Understanding of rollforward and rollback of oracle instance recovery

  There have always been some misunderstandings about oracle instance recovery. Today, by looking at relevant materials and discussing with classmates, I found my own mistakes. The results are as follows: instance recovery: when the database is shut down abnormally (power outage or shu abort and other inconsistent shutdown), when

  2022-06-01 07:28:26 Views: 299
• 

  Mysql multi-table query case

  # case: select SELECT last_name,job_id,e.department_id,department_nameFROM employees AS e of city's employees in Toronto

  2022-06-01 07:28:26 Views: 272
• 

  Centos7 installation and configuration pgAgent

  Centos7 install pgagent: default cmake has installed and compiled wxGTK https://excellmedia.dl.sourceforge.net/project/wxwindows/2.8.7/wx

  2022-06-01 07:28:26 Views: 243
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (15)

  Performance test and comparative analysis use xx library to test, data file 8G, backup 600m: test scenario usage time 1 is created by backup recovery, backup compression is enabled by automatic seed setting, backup compression is enabled by automatic seed setting, backup compression is enabled by automatic seed setting, backup compression is enabled by automatic seed setting

  2022-06-01 07:28:26 Views: 263
• 

  Quickly copy the InnoDB table to another instance

  This procedure demonstrates how to copy a regular InnoDB table from a running MySQL server instance to another running instance. You can use the same procedure with minor adjustments to perform a full table restore on the same instance. On the source instance, create a table (if it does not exist): mysq

  2022-06-01 07:28:25 Views: 272
• 

  Linux silently installs oracle

  1. Prepare to install the package linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.ziprlwrap-0.30.tar.gz2. Install dependencies first

  2022-06-01 07:28:25 Views: 278
• 

  Case Analysis of data Table damage caused by MYSQL Truncate

  Recently released to the market version of the frequent database table corruption, the specific phenomenon is that the select table does not exist, but look at the data file, the corresponding table ibd and frm files are there. Through the statistics of multiple faults, several tables with frequent damage are found, and in the process of analysis

  2022-06-01 07:28:19 Views: 288
• 

  (20) Hibernate secondary cache

  1. Knowledge of second-level cache the cache provided by Hibernate: there are first-level cache and second-level cache. The purpose is to reduce the number of visits to the database and improve the efficiency of program execution! First-level cache: Session-based cache, the cache content is only valid in the current session, se

  2022-06-01 07:28:09 Views: 225
• 

  Localhost is allowed when connecting to oracle, ip address is not allowed.

  When oracle is installed on this machine, when using sqlplus and plsqldev to connect, host is written as localhost in tnsname.ora. There is no problem in connecting to oracle at this time, but the external machine is connected to the local machine and tnsnam.

  2022-06-01 07:28:09 Views: 240
• 

  Principle of mysql master-slave replication

  Master-slave form mysql master-slave replication flexibility one master-slave replication one master-slave replication-expand the performance of the system read because the read is read from the library; multi-master one-slave starts to support cascading replication-usage and conditions mysql master-slave replication purpose real-time disaster recovery for failover

  2022-06-01 07:28:09 Views: 248
• 

  Package Management of linux-rpm

  We know that a program is a set of instructions plus data, or a collection of algorithms plus data structures. The application exists in the form of source code and binary: the source code is a text file that contains all the code of the programming language of the entire application; binary is the conversion of the source code through a series of operations.

  2022-06-01 07:28:08 Views: 278
• 

  Redis installation and basic use

  Redis concept: Redis is an open source memory-based and persistent log-based Key-Value database redis tool: redis-benchmark # redis-sentine for redis performance testing

  2022-06-01 07:28:08 Views: 248
• 

  Problems with mysqldump recovery backup

  Today, the following error occurred when importing data using MySQL workbench: find the information and solve it: reference link: http://blog.csdn.net/cug_jiang126com/article/details/

  2022-06-01 07:27:56 Views: 298
• 

  Vmur4-1 vCenter installation configuration ODBC

  VCenter is an important component to enhance the functionality of ESXi. Put ESXi into vCenter and log in to vCenter cluster management. And some advanced features, including cloning virtual machines, high availability, and so on, rely on vCenter. This article describes how to install vC

  2022-06-01 07:27:56 Views: 241
• 

  Detailed explanation of memcache Master-Slave Architecture

  Repcached is a Japanese development to achieve memcached replication function, it is a single master single slave scheme, but its master/slave is read and write, and can be synchronized with each other, if the master is broken

  2022-06-01 07:27:48 Views: 299
• 

  Instructions for the use of advanced grouping group by, group by cube, group by rollup

  1. Summing select sum (sal), job,deptno from emp group by grouping sets (job,deptno) by job and deptno grouping, 2, 2 ^ n-1 grouping (

  2022-06-01 07:27:47 Views: 283
• 

  Trigger in Oracle (2)

  The previous article has some basic knowledge of triggers, in this operation to verify before triggers [oracle@test ~] $sqlplus / as sysdbaSQL > create user trigger_t

  2022-06-01 07:27:47 Views: 221