Database Administrator

1. Install jdk in Linux)We recommend that you download the binfile from the sun homepage. After running the file, you can create a java directory in/usr /. Commands in Linux Bin # Chmod + x j2sdk-1_4_2_04-Linux-i586-rpm.bin #./J2sdk-1_4_2_04-Linux-i5

1. Oracle single row FunctionsOracle character functions 1.1LOWER: lowercase string;Select LOWER ('help') from dual ---> HeLpUPPER-case strings;Select UPPER ('help') from dual ---> HeLpINITCAP upper case of the first letter of the string, and lower

Starting from MySQL 5.0.2, the server cursor is implemented through the mysql_stmt_attr_set () c api function. The server cursor allows the server to generate a result set, but does not transmit it to the client unless the client requests these rows.

MySql was sold to Sun for $1 billion a few months ago. As the boss of Mysql, the former CEO of MySql and the current senior vice president of Sun's database, Marten Mickos, recently seems in a bad mood. Why? Marten Mickos was questioned at the Linux

This is the operation procedure in Ubuntu. It will be different in other Linux systems, and the principle is similar in general. Preparation 1 download ruby-oci8's latest stable version ruby-oci8-1.0.2.tar.gz2 install Oracle-xe-client first3

Run the following command to view the table structure in MySQL: Desc table name;Show columns from table name;Describe table name;Show create table name; Use information_schemaSelect * from columns where table_name = 'table name '; By the way:Show

It took a week for the project team to configure RAC. Because I had no experience before, I had a lot of detours in the middle. It was also done by making great efforts on GOOGLE. It's not easy to think about it. Now we have to record the problems

To install MySQL In Debian, follow these steps: Debian:/# apt-get install mysql-server After installation, the root account has no password by default and can be changed. Debian:/# mysqladmin-u root password $ (yourpass) You can modify some

In Oracle databases, the database administrator not only takes a certain amount of effort in selecting indexes. In addition, you should pay attention to the storage of indexes. Because indexes are the same as tables, you not only need to save the

First, we will introduce some parameter descriptions related to the CBO computing cost and how to calculate the cost of CBO in queries. Next, we will provide a general method for analyzing 10053 trace files. Finally, we will discuss how to analyze 10

This document is about installing and configuring Oracle10g RAC on RedHat Advance Server 3.0. It is not only an installation test, but also an actual layout process of the production system. Therefore, it includes RAC installation, local listening

MySQL synchronization in the slave database has been stopped, Use show slave status \ G to view Slave_IO_Running: No. The server Load balancer instance fails to be started, and no error code is displayed. The following error is reported in the

I. System Requirements1. At least 1 GB physical memory; check command: # grep MemTotal/proc/meminfo2. Set the swap space. Check the command: # grep SwapTotal/proc/meminfoSwap space size recommended for actual memory-----------------------------------

I. Completely recovered RMAN Full recovery refers to the use of the RESTORE command to dump the backup (to the original storage location or available devices) when the data file fails to contain media ), then, use the RECOVER command to restore the

Create or replace procedure tj_data is-- Variables used in the current Stored ProcedureV_tableName VARCHAR2 (100 );V_ SQL varchar2 (200 );V_count integer;-- Obtain all tables in the current databaseCURSOR TABLE_LOOP is select Table_name FROM

For the Oracle RAC cluster database, it has never been clear about how to achieve load balancing in terms of high JOB. I have tested it over the past few days and come to the following conclusions. At what level can a JOB be customized. If a job is

This is the source code package installation. Installation environment: CentOS 6.3 64-bit 1. Install the dependency package first (otherwise, an error will be reported during configuration !) Yum-y install ncurses * libtermcap * Create a mysql user [

It took a long time to see a friend importing data! There are actually a lot of quick methods to work out! There are many ways to insert data into a table, but the performance varies greatly due to different methods. ---- 1. original statementDrop

Oracle has two storage structures: Logical Storage Structure and logical storage structure. The logical storage structure is the core of the Oracle database storage structure. The logical storage structure of Oracle is a hierarchical structure

SQL Tuing Advisor (STA) is part of the automation Tuning Optimizer. In the previous article, I used SQL tuning advisor (STA) to automatically optimize SQL statements to describe the background of SQL Tuing Advisor (STA) and provide examples. This