NAV: SLTechnology News&Howtos > Database >

• 

  View database size statement

  Select sum (bytes) / 1024 from dba_segments; to view the size of each tablespace occupied: select tablespace_name,sum (bytes) from

  2022-06-01 09:45:20 Views: 240
• 

  Oracle RAC Cluster testing-Best practices for production environments (Oracle 11g/12c/18c/19 RAC)

  The best method of Oracle RAC cluster testing in production environment (supporting the testing process in the later stage of Oracle 11g/12c/18c/19c RAC installation) 1. Oracle RAC cluster testing background A large and medium-sized manufacturing company has built a

  2022-06-01 09:45:20 Views: 280
• 

  Linux installation mysql 5.7

  Mysql installation pits, different versions may use different commands, you need to check carefully here. Download the corresponding linux version on the mysql official website as required. two。 Create the mysql directory and install the downloaded installation package into the directory mkdir / usr/local/m

  2022-06-01 09:45:20 Views: 242
• 

  Classification and summary of sql statements

  Data definition language DDLcreate database db_name;create table table_name (column_name data_type,...); create view vie

  2022-06-01 09:45:19 Views: 256
• 

  Talking about how to learn oracle database efficiently

  For details of the article, please follow the link below: http://mp.weixin.qq.com/s?__biz=MzIwMjU2MjI1OQ==&tempkey=sXhfnzfIdrymRA7B8csLCRQWvqPIs

  2022-06-01 09:45:19 Views: 283
• 

  The method for mysql to get the execution plan

  Mysql gets the execution plan method: 1. View the execution plan of sql through explain; 2. Check the execution plan of the sql through the sql that the thread is executing; it is relatively simple for explain to view the execution plan of the sql.

  2022-06-01 09:45:19 Views: 287
• 

  12C database cheating and cheating teammates' unprovoked links can not deal with the problem.

  The system that the company launched two years ago, when it was going to use the new feature of 12c, was put into production. The initial oracle version is 12.1, and this version is constantly bug in practical use, which is a headache. Recently, more than 20 new application servers have been developed and put into production.

  2022-06-01 09:45:19 Views: 280
• 

  Redis master-slave synchronization and read-write separation

  First, the master-slave replication function of principle Redis is very powerful, a master can have multiple slave, and a slave can have multiple slave, thus forming a powerful multi-level server cluster architecture. Here are some things about redis master-slave replication

  2022-06-01 09:45:18 Views: 305
• 

  Quickly build LAMP environment on CentOS7

  First, make sure that the network on the CentOS7 is configured correctly and that you can access the Internet properly. Make sure that iptables is turned off. Firewall on CentOS7, close command: # systemctl stop firewalld.servi

  2022-06-01 09:45:15 Views: 272
• 

  Using python to Test the data synchronization delay of mongodb replica set

  This paper mainly introduces python how to connect mongodb replica set and read-write separation configuration, and how to test the data synchronization delay of mongodb replica set. 1. Python connection mongodb copy set 1. Connect the replica set to use MongoClie directly in the new driver

  2022-06-01 09:45:15 Views: 271
• 

  Oracle 12c DG standby library Alert error ORA-10877 full library recovery

  12C Oracle Data Guard repository exception today 2018-07-05T21:31:32.291970+08:00GEN0 (ospid: 75371): terminating the ins

  2022-06-01 09:45:15 Views: 303
• 

  Ubuntu16 installs Oracle JDK 8

  Ubuntu16 install Oracle JDK 8java Software install Ubuntu16 install Oracle JDK 8 add Source install JDK Test add Source $sudo add-apt-repository ppa:we

  2022-06-01 09:45:15 Views: 284
• 

  Query Oracle table field

  Select ROWNUM, T.*From (Select column_name,CaseWhen data_type = 'NUMBER' Thendata_type | |' ('| | nvl

  2022-06-01 09:45:14 Views: 274
• 

  Mysql Learning Notes (2)-MySQL data type

  [text] in the previous chapter, we learned about the installation of MySQL software. now that the software is installed, let's officially start the study of the basic knowledge of MySQL, even if it is zero, one step at a time. Well, the first thing to learn is the data type of MySQL. I. data type

  2022-06-01 09:45:14 Views: 313
• 

  Install Oracle11gR2- to build the library manually on Linux

  Modify the oracle user environment variable [oracle@oracle ~] $su-oracle [oracle@oracle ~] $vim .bash _ profile# .bash _ profile# G

  2022-06-01 09:44:44 Views: 269
• 

  Deploy exchange2010 three-in-one: twelve: deploy database highly available DAG

  Prerequisite MB IPHeart network192.168.1.15192.168.100.2192.168.1.16192.168.100.3dag cluster virtual ip192.168.1.30DAG Nic configuration

  2022-06-01 09:44:44 Views: 266
• 

  SQL SERVER INSTALL

  Shili gongneng, yige sql server jiushi 1ge shili.gongneng xuanzezhuyao shi gongxiang gongneng de xu

  2022-06-01 09:44:43 Views: 287
• 

  Oracle 12C RAC Cluster Log (cluster log) directory

  [grid@shurkcs ~] $adrciADRCI: Release 12.2.0.1.0-Production on Thu Mar 1 09:25:45 2018Copyright (c

  2022-06-01 09:44:43 Views: 249
• 

  The difference between MyISAM and Innodb database engine

  1. Storage structure 2, storage space 3, portability, backup and recovery 4, transaction support 5, self-growth 6, table lock difference 7, full-text index 8, table primary key 9, specific rows of table 10, CURD operation 11, MyIS in foreign key MySQL storage engine

  2022-06-01 09:44:43 Views: 230
• 

  Mongodb Index (2)

  The composite index < connected > > deletes the previous collection and re-establishes it, as follows: > db.person.drop () true > for (var iPresistive I < 200000000politic +) {. Db.perso

  2022-06-01 09:44:36 Views: 294