Database Administrator

Steps for generating an Oracle AWR report Oracle AWR generates report data by comparing the statistical information collected by two snapshots. The generated report consists of multiple parts, which is similar to the report generated by Statspack.

Ubuntu uses the Oracle Debian repository to install the Oracle server In fact, this article in Ubuntu official help page, Oracle specifically debian oracle Repository: http://oss.oracle.com/debian the repository version: Oracle 10g Express Edition (

Resolution record of two Oracle configuration problems Whether installed or running, the Oracle database involves various relationships with peripheral software and hardware. To smoothly install and run a healthy database system, you must adjust the

Introduction to Oracle XML operations in various scenarios Recently, I have been studying Oracle PLSQL's series of XML operations. Combine the knowledge and references used in the work to sort out the following content: 1. How to generate an XML

SQL Syntax of SQLite The SQLite library can parse most standard SQL languages. However, it also saves some features and adds some new features. This document attempts to describe the SQL syntax that SQLite supports/does not support. View the keyword

MySQL sets utf8mb4 Encoding There is a project that needs to store ios emojis)Although this type of expression is UTF-8 encoded, a single character occupies 4 bytes, while MySQL utf8 encoding can only store 3 bytes of characters.In MySQL 5.6, you

ORA-01144: File size (string blocks) exceeds maximum of string blocks   Today, the company's Oracle Server suddenly stops working. I encountered this error when I expanded a tablespace on a bare device. I want to know the specific reason. SQL> alter

Starting from 10 Gb, Oracle began to provide Shrink commands. If our tablespace supports automatic segment space management (ASSM), we can use this feature to narrow down the segment, that is, reduce the HWM. Here we need to emphasize that this new 1

String splitting Function Create or replace function sf_Split_String ( SourceString varchar2, -- string to be split, in the format of 'wangqingku, shanghai3h' SubString varchar2 -- delimiter ) Return Varchar2Varray Is Len integer: = length

To manage Oracle databases in Ubuntu, we 'd better use Oracle's own SQL developer software. Previously I installed DbVisualizer to manage Oracle, which is a common database management tool and convenient. On the Internet, many methods for installing

File: ---- Chinese version: navicat9_mysql_cs.tar.gz ---- English version: navicat9_mysql_en.tar.gz Install: unzip the package and use it. The start_navicat file in the directory is an executable file. Cracking: (I have found several

1. Run the MySQL server as a non-privileged user Before discussing how to start the MySQL server, let's take a look at the user identity to run the MySQL server. The server can be started manually or automatically. If you manually start it, the

Vim/etc/my. cnf add skip-grant-tables/Etc/init. d/mysqld restartMysqlUse mysqlUpdate user set password = password ("XMY_vI105VxV") where user = "root ";Flush privileges;Exit/Etc/init. d/mysqld restartWin is to modify my. ini, and the same Restart

Installation environment: Ubuntu 10.04-desktop-i386 PostgreSQL 8.4 1. Install PostgreSQL Enter the following command Sudo apt-get install postgresql The system prompts you to install the required disk space. Enter "y". The installation program is

How does navicat import SQL files? Tools-data transmission-Files How does navicat import SQL files? Navicat 8,Click the one that runs the SQL file. How can I import a local SQL database file to a mysql database? How can I use Navicat for MySQL?

1. About openrowset and opendatasourceMaybe this technique has already been used, that is, to use openrowset to send local commands. Generally, our usage is (including the MSDN columns) as follows:Select * from openrowset ('sqloledb', 'myserver';

Virtual Machine: VMware 9.0 OS: Window Server 2003 Enterprise (32 Bit) Clusterware: 10.2.0.1-> 10.2.0.4 Database: 10.2.0.1-> 10.2.0.5 I used to get used to building rac in the Linu environment. I tried to play it on Windows for the first time

Speaking of virtualization technology, I love linuxiner iner (LXC. But with the increasing popularity of Docker technology, I want to show you how to use MySQL with Docker. What is Docker? In fact, Docker is the LXC encapsulation. It is very

Today, mysqldump is used online to import data tables from one database to another. The export speed is very slow. So I searched the internet and found this stuff. After the test, I found it was good. I will share it with you. Brief

I. backgroundToday, I received a development call saying that Oracle cannot be remotely connected. It may be that archivelog is full. I tried logging on to Oracle and promptedORA-00257: archiver error. Connect internal only, until freed.Considering