Database Administrator

In the previous post, I answered some questions from some netizens about how to wear a stored procedure that returns a set of records. I think many netizens already understand this. I will not talk about it more here. How to call a stored procedure

When I used imp to import a database backup in dmp format today, I found that an import error occurred and reminded that the object already exists so that I can only remember to delete all tables before importing, if the database has dozens of

Build Environment: Red Hat Linux Enterprise 5.4 Oracle 10g R2 The host operating system information is 192.168.199.128. Preparation: The master database (production database) DB_NAME = mustang SID = l already exists. Start building Data Guard First,

In the previous topic, we have actually made a complete introduction to the backup and recovery of rman. We talked about the backup of databases, tablespaces, parameter files, and control files, at the same time, we also talked about their recovery,

By default, mysql compilation and installation may fail to connect to mysq server after installation, and an error is reported. "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql. sock' (2 )" This will cause a

Oracle Database Upgrade has always been a complex project. DBAs need to spend a lot of time and effort on preparation for Product Database Upgrade because of its high complexity, therefore, even if you are fully prepared, unexpected problems may

Common index-related scanning methods are as follows:Index range scan ):1. for unique index, if the where condition is followed by ,... and... if the where condition is followed by =, then index unique scan may be executed.2. For none unique index,

The Lag and Lead functions can retrieve the data of the first N rows and the value of the last N rows of the same field in a query. This operation can be achieved through table join for the same table, but LAG and LEAD are more efficient. The lag

We check whether the ASM disk space passes through the following routine: Export Oracle_SID = + ASM1 By checking the v $ asm_diskgoup view, you can check the usage of the disk space as follows:SQL> select group_number, name, total_mb, free_mb from v

Distributed Database computing involves distributed transactions, data distribution, and data convergence computing. Distributed Databases can achieve high security, high performance, high availability, and other features. Of course, they also bring

DECLAREICount number (2): = 0;BEGINSelect count (*) INTO iCount FROM user_sequences u WHERE u. sequence_name = 'seq _ TCAPITALNOTIFY ';IF iCount = 0THEN/* Create sequence */Execute immediate 'create sequence SEQ_TCAPITALNOTIFY minvalue 1 nomaxvalue

I.InstallOracle Linux 6.1System Here I use VBox for installation. For details, refer: Oracle Virtual Box installation instructions Install the following package during OS installation: Base System> Base Base System> Client management tools Base

Oracle Database backup script under RedHat Linux 5 #! /Bin/shExport ORACLE_HOME =/app/oracle/product/10.2.0/db_1;Export ORACLE_SID = orcl;Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.UTF8 ";Export F = $ (date + % y % m % d % H % M % S); # Use the

UNDO tablespace Management 1. For DML statements, as long as the data block is modified, the Oracle database retains the data block before the modification and stores it in the undo segment, the undo segment is stored in the undo tablespace. 2. undo

// There are mainly the following two system tables. pg_largeobject_metadata records the permissions mainly. Only pg_largeobject is useful. CATALOG (FIG, 2995) { Oid lomowner;/* OID of the largeobject owner */ # Ifdef CATALOG_VARLEN/*

The user reports that the front-end business response is slow. log on to the database to obtain the awr report. The system recovers after kill related sessions. For more information about kill sessions, see metalink id 786507.1.In addition to

Oracle Special Character Processing search and replacement A colleague encountered a special character matching Replacement problem a few days ago. Here is a summary. What should we do if our data contains special characters such as line breaks and

Question: Collect Oracle knowledge points that are commonly used at work, constantly update and accumulate, and use them as your own notebook. Some keywords 1Is not null. Check whether the field is null. Select*FromT_user

Run the db2look command to obtain the DDL script of the database object.DB2's db2look command is interpreted as follows:Db2look 8.2Db2look: Generate DDL to recreate objects defined in the databaseSyntax: db2look-d DBname [-e] [-u Creator] [-z Schema]

During Oracle operation, Operation errors may cause damage to internal metadata, which affects some basic functions and normal processing of the system. Once such a fault occurs, rebuilding the internal data dictionary is what we need to do. This