Database Administrator

1: Enter slqplus sytem/password as sysdba In the Ubuntu terminal to report the following error: ORA-01031: insufficient privileges, found on google ORA-01031: insufficient privilegesAfter the Oracle installation is complete, the system has an

Let's take a look at the following example: Two system tables in Oracle. emp, dept. example: 1: not exists (not in) Not exists: This statement returns the result set that the select * from scott. dept d where e. deptno = d. deptno and d. deptno = 10

Installation environment: Oracle_HOME =/home/oracle/product/11.2.0/db_1 The ORACLE_HOME/network/admin/listener. ora file is as follows: # Listener. ora Network Configuration File:/home/oracle/product/11.2.0/db_1/network/admin/listener. ora #

Oracle is used all the time, and the most recent task is to deploy and release the system. Migrating the database from the original oracle database to the DB2 database encountered some problems during the process, and I think it is necessary to

1. Check the database mode:Sqlplus/nologConn/as sysdbaArchive log list (check whether the database is in archive Mode) If not, the database archive mode is modified.Startup mountAlter database archivelogAlter database open 2. connect to the target

This document describes how to install a MySQL management tool on Ubuntu 11.04 and connect to a remote host. This article describes most of the operations on the Debian operating system. Install MySQL Administrator.First, find the software and run

Oracle was originally designed to be transaction-based, so it won't be authentic in terms of processing analyticdb. Recent developments in Oracle-related technologies have gradually adapted to OLAP needs. 1 partition technology 2 compression

The dataset data comes from the stored procedure.SQLThe statement must be compiled before execution. The stored procedure is compiled.SQLStatement. The application can be called directly when needed, so the efficiency is relatively high. Stored

I recently received an email saying that there is not enough storage space. It seems that the RAMN backup set occupies a large amount of storage space.Looking at these backup sets, there were actually two months ago. No wonder the storage space was

1. User-related processes User-related processes include user processes and server processes. A user process can be connected to only one server process However, in some Oracle configurations, multiple user processes can share the same server

Learn how to extract useful things from the vast ocean; otherwise, you will be exhausted. To put it bluntly, we will start studying GoldenGate these days. Let's take a look at what Installation and Setup Guide says. System requirements and

RAC asm restored to a single instance Rac source server: Rac1: 192.168.100.201 Rac2: 192.168.100.202 Target Server: 192.168.8.201 The recovery procedure is as follows: Restore the initialization parameter file-> modify the parameter file-> restore

Oracle 11g has made some improvements in optimization. Oracle automates the following optimization: Redo Logfile Sizing Advisor-this feature recommends Redo the optimal size of log files to avoid excessive disk I/O caused by frequent checkpoints.

When using SQL * Plus, sqlplus may require set pagesize \ set linesize \ set serveroutput every time. For convenience, you can use the login. SQL method provided by Oracle to set custom parameters in login. SQL and automatically call each time you

This article discussesIBM DB2 With complete lab steps. This article tries to make readers understand the advantages and disadvantages of various database backup methods through specific experiments, and Master IBM DB2 Database backup and recovery

I always wanted to make some contributions to PostgreSQL. Today I am free, so I wrote a tutorial on getting started with PostgreSQL 9.13... On deployment, you can move here...PHP 5.4.10 + Nginx 1.0.12 + PostgreSQL 9.1.3 source code compilation

1. preparations:Query source database platform information SQL> col platform_name for a40SQL> SELECT d. PLATFORM_NAME, ENDIAN_FORMAT2 from v $ TRANSPORTABLE_PLATFORM tp, V $ DATABASE d3 WHERE tp. PLATFORM_NAME = d. PLATFORM_NAME; PLATFORM_NAME

Oracle 10gBasic Database Query statements-above--Reference: Zhang lie Zhang Jianzhong Database Administrator training handout Principles for writing SQL statements The case is not sensitive, but the case sensitivity of single and double quotes.

Use this SQL statement Select*FromTree View the raw data as follows: The following figure shows the result of a tree query (including the fields ROOT, LEVEL, IS_LEAF, and PATH ): Execute the following SQL statement: SelectConnect_by_root

We knowRedisThere is no self-implemented memory pool, and nothing else is added to the standard system memory distributor. Therefore, the performance and fragment rate of the system memory distributor may affect Redis performance. In Redis's zmalloc.