NAV: SLTechnology News&Howtos > Database >

• 

  Redis common commands (4) Database management, key management, subscription and publication

  # Database management keys pattern # lookup key, parameter wildcard lookup keys * # View all keys keys n * # View all keys beginning with n keys * e # View all keys ending with e keys h?llok

  2022-06-01 08:20:51 Views: 260
• 

  Subtotal of oracle index establishment

  SQL > create index idx_test on test (id1) tablespace IDX nologging online parallel 4 * * Index created.SQL >

  2022-06-01 08:20:51 Views: 253
• 

  Oracle creates tablespaces and user authorization

  Create the tablespace create tablespace usersdatafile'D:\ Oracle\ oracle\ oradata\ users.dbf'size 100mautoextend onnext

  2022-06-01 08:20:51 Views: 230
• 

  New tables / functions / stored procedures added after SQLserver 2008 synchronous replication is created (no reinitialization of snapshots)

  SQLserver 2008 synchronous replication creates new tables / functions / stored procedures (do not reinitialize snapshots) 1. In existing transaction replication in production environment (replication type is transaction publication), new tables, views, stored procedures, etc., need to be added to the published database, these changes will not

  2022-06-01 08:20:39 Views: 248
• 

  Wang Gaoli: common command operation of Redis operation and maintenance

  In the usual work, we need to do some operations on the Redis database according to the requirements. You can refer to Redis's official website http://redis.io/commands to learn more about 1.SELECT switching database redis 127.0.0.

  2022-06-01 08:20:34 Views: 216
• 

  MongoDB practice (9) Replica Sets replica set (part I)

  MongoDB supports failover and redundancy through asynchronous replication across multiple machines. Only one of the multiple machines is used for writing at a time. It is because of this situation that MongoDB provides a guarantee of data consistency. Machines that play the role of Primary can

  2022-06-01 08:20:34 Views: 215
• 

  Create Datasheet primary key foreign key

  1. Create a data table and store it in rows and columns. Each row has a unique record, and each column represents a field or field in the record. Format: the name of the table is case-insensitive and cannot use the SQL keyword; multiple columns are separated by commas. Create table (field 1, number

  2022-06-01 08:20:25 Views: 242
• 

  12c DataGuard failed to delete archive log

  1. Environment description Oracle 12c single instance DataGuardRhel 7.3II, test process master library operation 1. Close DG and switch log SQL > alter system set log_archive_dest_sta

  2022-06-01 08:20:25 Views: 300
• 

  Ora 31626 oraInventory, oraInst.loc exported by data pump

  Because the source database triggered the ora 31626 error, because the data dictionary was not upgraded after the database was patched. Solution:1 sql > @? / rdbms/admin/catalog.sql2 sql > @? / rdbms/admin/

  2022-06-01 08:20:25 Views: 260
• 

  Impact of MongoDB Plan caching

  Impact of MongoDB plan cache MongoDB 2.6 replication set Primary after creating the index, it was found that Secondary's query did not take the latest index. It is normal after temporarily clearing the schedule cache for the collection. The author observes that when there is a performance problem, the statement does not

  2022-06-01 08:20:24 Views: 234
• 

  Oracle12.2 stand-alone configuration

  Yum install-y binutils-yum install-y compat-libcap1yum install-y compat-libstdcyum install-y elf

  2022-06-01 08:20:24 Views: 286
• 

  Several common reasons for hard parsing

  Customers often mention that the execution plan of a SQL has deteriorated, resulting in performance problems, and then ask why the new execution plan has been parsed. First of all, it is certain that the sudden emergence of a new implementation plan indicates that sql has reparsed hard parsing (note that reparsing does not necessarily produce a new implementation plan), then

  2022-06-01 08:20:24 Views: 290
• 

  RMAN of Oracle Learning (XIII) recovery-data Block repair

  In many cases, the database is only a few blocks of a data file corrupted. In this case, of course, we can use database recovery or data file recovery to solve the problem. But it feels like an anti-aircraft gun hitting mosquitoes. Fortunately, RMAN provides block-level recovery. Let's do it next.

  2022-06-01 08:20:24 Views: 224
• 

  Linux self-study Notes-- LNMP

  Traditionally, web services based on process or thread model handle concurrent requests per process or thread, which is bound to cause blocking during network and Ibank O operations, and another inevitable result is low utilization of memory or CPU. Generating a new process / thread requires preparing its runtime in advance

  2022-06-01 08:19:54 Views: 223
• 

  Oracle performance tuning Learning 0622

  Wait event in query database: SET lines 100SET pages 10000COLUMN wait_class format a12COLUMN event format a30COLUMN to

  2022-06-01 08:19:53 Views: 265
• 

  Cascade and inverse (hibernate)

  Cascade is one of the two tables in which whether the actions of one table are cascaded (affected) to the other table inverse true indicates that the relationship between the two tables is the responsibility of the other, generally responsible for multiple parties, that is to say, only (inverse=false) party changes the two tables

  2022-06-01 08:19:53 Views: 285
• 

  Oracle merging

  DECLARETYPE num_tt IS TABLE OF INT;num_t1 num_tt:=num_tt (); num_t2 num_tt:=num_tt (); num_t3 num_tt:=nu

  2022-06-01 08:19:53 Views: 266
• 

  Basic Application of Mariadb

  Mariadb Overview: the MariaDB database management system, a branch of MySQL, is mainly maintained by the open source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting down MySQL.

  2022-06-01 08:19:53 Views: 285
• 

  What is database security audit?

  Database security audit is mainly used to monitor and record all kinds of operations on the database server. Through the analysis of network data, various operations on the database server can be analyzed real-time and intelligently, and recorded in the audit database for future query, analysis and filtering, so as to realize the target database system.

  2022-06-01 08:19:52 Views: 250
• 

  Oracle creates synonyms

  First, you need to create synonym permissions for the user: SQL > grant create synonym to jhchen;Grant succeeded. Create synonym syntax: create synonym name for owner

  2022-06-01 08:19:52 Views: 270