Database Administrator

Backup policy: Sunday level 0Monday, second, fourth, fifth, sixth, Grade 2Level 1 on Wednesday -- Create a local management path Mkdir-p/dinglp/ora_managed/backupMkdir-p/dinglp/ora_managed/backupMkdir-p/dinglp/ora_managed/backup/exportMkdir-p/dinglp/

RHEL5.5 Software Package requirements: The following packages (or later versions) must be installed: Binutils-2.17.50.0.6Compat-libstdc ++-33-3.2.3Compat-libstdc ++-33-3.2.3 (32 bit)Elfutils-libelf-0.125Elfutils-libelf-devel-0.125Gcc-4.1.2Gcc-c ++-4.

1. The insert format is. /** * Write a time Method */ Public staticStringgetStringDate (){ Date d = new Date (); SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-MM-dd "); Return sdf. format (d ); } Insert: Art. setArtAddTime (java. SQL. Date.

Environment: Red Hat Linux AS 4 Nahant x86 + Oracle 10.2.0.1 x86This document records the commands used to start and close Oracle 10 Gb database and related files.The three steps for Oracle Database 10g startup are as follows: 1. Create and start

Sqlplus/as sysdba > Select total. tablespace_name, round (total. MB, 2) as Total_MB, round (total. MB-free.MB, 2) as Used_MB, round (1-free.MB/total. MB) * 100, 2) as Used_Pct from (select tablespace_name, sum (bytes)/1024/1024 as MB from

1. the mysql-client package needs to be installed on the client. The library files we need after installation are complete; 2. Install the mysql-dev package. After installation, we need the mysql. h file; 3. As a client, you only need to install

1. query and modify the undo_retention parameter: Run the show parameter undo command to view the current database parameter undo_retention settings. Shown as follows: Undo_management string AUTOUndo_retention integer 10800Undo_suppress_errors

The first time I met Oracle, I sorted out some simple and practical solutions. Confirm orcale Recognition-it is a annotator, not recognized # Length () is a string length function, not len () Table Dual: system table, with only one option

By default, after PHPMyAdmin is installed, the information_schema database is displayed no matter what account you use to log on to the database. However, you cannot perform operations on the database. You can only view the database, this database

1. Create Or Replace FunctionPostgresql (p_tnameVarchar2, P_colnameVarchar2)ReturnClobIsV_tmpVarchar2(200);V_result clob;V_cum sys_refcursor;BeginOpenV_cumFor 'Select' |P_colname| 'From' |P_tname;LoopFetchV_cumIntoV_tmp;Exit

First, you need to repeat the related concepts. Functions in Oracle databases can only be called by others. stored procedures can be executed separately and stored procedures can be called, the role package can place any statement (process, function,

One way to access MySQL using Python in Linux is to use the MySQLdb module. The following describes how to install MySQLdb in Linux. (1) download MySQLdb Download the latest MySQLdb, http://sourceforge.net/projects/mysql-python/ from SourceForge.net,

Due to development needs, MySQL 5.5.9 needs to be installed and installed now. There are always errors when rpm is used, and there are still a lot of troubles related to the issue. In addition, no Binary Package is found, I had to find the source

Slave Oracle Storage Level Architecture, Oracle A database consists of one or more tablespaces. Tablespace : A logical storage container, which contains segments and consists of one or more data files. The relationship between segments and data

Hibernate tuning is not just about setting lazy, but about who maintains this field. This time we want to optimize the query statement -- select new map (). Description of the select new map statement. Statement 1: String hql = "select s. name from

No time to check the same configuration of the Oracle database on a daily basis. Later, it was discovered that the master database did not synchronize archiving logs to the slave database because the slave database was not enabled after power

One of the daily work of the system administrator is to upgrade the service, add a patch for the service or upgrade some fancy functions. In early 2013, the latest MySQL 5.6 was released with the goal of providing better performance and scalability.

1. InstallDownload the compiled installation package or pre-compiled installation package. Here, use the pre-compiled version. [@ S1.yejr.com ~] # Tar zxf mysql-proxy-0.6.0-linux-rhas4-x86.tar.gz [@ S1.yejr.com ~] # Cd

1. Preface Recently, due to project requirements, the employee's working group needs to be returned to the front-end. However, in the database, the employee's working group Id is included in a field (separated by commas ), this does not meet the

The experiment is divided into two steps:1. LMT local management of tablespaces, ASSM automatic segment management when the data file structure analysis Oracle 11G: 0 operating system block, 1-2 is the file header, 3-127 is the bitmap information.