Database Administrator

Oracle SQL tuning procedure The full name of SQL is Structured Query Language (Structured Query Language ). SQL is an industrial standard database query language used in the middle of 1980s. Do not confuse SQL with commercial products such as

Oracle 10g SQL paging query statement and Efficiency Analysis When using the Oracle database for paging query algorithm design, the paging query SQL statements can basically be applied according to the template given below: Paging Query

Directory I. Overview Ii. Hardware Platform Construction Iii. RedHat As4 update2 installation Configuration Iv. Oracle 10 Gb installation and configuration V. Red Hat Cluster Suite installation and configuration 6. system switching test VII. Common

Oracle DBAs for IT ninja turtles are commonly used to query enumeration of vomiting blood, oracledba -1. query all objects in the systemSelect owner, object_name, object_type, created, last_ddl_time, timestamp, statusFrom dba_objectsWhere owner =

Exp/imp encounter two problems (ORA-00904 and the objects were exported by ABC not by you), ora-00904exported Recently, I was responsible for setting up the user environment of a system, which involved importing data from the test environment. due

PL/SQL personal learning notes (2) and plsql personal learning notes IF condition DeclareCursor s is Select version from city_server t; S _ city_server.version % type; Begin Open s; Fetch s into s _; If s _> 2 Then DBMS_OUTPUT.put_line (s

I installed Oracle 11g on SUSE Enterprise Linux 11 Enterprise Edition. This is already very rare. I remember that 10 years ago, if you could install Oracle on Linux, it would be awesome. Now it is much simpler to install Oracle in linux than before,

Oracle creates tablespaces, creates users, and grants and views permissions. oracle Permissions Create temporary tablespace Create temporary tablespace test_temp TEMPFILE 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl \ test_temp01.dbf' SIZE 32

Data Center reconstruction-view and Data Center reconstruction Views, stored procedures, triggers, and so on have long been heard, but they have never been really touched. They have been in a future State and cannot be escaped. What happened to Data

Explanation of a piece of Oracle GoldenGate (OGG) Transfer Process log (. rpt file), goldengate. rpt This article is original. For more information, see the source. Note: /U02/ggs/dirdat/sb is the name of the trail file formed by the source

Atitit. java queue System and custom database-Based queue summary o7t and atitito7t Atitit. java queue System and custom database-Based queue summary o7t 1. Blocking queue and non-blocking queue 1 2. java. util. Queue interface, 1 3.

Use load data Infile in mysql, mysqlinfileThe speed is 20 times faster than insert. Share java program operations. package com.mysql.csv;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import

Chapter 1 Securing Your Server and Network (6): configure the firewall for SQL Server access, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I

Oracle date weekly explanation and weekly start and end time calculation, oracle End Time 1 ORACLE weekly knowledge description 1.1 date formatting Functions TO_CHAR (X [, FORMAT]): Convert X to a string in FORMAT. X is a date, and FORMAT is a

In general, Oracle 11g R2 RAC provides the following features: High Availability: shared-everything mode ensures that services are not stopped when a single node fails, and other nodes in the cluster will take over quickly Scalability: multiple

XML query in SQL SERVER: FOR XML specifies AUTO Preface In SQL SERVER, you can specify RAW, AUTO, EXPLICIT, and PATH for XML queries. This article uses some examples to introduce the XML query of AUTO in SQL SERVER. Basic example Section 1: With

SQL SERVER ranking function RANK, DENSE_RANK, NTILE, ROW_NUMBERPrefaceThis document describes how to use instance data to help you understand SQL SERVER ranking functions RANK, DENSE_RANK, NTILE, and ROW_NUMBER.PreparationsCreate a test

MongoDB best practices-Billing System Author: chszs, reprinted with note. Blog homepage: http://blog.csdn.net/chszs MongoDB best practices: You should use MongoDB in the following situations. 1) scenarios with high write Load By default, MongoDB is

Oracle can quickly load data, which is much faster than the previous batch Insertion Method (1 kW records took nearly 2 minutes ). Prepare data files Generate 1 million records in the memory vector and write them to the specified data file. #

Common script backup Automatically configure msmtp and use mail to send emails #! /Bin/bash SRC =/usr/local/src Cd $ SRC # Install msmtp client # If your want support TLS/SSL, install openssl-devel # Yum install-y openssl-devel //