NAV: SLTechnology News&Howtos > Database >

• 

  Performance Test of oracle single-column Index and combined Index

  There are two tables in total. The table structure of T1 and T2 is through insert into T1 values ('www','aaa','bbb'); insert into T1 values (' www1')

  2022-06-01 07:57:35 Views: 221
• 

  No buffer space available, the operation on the socket cannot be performed because the system buffer space is insufficient or the queue is full

  Netstat-nat | find "" / c check the number of connections is only more than 2, 000, how to report the following error: (IE opens the website can not be opened) no buffer space available (curl reported an error), because

  2022-06-01 07:57:26 Views: 282
• 

  Summary of Chinese garbled problems in linux installation Oracle

  To solve the problem of oracle Chinese display garbled, there are three layers that need to be adjusted or modified in the first layer: operating system layer 1. First check whether linux has installed the Chinese character set, locale-a 2. If you set the user's Chinese character set and see that linux has installed the Chinese character set, then or

  2022-06-01 07:57:26 Views: 224
• 

  Oracle Study-- ASM File system ACFS Management

  Oracle Study-- ASM file system ACFS management system environment: operating system: RedHat EL5.5Cluster: Oracle Grid 11.2.0.1.0Oracle: Oracle 11g

  2022-06-01 07:57:23 Views: 299
• 

  MySQL 5.6.38 is installed on RedHat 6.5 through the RPM package

  1. Installation environment 1. Operating system version: Red Hat Enterprise Linux Server release 6.5 (Santiago) 2, Mysql version: MySQL-5.6.38-1.el6.x8

  2022-06-01 07:57:06 Views: 280
• 

  Sort out the blank space of Exchange database

  We all know that after the Exchange database is running for a period of time, the database will produce some blank space, which can not be used by the database, and the blank space will also take up physical disk space. Here's how to clean up the Exchange database to free up white space.

  2022-06-01 07:56:55 Views: 270
• 

  Zabbix Monitoring mysql and alarm (2) final

  Zabbix deploys the monitoring database alarm service (2) finally follows zabbix (1) after deploying and configuring for a period of time, observe the effect of the monitoring chart and see whether the zabbix3.0 server has its own mysql template. Just configure the agent guest.

  2022-06-01 07:56:43 Views: 270
• 

  Oracle management

  First, the client connects to the server. View the server listener configuration file (no need to change it) [root@oracle/] # su-oracle [oracle@oracle~] $cd $ORACLE_HOME/network/

  2022-06-01 07:56:43 Views: 255
• 

  Oacle removes duplicate data

  -- Test data create table test as select * from dba_objects;insert into test select * from test;-- to see if there is any duplicate data

  2022-06-01 07:56:43 Views: 293
• 

  Aix5.3 system installs oracle 10g using bare equipment-- 4k offset problem

  Today, when a friend installed oracle 10g on the aix 5.3 system to build the database using a bare device, dbca reported an error exit when it was built to 2%. Looking at the alert log, it was found that the lack of temp tablespace was caused. View the bare device capacity of the tablespace data file is 512

  2022-06-01 07:56:42 Views: 296
• 

  Oracle reported the following error under startup Linux

  Oracle reported the following error under startup Linux: ORA-27102:out of memory Linux-X86_64 Error: 28: No space left on device

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

  Example Analysis of oracle query without Indexes

  Create table T2 as select * from dba_objects;-- create table create index idx_t2_name on T2 (obje)

  2022-06-01 07:56:42 Views: 221
• 

  Opatch update

  Usually we use opatch tools to upgrade the database, so it is generally required that the version of opatch is higher than the version of the database you want to upgrade. For example, if you upgrade the database to 11.1.0.2, then the opatch is higher than 11.1.0.2. Select *

  2022-06-01 07:56:42 Views: 285
• 

  Backing up the MySQL database using xtrabackup

  Preface Xtrabackup provides two command-line tools: xtrabackup: dedicated to backing up data from InnoDB and XtraDB engines; and innobackupex: a perl script that calls xtrabackup during execution

  2022-06-01 07:56:35 Views: 242
• 

  Query which tables a specific user owns under oracle 11g (table)

  SYS@san > select table_name from dba_tables where owner='SCOTT';TABLE_NAMEDEPTEMPBONUSSALGRADESYS@san >

  2022-06-01 07:56:34 Views: 287
• 

  MYSQL: INNODB or MYISAM?

  MyISAM is the default storage engine in MySQL, and generally speaking, not many people care about it. Deciding which storage engine to use is a very tricky thing, but it's worth studying. The article here only considers MyISAM and InnoD.

  2022-06-01 07:56:34 Views: 223
• 

  Oracle DBA Database Senior engineer (part 2) SQL language + performance Optimization + data replication

  Package introduction: Oracle DBA Database Senior engineer (part two) SQL language + performance Optimization + data replication http://edu.51cto.com/pack/view/id-973.html description Oracle DBA Database High

  2022-06-01 07:56:31 Views: 247
• 

  Accidentally delete the user table with the delete command

  Operating environment: operating system: CentOS release 6.8 (Final) database: MySQL 5.5.52-cll-lveWeb application software: Apache/2.2.15 (Unix) problem: operating mysql database

  2022-06-01 07:56:01 Views: 267
• 

  Configure always on mode of SQL 2016 for SharePoint 2016 (4)

  Above, we have deployed the Always On of SQL Server 2016, so it is no problem to provide high-availability back-end support services for SharePoint 2016. Next, when configuring SharePoint

  2022-06-01 07:56:01 Views: 221
• 

  Installation Oracle11gR2 RAC One Node-Test one

  Chapter 6, Test 6.1 View rac one node Info Node 1gridkeeper Node 1 d ORACLEDatabase unique name ~ > srvctl config database-d ORACLEDatabase unique name: ORA

  2022-06-01 07:56:00 Views: 298