NAV: SLTechnology News&Howtos > Database >

• 

  Problems of parallelism and BUFFER SORT in Oracle execution Plan

  Recently, the developer said that there is a sql on a certain system whose execution time varies from fast to slow. Let me take a look. This sql consists of four tables (2 million, 200 thousand) for inner join operation, and finally for count (*) aggregation operation. The execution time varies from 1m to 10s. View the execution meter

  2022-06-01 11:36:02 Views: 209
• 

  Monitoring deployment of zabbix system (part I)

  First, why to use zabbixzabbix is a relatively popular open source system monitoring software recently, it is characterized by simple configuration, can be directly managed and maintained through the web interface, and can customize the monitoring data and graphics, which makes it easier to use, but she also

  2022-06-01 11:36:02 Views: 266
• 

  SharePoint upgrade Web Site mode

  In the daily SharePoint operation and maintenance or upgrade, we often encounter the need to upgrade the site mode. In fact, I encountered this problem when I upgraded from SP13 to SP16, so I share it with you today. First of all, we need to know that in SharePoi

  2022-06-01 11:35:44 Views: 213
• 

  Lead lock, rebuild task

  When you fail to build an index using the maintenance plan under the database management function, it is more practical to use the agent to execute the job. The code is as follows: method 1:USE [msdb] GO/** Object: Job [Index Reconstruction] Script Dat

  2022-06-01 11:35:43 Views: 207
• 

  Simple Operation of Database MySQL (2)

  1. Data addition, deletion, modification and query 1.1 insert record 1.1.1 insert single data INSERT INTO table name (field name 1, field name 2, …... , field name N) VALUES (field 1 value, field 2 value,... , field N value); ① this is to take all the fields with

  2022-06-01 11:35:13 Views: 302
• 

  LAMP combined fundamentals WordPress, phpmyadmin installation

  1. Basic knowledge of LAMP combination 2. WordPress, phpmyadmin installation LAMPlinuxApache (httpd) MySQLphp, Python, perl, ruby An and P combination: CGI:commo

  2022-06-01 11:35:06 Views: 254
• 

  SQL Learning Log of stir-fried Pork liver (1)

  @ TOC database and SQL1. Database database is a collection of data that can be accessed efficiently by saving a large amount of data and processed by computer. The computer system used to manage databases is called database management system (DBMS). Through DBMS, multiple users can be safe and simple

  2022-06-01 11:35:05 Views: 222
• 

  [original] Oracle implements generate_series of PGSQL

  PostgreSQL has a function to generate sequences, which makes it easy to create data. Here I use ORACLE to implement the generate_series function of PGSQL. POSTGRESQL.t_girl=# select * f

  2022-06-01 11:35:05 Views: 266
• 

  The problem that linux has to use source every time after configuring oracle in ~ / .bash_profile

  Modify .bash _ profile in root mode or modify .bashrc # cd ~ # vi .bashrc to add the following environment configuration: export ORACLE_BASE=/opt/oracle/a

  2022-06-01 11:35:05 Views: 287
• 

  Database related concepts

  Database transaction: a series of operations performed as a single logical unit of work, either completely or not at all. Transaction processing ensures that data-oriented resources are not permanently updated unless all operations within the transactional unit are completed successfully. By combining a set of related operations into

  2022-06-01 11:35:04 Views: 254
• 

  RMAN configuration DataGuard from active database with filesystem

  Environment hostname, database version, dbnamedb_unique_nameIP address, system version, Jason1 (primary) oracle11204Jasonjason1192.168.1.99rhel6.6_x86_64ja

  2022-06-01 11:35:04 Views: 295
• 

  ORACLE View DBA_HIST_UNDOSTAT

  Http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_4069.htmDBA_HIST_UNDOSTAT View DBA_HIST

  2022-06-01 11:35:03 Views: 274
• 

  Installation of Oracle_11g_RAC 11.2.0.4.0 under Sles11_sp1 64bit system

  Required dependency package binutils-2.19gcc-4.3gcc-32bit-4.3gcc-c++-4.3glibc-2.9glibc-32bit-2.9glibc-devel-2.9glibc-devel-

  2022-06-01 11:35:00 Views: 238
• 

  Install MongoDB for the first time in window8

  Install mongodb on window8 for fun because of boredom. All installed are the latest version: mongodb:mongodb-win32-x86_64-2.4.3 1. Install mongodb ① first and extract the downloaded packages to a directory

  2022-06-01 11:35:00 Views: 266
• 

  Redis-trib.rb parsing

  Redis-trib.rb-create source code parsing 1. Introduce   Redis-trib.rb as the mainstream Redis management tool, encapsulate a series of Redis commands and complete Create Cluster through ruby client.

  2022-06-01 11:34:36 Views: 263
• 

  12c Oracle periodically validates backup files

  Database backup, as we all know, is normally backed up regularly every day, but few people do the verification of backup files. Once we need to use backup files, it is sad that backup files are indeed corrupted. It is necessary to do backup verification regularly once a month. RMAN > restore d

  2022-06-01 11:34:36 Views: 238
• 

  Mongodb 2.6.x the method of cleaning up oversized log files

  First, log cleaning step 1. Using the database command rotate log, log in to the mongod and mongos instances # mongo-- host localhost:27xxxMongoDB shell version:

  2022-06-01 11:34:36 Views: 294
• 

  CentOS6.3 install oracle10G

  It took a lot of trouble to install it on RedHat5.9 before, but it was installed very smoothly at that time, but I didn't expect it this time. So write down the installation process so that you don't make the same mistake again. Before installation, do not dare to install the required installation package at one time. Very

  2022-06-01 11:34:35 Views: 225
• 

  1 Redis-Linux environment variable setting

  Redis-Linux environment variable setting F: need to download the Redis package on the official Redis website (https://redis.io/download)R: use the FTP upload tool to upload the package after download, generally third

  2022-06-01 11:34:23 Views: 269
• 

  Error related to character buffer in Oracle

  1. Buffer overflow,limit of 10000 bytesdeclarebeginfor c in 1.. 1000 loopdbms_output.put_line ('test'

  2022-06-01 11:34:23 Views: 248