Database Administrator

I read the Oracle document today and found that trim function usage is not limited to removing spaces of strings! Read the official explanation and the following experiment. I hope you can learn it together! 1. first look at the trim function syntax

Postgresql has many built-in practical functions. The following describes the grouping and cutting functions.Environment: PostgreSQL 9.1.2CentOS 5.7 finalI. Composite Functions1. concatA. Introduction concat(str "any" [, str "any" [,

Today, we help you modify a report, and design the warehouse receiving and warehouse receiving operations in it. We need to list the Daily portal information of each product. This may happen: 1. The product has data in the warehouse receiving table,

Previously, the OEM was able to open the webpage, but it was not possible to open it at work today. Enter http: // localhost: 1158/em to prompt that the webpage could not be opened.Check that: Cmd command line C: \ Documents ents and Settings \

1, database log error ORA-00327, pay attention to the garbled here Errors in file/Oracle/app/oracle/diag/rdbms/tyolap/tyolap3/trace/tyolap3_lgwr_22388.trc: ORA-00327: Too Many I 31 (too M too 3 ): WTI malong 102400 yundun 1048576 ORA-00312:

PL/SQL 9.2 cannot connect to the Oracle database. When the system is installed with Oacle 11 GB and the client is installed with Oacle 10 Gb, when pl/SQL is used to connect to the database, the connection fails. The reason is that the oracle home

The following error is always reported when you manually configure the Oracle 11g EM: WARNING: ORA-00001: unique constraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violatedORA-06512: at "SYSMAN. EMD_LOADER", line 4986ORA-06512: at line 1 No solution was

Some people have summarized the concept of Null value in the database, which is more refined. The excerpt is as follows: Null is a unique data type in the database. If a column in a record is Null, the value of this column is unknown and uncertain.

The project process is as follows:1. RAC Installation1. Experimental Platform: Oracle 10gR2 RAC + RHEL 5.4 + VMware-server-1.0.92. installation steps:(1) system requirements:Operating System: Red Hat 5.0 or 5.4Memory: 800 mbSwap space: 2048 MHard

CentOS 6.3 32-bit Operating System Default mysql5.6 configuration file # For advice on how to change settings please see # Http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** Do not edit this file. It's a template which

Some netizens recently mentioned why the historical execution plan of SQL statements cannot be viewed in dba_hist_ SQL _plan. This problem is due to the fact that the threshold value set by Oracle does not capture all SQL statements by default,

Configuration instructions:1. Use Openfiler to implement iscsi shared storage2. Implement the fence Function Through VMware ESXi5 virtual fence.3. Use RedHat 5.8 vmware-fence-soap to implement the RHCS fence device function.4. In this article, we

Preface The best way to learn is practice! Therefore, my learning is based on practice. The most basic SQL statement is the query statement. Therefore, I also learned from the select statement. (In fact, this part of the author) has been mastered,

Managing Oracle clusterware (OCR)Oracle Clusterware places the configuration information of the entire cluster on shared storage. The information includes the list of cluster nodes, the ing between cluster database instances and nodes, and the CRS

1. Oracle scheduled task: Crontab-e * ***/Home/oracle/workspace/scripts/bk_main.sh>/home/oracle/workspace/log/bk_err.log 2> & 12. Main Control Program /Home/oracle/workspace/scripts/bk_main.sh #! /Bin/bash   Dat = 'date + '% m''   If ($ dat = 0

When the -- log-slow-queries [= file_name] option is enabled, mysqld writes a log file containing all SQL statements whose execution time exceeds long_query_time seconds. Obtaining the initial lock time is not counted as the execution time. If the

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

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

In Linux, the total number of Oracle clients is less than 40 MB, which is very convenient and quick to install. 1. First, check the directory structure after downloading: Copy it to linux. 2. Use the root user in the command line window to operate

Content Define and declare a Record Record as a subroutine parameter and function return value Assign values to Record Compare Record Insert Record to database Update Record to database Constraints on insert and update Record Put the query