Database Administrator

PL/SQL cursor usage Use of cursors ① Cursor ConceptTo process SQL statements, Oracle must allocate a region called context area to process required information,This includes the number of rows to be processed, a pointer to the expression after the

RMAN -- Differences Between obsolete and expired If you can understand the sources of the two States, You can naturally understand the differences; EXPIRED status: This status is related to the crosscheck command. The crosscheck backup command

Build a GoldenGate bidirectional replication environment from Oracle to Oracle Objective: To build a Goldengate two-way replication environment (DDL + DML supported) from Oracle to Oracle ). Environment: OS: Red Hat Enterprise Linux Server release 5

Oracle jobs regularly execute stored procedures to refresh materialized views and record exceptions In Oracle, jobs regularly execute stored procedures to refresh the materialized view and record exceptions (My materialized view cannot be refreshed

How to archive log files when using RMAN backup I went to a customer yesterday to deploy RMAN backup. when I ran the shell script, I was prompted that I could not find the archive log, because the customer only performed EXPDP logical export backup

Corosync achieves high availability of MariaDB Database Service Solution: Corosync + pacemaker provides HA solutions. Use the shared file system exported by the NFS Shared Server as the data directory; The topology is as follows: Install LAMP

11g new feature _ visible and invisible index, and 11g new feature index visible When you want to evaluate the impact of an index on your SQL query statement, when your database is 11 GB, you can quickly set the index to VISIBLE or INVISIBLE. In

ORA-27090 fault case and ora-27090 fault case The recent alert Log encountered an error message for the ORA-27090 with the error prompt Unable to reserve kernel resources for asynchronous disk I/O. According to this prompt, It is a kernel parameter

Oracle learning-literacy: oracle literacy Preface   I have been dealing with Oracle databases over the past few days. Since I have not learned much about Oracle before, I just used Oracle as a data source. I don't know much about it. For example,

Oracle data file structure, oracle Data Structure Oracle data structures are divided into physical and logical structures. Physical Structure: data block of the Operating System-> data file datafiles Logical Structure: Minimum database block -->

Test the impact of the stored procedure status on execution, and test the Stored Procedure status.Purpose: Test the impact of the stored procedure status on the operation of the stored procedure.Environment preparation: 1. Create a test table

Project Summary-basic steps for JDBC database access-jdbc Data AccessFollow these steps to access the database through JDBC:(1) load the JDBC driver of the database to classpath. during actual development of Java ee-based web applications,Usually

Database Import and Export instance, Import and Export instance Import and Export instances: All the following commands are entered in the DOS window! User Creation reference: http://blog.csdn.net/gateway6143/article/details/41212823 　　 I. Data

Oracle (+) connector usage, oracle connector usage In the Oracle PL-SQL, left and right connections can also be implemented as follows Example: SELECT stu_name, class_nameFORM students, classesWHERE students. classid (+) = classes. id The

Use pipelines to migrate data and pipelines to migrate dataWhen the disk space is insufficient, use the named or anonymous pipeline to migrate and import data. Pay attention to the permission of the named pipeline. 0. Name PIP 0 [pg @ h1 ~] $ Psql

Several items to be set for PowerDesigner and several items for powerdesigner After installing PDM, You need to design several items for easy use. 1. Do not associate the name with the code automatically. We do not want the associated code to change

Tinyint data type in mysql, mysqltinyint The mysql database defines the data type as "data type (m: Here, the number m represents different meanings in different data types. The integer system has limited the value range. For example, tinyint

The maximum number of connections to view and modify in oracle, and the maximum number to view in oracleStep 1: In the cmd command line, enter sqlplus or directly open command window in plsqlStep 2: Enter the user name and password as prompted1.

What is a tablespace? 1. view the tablespace and datafile corresponding to a userSelect t1.username, t2.tablespace _ name, t2.file _ name, t1.temporary _ tablespace, t3.file _ nameFrom dba_users t1Left joinDba_data_files t2On t1.default _ tablespace

SQL for xml query sample, xmlsample Sample 1: declare @x xml select @x=' EveryMonday 2000-01-01T19:30:00 EveryThursday 2000-01-01T19:30:00 EverySunday 2000-01-01T19:30:00 'SELECT