Database Administrator

The Oracle analysis function row_number () returns an integer (> = 1 ); Syntax format: 1. row_number () over (order by col_1 [, col_2...]) Purpose: sort by col_1 [, col_2...] and return the sorted result set, This usage is a bit like rownum, and

It is easier to install MySQL in Solaris than to install Oracle. The following describes how to install MySQL in Solaris. Operating System: Solaris10Database: mysql5 Mysql-5.1.42-solaris10-i386.pkg.gz 1. Transfer media to the server I use FTP to

I. Environment 1. OS: CentOS5.5 EngLish 2. JDK: 1.6.0 _ 24 3. JCE: 1.6. 4. ANT: 1.8.2 5. Jboss: 5.1.0.GA 6. EJBCA: 4.0.1 Ii. System Environment Configuration 1. Use Xshell to connect to CentOS 2. Create a folder vane under usr (command:

-- Oracle method 1SELECT * FROM(Select a. *, rownum rn from (SELECT * FROM ss_custinfo)Where rownum )Where rn> = 21; -- Oracle method 2SELECT * FROM(Select ss. *, rownum rn from ss_custinfo ss)WHERE rn = 21;  -- Oracle method 3SELECT *

SELECT l_count, REGEXP_SUBSTR ('add, daddf, dsdf, asdfa, dsfasd, dsfad', '[^,] +', 1, l_count) AS NAMEFROM dual, (Select level l_count from dual connect by level WHERE l_count The query result is:Lcount name1 add2 daddf3 dsdf4 asdfa5 dsfasd6

An exception occurs when the maximum number of jdbc cursors is exceeded. The relationship between Oracle and jdbc has been improved. Record it for future reference. If you have any errors, please note. Oralce cursors can be divided into display

Oracle Database 10 Gb provides a significantly improved tool: Automatic Workload information library (AWR: Automatic Workload Repository ). Oracle recommends that you replace Statspack with this. AWR is essentially an Oracle built-in tool that

1. spring Configuration: Class = "org. springframework. jdbc. support. nativejdbc. CommonsDbcpNativeJdbcExtractor"Lazy-init = "true"/>Class = "org. springframework. jdbc. support. lob. extends lelobhandler"Lazy-init = "true"> classpath:/com/ffcs/crm/

An interesting question about Oracle databases: COSCO created an oracle instance zycw before the disk array was added, and a new instance zync was created after the disk array was added. In order to save system resources, we plan to enable only the

Last night, a temporary backup retained for a customer's database. The overall database capacity is about TB. Generally, the low-end storage is as follows: SQL * Plus: Release 10.2.0.2.0-Production on Thu Sep 10 14:27:39 2009 Copyright (c) 1982,200 5

A simple MySQL backup script: #! /Bin/sh# File:/home/mysql/buckup. sh# Database infoDBNAME = "test" # database to be backed upDBUSER = "test" # mysql login accountDBPASS = "test" # Login Password # Others varsBINDIR = "/usr/local/mysql/bin" #

I. Introduction to Xtrabackup and backup principles: Xtrabackup is an open-source software developed by percona. It can quickly back up and restore mysql Databases and supports online Hot Backup (data read/write is not affected during Backup ), this

SGA is the memory area used to store database information, which is shared by database processes. It contains data and control information of the Oracle server. It is allocated in the actual memory of the computer where the Oracle server resides. If

After mysql is installed, you can start the bin-log function to record database data operation records and recover data when necessary. mysql logs are divided into the following types: Error log:-log-err Query log:-log Slow query

PL/SQL is a procedural programming language for Oracle database operations. It can be executed in SQL * plus or embedded in JAVA or C ++. The basic components are as follows: DECLARE ... BEGIN ... EXCEPTION ... END It can be used to encapsulate

Because the data in many large tables is deleted in the project, the log-free method is adopted at first, and then the integration test shows that if there is an interruption during the delete process, in this case, the table can no longer be used.

I.Preparations1.Valid backupBe rightOracle softwareAnd physical backup of the database.2.Check for invalid objects.3.EnsureSYSTEMFree Space in50 MAbove.4. SHARED_POOL_SIZEAndJAVA_POOL_SIZEAt least150 Mb.5.Shut down the databaseOracleProcess.6.Backup

I recently read several pages of books, made notes, and copied a paragraph from the official Oracle documents. Of course, the Buffer Cache is far more than that, but it is really slow to read English, what I want to say most now is: I need more time.

The SGA of Oracle includes the following parts. You can view the approximate composition of sga by running the show sga command or by viewing the v $ SGA view:17:39:48 SQL> show sgaTotal System Global Area 1048576000 bytesFixed Size 1223392

Oracle Study Notes (learn from logon) 1. After Oracle is successfully installed, there will be 5 services. If you do not use the database, you 'd better disable it, which is too much content-consuming. 1. The OracleDBConsoleorcl service starts em.