NAV: SLTechnology News&Howtos > Database >

• 

  Create views for database optimization

  A view is a SELECT query saved in a database that executes most commands of SELECT statements on the view. There are two reasons for creating a view: first, for security reasons, users do not have to see the entire database structure, but hide part of the data; second, it is in line with the user's daily business logic.

  2022-06-01 13:38:13 Views: 242
• 

  Weblogic 10 Virtual memory size Settin

  Weblogic 10 virtual memory size setting windows 32-bit: in C:\ Oracle\ Middleware\ user_projects\ domains\ admin\ bin\ setDomainEnv.c

  2022-06-01 13:38:13 Views: 247
• 

  Rapid deployment of Oracle environment with Docker

  The Oracle environment needs to be used frequently at work, but it takes time to build it each time. I wanted to install oracle vm quickly through the virtual machine template, but it is also time-consuming to change the environment such as ip, so I wonder if there is a p_w_pi that has been done in docker.

  2022-06-01 13:38:13 Views: 240
• 

  CentOS7 installs third-party yum source EPEL

  EPEL is the abbreviation of Linux add-on package for Enterprise Edition. EPEL is created, maintained and managed by the Fedora Special interest Group for Red Hat Enterprise Linux (RHEL) and its derivative distributions (such as CentOS, Scie)

  2022-06-01 13:37:49 Views: 223
• 

  MongoDB basic command operation

  In the previous essay on how to install the MongoDB database on Centos7, let's learn the basic operation commands together. After the installation is completed, you can log in to the database without a password by typing mongo interactively with shell. Show dbs

  2022-06-01 13:37:49 Views: 284
• 

  OEL6.5_X86 platform deployment oracle11gR2RAC configuration ACFS

  Official definition of ACFS, oracle: Oracle AutomaticStorage Management Cluster File System & # 40: Oracle ACFS) is a m

  2022-06-01 13:37:49 Views: 204
• 

  ORACLE regular expression

  There are four main functions that support regular expressions in ORACLE: 1Regex _ like: similar to the function of LIKE, 2meme _ REGEXP _ INSTR: similar to the function of INSTR. 3REGEXP _ SUBSTR: and SUBS

  2022-06-01 13:37:48 Views: 289
• 

  12c RMAN backup script, ORA-00245

  12c rac reports an error as follows: channel d3: backup set complete, elapsed time: 00:00:08RMAN-03009: failure of backup com

  2022-06-01 13:37:48 Views: 256
• 

  Analysis of MyBatis Source Code

  What is MyBatisMyBatis? an excellent persistence layer framework that supports customized SQL, stored procedures, and advanced mapping. MyBatis avoids almost all JDBC code and manually setting parameters and extracting result sets. MyBatis uses a simple

  2022-06-01 13:37:47 Views: 225
• 

  MySQL-bin.index no found (errcode:13-perssion)

  The following error "perssion denied" occurred when starting the MySQL server today, which immediately reminded me that it might be a problem with MySQL permissions. So he went to the MySQL directory and found that many owners and groups were not MySQL, so he re-authorized MySQL.

  2022-06-01 13:37:35 Views: 250
• 

  Mysqldump usage of MySQL data backup

  1. Various usage instructions A. The simplest use: mysqldump-uroot-pPassword [database name] > [dump file] the above command backs up the specified database to a dump file (dump file)

  2022-06-01 13:37:20 Views: 240
• 

  3.0.2 → 3.2.12 Sharded Cluster upgrade

  Preliminary preparation: 1) version 3.2.12 is ready; 2) during the upgrade process, make sure that client will not modify the collection metadata. For example, you cannot do the following: sh.enableSharding () sh.shardCollection () sh.ad

  2022-06-01 13:37:20 Views: 264
• 

  Redis master-slave service configuration

  First, the purpose of writing this article provides redis master-slave configuration operation guide for redis operation and maintenance personnel to use. Operation procedure 1.redis master service does not need to modify 2.Redis slave service modification (1) Open the redis.conf file (path / usr/lo) of the slave library

  2022-06-01 13:37:20 Views: 220
• 

  The idea of optimizing the query performance of sql statements (personal understanding)

  My understanding of sql sentence optimization starts from the following four aspects: 1. Rewrite SQL;2. Adjust the parameters of the database or system. 3. Adjust the table structure; 4. Build an index. It will continue to be improved in the future.

  2022-06-01 13:37:19 Views: 280
• 

  Redis performance tuning

  The performance optimization of Redis mainly starts from the following aspects: the first and most important is to ensure that Redis is not allowed to execute time-consuming commands and use pipelining to combine the continuously executed commands. When using pipelining, you only need to start from the client side

  2022-06-01 13:37:11 Views: 270
• 

  Oracle user Management

  1. User process Ps-elf | greporacleocl | grep-v grep2. Database process Ps-elf | greporacleorcl3. Daemon Ps-elf | grep oha large pool

  2022-06-01 13:37:11 Views: 252
• 

  The relationship between Oracle SCN and Timestamp

  SQL > conn / as sysdbaSQL > select scn, to_char (time_dp,'yyyy-MM-dd hh34:mi:ss') from smon_scn_time;s

  2022-06-01 13:37:11 Views: 297
• 

  Startup and shutdown of oracle 11g

  Oracle 11g start and shut down startup nomount: open the database instance, read the parameter files, and start the necessary background processes, DBWR (database write process) LGWR (log write process) SMON (system monitoring process) PMON

  2022-06-01 13:36:59 Views: 225
• 

  Set up your own website

  Before, when I was browsing other people's personal websites, I always envied how good they were. So when I learned about the Linux web server, I finally felt that what I had learned could come in handy. You can also maintain your own small website, so don't say much nonsense and start building services. one

  2022-06-01 13:36:50 Views: 208
• 

  SQL*Net Wait Events

  What is a Wait Event? During the normal functioning of a database, an Oracle process will occasional

  2022-06-01 13:36:47 Views: 215