Database Administrator

Hibernate includes 23 jar packages, which are dazzling. This article will explain in detail the role of each jar package in Hibernate, so that you can choose based on your own needs in the application. Download Hibernate, for example, the stable

After installing the database, I found that em could not log on. I thought that I didn't notice this before creating the data. I reconfigured it. Oracle @ linux: ~> Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:44:14 201

1. Create a STRUCT type. Create or replace type STRUCT_TEST as object (NAME VARCHAR2 (50), TITLE VARCHAR2 (30), num number (2 )); 2. Create a STRUCT table and insert STRUCT data. Create table REF_TABLE OF STRUCT_TEST; Insert into REF_TABLE

First, popularize the basic concepts: PL/SQL is a programming Language that combines Procedural Language and Structured Query Language (SQL. The PL/SQL block corresponds to a small piece of code. Applicable instructions: 1. Sometimes you may need to

Now there is a table (mt) with at least million data every day, and we plan to build a partition table in the form of monthly partitions. When partitioning, let Oracle run faster 2, said p21. [SQL] SQL>AlterSystemSetDb_create_file_dest ='F: \

Oracle 10g r2 rac database modification archive to ASM1. Create related space directories on asmExport ORACLE_SID = + ASM1AsmcmdMkdir arch1 arch2ASMCMD> pwd+ DATA/RACDB/archiveASMCMD> lsArch1/Arch2/ASMCMD>2. modify a node in the mount status[Oracle @

This section describes how to back up and completely restore data in the rac environment. rac backup and recovery are compared with those in a single instance database, but they are only somewhat extended in processing archived logs. Generally,

Recently, the company is making a NoSQL model selection, and has made the following Rough Analysis and Comparison on several common NoSQL databases over a week. Glossary: Distributed Storage Unit: in distributed storage, large data files are usually

In applications, a table's primary key is often paid with an automatically increasing number, for example, the sequence of Oracle, and the expected primary key value after insertion. The following describes the related methods. 1. Use the returning

In archive log mode, there may be an annoying ORA-00257 error when the size of the archive log exceeds the maximum, as we have discussed how to increase the archive log space. In a common development environment, there is no need to archive logs. At

The control of the ADF is dragged out by VO. Therefore, if you drag the same VO into a Form and a Table on a Page, and implement Association If there is no data in VO: The Table shows no data, while the Form control does not display the outer box of

The default redo log file size of Oracle10g is 50 MB. in use, it is often found that there are a large number of Checkpoint not complete problems in alter log. We should all know what this problem is. To solve this problem, we only need to increase

The master-slave synchronization of the MySQL database has been performed for one year, and some errors are encountered during this period. You can find and solve the problems by yourself.Share with you 1 If: Slave_IO_Running = NO, Slave_ SQL

Continue with the previously installed Oracle11g R2 (see). Here we use putty to log on to the linux system. The advantage of putty is that it can be copied and pasted on linux and windows at will, it is also very convenient to copy files to each

1. installation environment: OS: Linux x86 CentOS 6.0DB: Oracle11g R1NETWORK: LAN Ii. Installation Steps 1. Check required packagesRun rpm-q to check whether the following packages have been installed and whether the version meets the

1. Modify the/etc/oratab file. The following dbstart and dbshut start the database based on the file. Soadb:/u01/Oracle/product/11.2.0/dbhome_1: Y 2. Create a database initialization file: # Cp $ ORACLE_BASE/admin/$ ORACLE_SID/pfile/init $

To prevent the mid-process output produced by semicolons, define a separator. Here, we use the mysql official example: Use two dollar signs $ as the separator, the following code is used to create a prototype of a user-defined mysql function. You

There are already many articles about NoSQL selection. Factors that affect your database include read/write throughput, persistence, consistency, and latency. The document "Visual Guide to NoSQL System" by Nathan urst summarizes this

Oracle 11g creates a function to obtain the current trace file Create or replace function current_trace return varchar2 Is V_file varchar2 (100 ); Begin Select par. value | '/' | ins. instance_name | '_ ora _' | pro. spid | '. trc' into v_file

In the RAC environment, the undo tablespace is too large: SQL> conn/AsSysdba Connected. SQL>SelectInstance_number, instance_nameFromGv $ instance; INSTANCE_NUMBER INSTANCE_NAME ------------------------------- 1 unipsms1 2 unipsms2