NAV: SLTechnology News&Howtos > Database >

• 

  Oracle ORA-08591 alarm

  The database reports the following error during archive recovery: RMAN-08591: WARNING: invalid archived log deletion policy View ORA error explanation: [oracle@021Y-SH

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

  The thought of divide-and-conquer of traditional row database

  In order to avoid generating a large amount of disk io, the traditional row database calculates that each datapage can be used by dividing the data into a datapage, such as using the maximum length of the row (even if only one byte of data is stored) in a 4k datapage.

  2022-06-01 08:29:06 Views: 273
• 

  Considerations for offset predicate when using Seek method for paging

  Seek method pagination is a popular paging concept recently. Its core idea is: no longer rely on index as the offset, but use conditional expressions as the basis for paging. The specific principle I am here no longer nonsense, interested friends can go to search.

  2022-06-01 08:28:59 Views: 273
• 

  Use LAMP+wordpress to build and beautify the blog

  Prepare a domain name can go to Wanwang, Xinwang,. A cloud space (it is best to buy a Hong Kong host, or a foreign one, without filing), and then add the domain name to the ip address of your own cloud space, that is, add an A record installation section to download the wordpress installation package. Install lam

  2022-06-01 08:28:59 Views: 210
• 

  Find out the data that mysql occupies the most hard disk.

  Check the usage of each library: selecttable_schema as' database', sum (table_rows) as' records', sum (truncate (data_length/1024/1024, 2)

  2022-06-01 08:28:59 Views: 232
• 

  Redis Project (3): basic concept of Lock to Redis distributed Lock implementation

  Extended reading: Redis chat (1): building a knowledge graph Redis topic (2): exploring the underlying layers of Redis data structures recently, distributed issues have been widely mentioned, such as distributed transactions, distributed frameworks, ZooKeeper, SpringCloud and so on. Ben

  2022-06-01 08:28:35 Views: 276
• 

  Oracle-date- corresponding to mysql time type and null value handling

  Because in the data migration of Oracle---- > mysql, it is easy to cause errors when we find that the date type in Oracle and the time type of the corresponding mysql are improperly set, especially when there is a null value, mysql version 5.6.40 version mys

  2022-06-01 08:28:34 Views: 292
• 

  Basic learning of Django framework

  Django installation python download address http://www.python.org/download/releases/3.3.4/Django download address: https://www.djangoproje

  2022-06-01 08:28:34 Views: 247
• 

  Oracle Enterprise Manager 11g start and stop

  1. Check whether the component col comp_name for a40select comp_name,version,status from dba_registry;COMP_NAME VERSION S is installed

  2022-06-01 08:28:34 Views: 209
• 

  Oracle view table space size and modify table space size

  Oracle view table space size and modify table space size problem description: 1. Modify tablespace size 2. View the tablespace size and the associated sql. one。 The solution to the above problem is to modify the tablespace size: it can be solved by increasing the tablespace, as follows: log in to sqlp using dba users

  2022-06-01 08:28:34 Views: 227
• 

  What affects the performance of MySQL

  Some common factors affecting performance: server hardware server system database storage engine MyISAM: can make good use of memory, but does not support transactions, table-level locks InnoDB: transaction-level storage engine, perfect support for row-level locks and transaction ACID features database parameters configure database table structure

  2022-06-01 08:28:13 Views: 274
• 

  Install binary Mariadb on CentOS-6

  Three different forms of packages are available on the mariadb official website: the source package version, the package manager version, and the binary version, as shown in the following figure. The binary version is an official compiled green version, which is easier to install than the source package version and has a little more freedom than the package manager version.

  2022-06-01 08:28:12 Views: 234
• 

  Centos7 installs mariadb galera cluster database cluster & detailed explanation

  # Galera cluster features no latency between clusters and synchronous replication. While master-slave master-slave asynchronous replication, there is a delay. Active-active is multi-master, and all the servers in the cluster are written at the same time. You must wait until all the databases in the cluster have finished writing data.

  2022-06-01 08:28:12 Views: 227
• 

  AIX environment file system migration to ASM storage

  AIX environment file system migration to ASM storage system environment: operating system: AIX5.3-08Oracle: Oracle 10gR2 1. Build ASM storage environment http://tiany.blog.51cto.com/5136

  2022-06-01 08:28:11 Views: 247
• 

  MongoDB automatically installs shell

  Install the mogodb script 1.0001 Mtarfile= bind bind to add mongod-s / sbin/nologin-Mtarfile= `ls-l. | | grep mongodb-linux |

  2022-06-01 08:27:53 Views: 277
• 

  ORACLE restore Delete Table or Table record

  One: table recovery for mistakenly deleted tables, as long as you do not use the PURGE permanent delete option, then it is very promising to recover from the flash back area. General steps are as follows: 1. Query the deleted table select * f from flash back

  2022-06-01 08:27:53 Views: 226
• 

  Installation and deployment of cacti under centos

  Deploy snmp:yum-y install net-snmp net-snmp-utils (startup after service snmpd start deployment) deploy php and database: yum-y install ht

  2022-06-01 08:27:53 Views: 206
• 

  Zabbix monitoring adds psql database and sql_server database template

  1. Psql database performance monitoring: 1) zabbix-agent client installation pg_monz steps: [root@zabbix ~] # tarxfz pg_monz-1.0.1.tar.gz [root@zabbix

  2022-06-01 08:27:53 Views: 301
• 

  IGNITE TROUBLESHOOT

  H2 Console sets the system variable set IGNITE_H2_DEBUG_CONSOLE=true, and when you start IGNITE, an h3 console browser pops up automatically. You can see the index established and the specific number.

  2022-06-01 08:27:52 Views: 246
• 

  SQL Server Agent stops automatically after startup, and the ODBC driver is lost

  Environment: 2 SQL Server 2012 Always ON service phenomena: Always ON service is normal, synchronization is normal, application is normal. Second Server Server Agent stops automatically after it starts for a few seconds. Dealt with.

  2022-06-01 08:27:43 Views: 244