NAV: SLTechnology News&Howtos > Database >

• 

  Performance Optimization of Oracle Learning (14) memory

  The Oracle database contains the following basic memory components: System global area (SGA) The SGA is a group of shared memory structures, known as

  2022-06-01 11:06:13 Views: 265
• 

  Hive external HBase table

  CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name [(col_name data_type [COMMENT col_comment],...)] [

  2022-06-01 11:06:04 Views: 235
• 

  A preliminary study of python and mongodb

  Python connection mongodb: this requires a pymongo package to be installed. For some reason, I couldn't install it, and it always prompted me that I couldn't find the installed python, and then I installed pycharm, and with the help of this IDE, I installed pymongo, and then it was in the

  2022-06-01 11:06:04 Views: 244
• 

  Redis-Master-Slave configuration

  The role of the cluster: 1, master-slave backup to prevent master database downmachine 2, read-write separation, sharing master pressure 3, task separation, such as sharing backup work from the server, probably synchronization principle: 1 sync starts to find that you need to connect to master, then sync automatically synchronizes 2

  2022-06-01 11:06:03 Views: 289
• 

  Tuning it through case study-- simulating buffer busy waits events

  Tuning it through case study-- simulating buffer busy waits event buffer busy waits waiting event Wait occurs when a session attempts to acces

  2022-06-01 11:06:03 Views: 282
• 

  An automatic execution script for a cold backup

  It took more than a day to come up with a SQL script to perform an automatic cold backup of ORACLE. The record is as follows: set echo off-- turns off the echo of the command, but displays after execution

  2022-06-01 11:06:03 Views: 276
• 

  The usage of exists and except in SQLServer

  1. Exists1.1 states that the return value of the EXISTS (including NOT EXISTS) clause is a Bool value. There is a subquery statement (SELECT...) inside EXISTS. FROM...), which I call the internal check of EXIST

  2022-06-01 11:06:03 Views: 291
• 

  Oracle11G_ data Dictionary and dynamic performance View

  Data dictionary: the core of the database, which records the most basic information of the database; includes basic tables (whose name ends with $, belongs to sys users and is not allowed to modify), views (to facilitate the use of basic tables); dynamic performance views: stores the main activity information of the database; starts with V$

  2022-06-01 11:06:03 Views: 231
• 

  Mongodb installation, configuration, startup and related operations

  Introduction to mongodb: MongoDB is a product between relational database and non-relational database, which is the most functional and most like relational database in non-relational database. The data structure he supports is very loose and is a bjson format similar to json, so it can be stored than

  2022-06-01 11:05:47 Views: 226
• 

  Basics of getting started with Mysql (2)-& gt;Mysql database installation

  Chapter 2 Mysql database installation declaration database and instance: there are two words that are easy to be confused in the database field, they are "instance" and database (database). Database: on a physical operating system, a collection of file types in files or other forms, in Mysql

  2022-06-01 11:05:46 Views: 276
• 

  Oracle (OEM and common fault handling)

  1. OEM knowledge points 1. Introduction to OEM OEM is a tool set that uses an intuitive and convenient graphical interface to control and manage ORACLE databases. It contains a large number of useful tools for DBA. In oracle, database management and operations can be done using OEM, such as creating

  2022-06-01 11:05:16 Views: 275
• 

  Web Human Resources Information system Development Log ②

  The second phase of development (April 28-May 20, 2017): development content: ① project framework design, directory tree structure, database design ② write Web Apps installer, detect the running environment, create data sources and database user information, and generate PDO configuration files (interfaces are often

  2022-06-01 11:04:46 Views: 263
• 

  CentOS6.4_X64 installation and configuration vsFTP-2.2.2

  CentOS6.4_X64 installation and configuration vsFTP-2.2.2 1, environment: CentOS6.4_X64Vsftpd-2.2.2-11.el6 _ 3.1 2, installation software and dependent software packages 1, general pam and db4 default systems have been installed

  2022-06-01 11:04:46 Views: 219
• 

  Oracle dynamic registration and static registration

  Dynamic registration: after the instance is started, pmon automatically registers the service name with the listener every minute, or manually registers the alter system register; system. By default, there is a listener; that does not need a listener.ora file to start detection.

  2022-06-01 11:04:46 Views: 203
• 

  Zabbix topic: chapter 12 zabbix proxy distributed Monitoring configuration

  Zabbix topic: chapter 11 zabbix proxy distributed monitoring configuration friends who are interested in Linux join QQ group: 476794643 online communication this article hotlink protection: http://zhang789.blog.51cto.co

  2022-06-01 11:04:30 Views: 234
• 

  Backup of WSB Mailbox Database in exchange Enterprise

  Backup preface even if the database availability rent is deployed in the enterprise, regular database backup and recovery is still the basic skills that administrators should master. WSB backs up and restores exchange, which is recommended in small-scale Exchange environments, large and medium-sized Excha

  2022-06-01 11:04:00 Views: 220
• 

  Fundamentals of mysql-data query (1)

  First, the concept of querying data: querying data, filtering data, and determining the format in which the data is output. Basic statement of data query 1, basic statement format: select field list FROM table or view where query condition 2.1 content of single table query

  2022-06-01 11:04:00 Views: 268
• 

  Database MySQL wildcards and pattern matching regular expressions

  Today, a colleague said that he wrote a sql statement that there was no result in the query. He wrote SELECT * FROM Persons WHERE City LIKE'[BLN]%'so just sort it out again: SQL wildcards use special characters or languages.

  2022-06-01 11:03:51 Views: 293
• 

  Dbca create ssh error

  Today, creating a database on top of a 11.1.0.7 database stuck after selecting two nodes, and finally reported an error: ssh problem: you have to enter the face every time you configure SSH login, and you don't know who configured it before. Because I went well with the configuration of 11.2, 11

  2022-06-01 11:03:45 Views: 241
• 

  One-click compilation and installation of zabbix3.2.5server

  The company plans to use zabbix to monitor all product servers, and now needs to test zabbix! The system adopts minimal installation, and the selected packages are as follows: BaseCompatibility librariesDebugging ToolsDevelo

  2022-06-01 11:03:44 Views: 296