NAV: SLTechnology News&Howtos > Database >

• 

  Detailed summary of Oracle Partition partition

  This paper sorts out the concept and operation of partition table from the following aspects: 1. The concept of table space and partition table II. The specific function of table partition 3. Advantages and disadvantages of table partitioning 4. Several types and operation methods of table partition 5. Maintainable operations on table partitions. (1.) The concept of table space and partition table is empty

  2022-06-01 13:39:29 Views: 294
• 

  Redis-aof recovery

  Aof recovery brief process: [root@ZFRC-YW-YJF-TEST-370123 redis] # pkill-9 redis [root@ZFRC-YW-YJF-TEST-370123 ~] # cd /

  2022-06-01 13:39:29 Views: 290
• 

  Hadoop ha+zookeeper+hbase

  1. Environment 1, system: Red Hat Enterprise Linux Server release 6.42, required software package hadoop-2.2.0.tar.gzhbase-0.98.2-hadoop2-b

  2022-06-01 13:39:28 Views: 279
• 

  VBScript programming based on WSH

  I also used VBScript when I was in college, but it was all based on ASP. Recently, due to the need of work, I tried to program under WSH (windows script host) to list the main tnsnames.ora files under oracle client.

  2022-06-01 13:39:25 Views: 288
• 

  12c broker configuration file corruption handling

  First, the problem description 1. Check broker log and find error tail-f drcorcl.log > > Starting Data Guard Broker bootstrap < show configuratio

  2022-06-01 13:39:25 Views: 285
• 

  The relationship between oracle comments and query hints (result_cache_mode)

  1. Result_cache_mode takes precedence over table annotations. Create table test_Result_cache (id number) result_cache (mode default

  2022-06-01 13:39:24 Views: 281
• 

  Determine whether the master and slave synchronize the script in GTID replication

  Determine whether the slave library is synchronized with the master library in GTID replication: in show slave stautus\ G: when Retrieved_Gtid_Set = Executed_Gtid_Set indicates that the slave library has completed synchronization with the master library #! / bin

  2022-06-01 13:39:24 Views: 202
• 

  Principle of InfluxDB engine

  Introduction InfluxDB is a timing database written in Go language. Time series database is mainly used to store index data based on time series, such as PV, UV and other indicators of a Web page, which are regularly collected and time-stamped, which is an index based on time series. Time series database

  2022-06-01 13:39:21 Views: 259
• 

  Oracle view locks and release locks

  -- find sid and serial#SELECT object_name, machine, s.sid, s.serial#FROM gv$locked_object l, dba_objects o

  2022-06-01 13:39:21 Views: 272
• 

  Basic syntax for Oracle tablespace users

  Create temporary tablespaces: create temporary tablespace mdm_temptempfile'/ u01/app/oracle/tempspace/mdm_temp.dbf'size 50

  2022-06-01 13:39:21 Views: 230
• 

  (PHP Learning Notes) the application of factory class in MVC framework

  In the basic MVC framework model, the database and template files are referenced. But different developers will choose different databases and template engines. Because in the actual development process, it is possible to change the database or template engine, if you write a connection for each database and template engine

  2022-06-01 13:39:20 Views: 309
• 

  Mysql system database installation

  Mysql does not need to talk about the theory, the document wrote the installation process, as well as the basic additions, deletions, modifications and queries. The preparation confirmed that mysql-server and mysql2 were not installed using RPM. Before installing mysql, you need to install the software development package, if you install the

  2022-06-01 13:38:59 Views: 245
• 

  CentOS install MariaDB

  Configure repo source official yum source generator: https://downloads.mariadb.org/mariadb/repositories/#mirror=tuna create and edit / etc/yum.repos.

  2022-06-01 13:38:58 Views: 276
• 

  Ora-00845 solution

  [oracle@up ~] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 10 19:26:05 201

  2022-06-01 13:38:58 Views: 232
• 

  Performance Test of interaction between Java, PHP, Python and MySQL

  The source code makes one thing clear these days: the WEB server receives browser requests, sends requests to PHP/Python processes (FCGI, etc.), and interacts with databases using socket (sockets). In other words, these behaviors are inter-process communication. One WEB server

  2022-06-01 13:38:46 Views: 215
• 

  About the configuration of IE browser on Oracle EBS users' computers

  Oracle, as the starting price of database software, also has a set of well-known ERP software products in the management science community, called Oracle EBS (E-Business Suit). The instructions on the computer configuration of this system on the client side are as follows: 1. The problem of domain name resolution: if you use

  2022-06-01 13:38:43 Views: 288
• 

  Analysis and solution of Common error codes in ORACLE

  (1) in the process of using ORACLE, we often encounter some errors generated by ORACLE. For beginners, these errors may be a little vague, and I may not know how to deal with these errors. I will make a score of the more frequent error codes in use.

  2022-06-01 13:38:43 Views: 285
• 

  Oracle Study-- IPCS manages shared memory

  Oracle Study-- IPCS Management shared memory, semaphores, queues under Unix/linux Management of shared memory, semaphores, queues and other shared information under unix/linux, some problems are often caused because shared memory, semaphores, queues and other shared information are not cleaned up cleanly

  2022-06-01 13:38:40 Views: 257
• 

  Influxdb+grafana visualization

  It is very necessary to understand the TPS and QPS of the database as an operation and maintenance DBA, then what are TPS and QPS? the simple understanding is: QPS: the number of queries per second, that is, the number of DML operations per second to the database: transaction per second, that is, the number of DDL operations per second to the database.

  2022-06-01 13:38:35 Views: 299
• 

  The Foundation of MySQL Database (2)-- MySQL character set and garbled parsing

  MySQL Database Foundation (2)-- MySQL character set and garbled parsing 1, character set and coding 1, character set introduction character (Character) is the general name of all kinds of characters and symbols, including national characters, punctuation marks, graphic symbols, numbers and so on. Character set (Charac

  2022-06-01 13:38:25 Views: 310