Database Administrator

Some performance Alarms can be found through the dba_outstanding_alerts table. If the locked table cannot be released for a long time, the sid and serial # Of the relevant session can be found here #. select * from dba_outstanding_alerts

I am writing a small website job today. I can use jsp to insert data to MySQL in Ubuntu 8.10. Both English and numbers can be inserted, but Chinese characters won't work. I used all the jsp Chinese characters. I tried to use mysql query browser (a

The following process is a step-by-step installation step. 1. Install the RPM packageRpm-aq | grep libgcc // check the package fileRpm-Uvh * // install all package filesBinutilsCompat-dbCompat-libstdc ++Control-centerGccGcc-c

In database operations, delete, insert, and update databases are often required. When a table changes, other tables can be changed accordingly. Write down below, today I have studied the trigger knowledge in Linux for one day: Delete --> oldInsert --

IDC statement: This article published by does not mean that you agree with it or confirm its description for the purpose of transmitting more information. Today, I finally installed a new Ubuntu 8.10 virtual hard disk in the vbox. It is estimated

Not long ago, the machines used for the company were really slow. I was so angry that I had formatted Windows and installed the Ubuntu operating system. However, a problem occurs in the Java program: 1. Default Character Set settings for MySQL:

Notes for installing Oracle 11G in Ubuntu 9.04:(1) Oracle does not support Ubuntu and is related to the Linux kernel version,(2) Pay attention to conflicts between Oracle and local JDk and Chinese garbled characters.Local parameters:(1) Ubuntu

At the recent Oracle OpenWorld 2009 Conference, Oracle released the latest server virtualization product Oracle VM 2.2, they also said that their users will be able to use this product to accelerate deployment and simplify the management of

1. Create a tablespace for the experiment. Create tablespace block datafile size 1 M extent management local;-because it is 11 GB, AMS is used. Alter user ff default tablespace block; Alter user ff quota unlimited on block; 2. corrupt data

1. The LONG data type stores variable-length strings with a maximum length limit of 2 GB. 2. For text that exceeds a certain length, the LONG type can only be used for storage. Many objects in the data dictionary are defined as LONG. 1. The LONG

MySQL compilation and Installation notesThe premise is that your Linux system should build the GCC compiling environment.If CentOS is used, you can:Yum-y install gccYum-y install gcc-c ++Add MySQL user groups and usersGrounadd mysqlUseradd-g

Grant select any dictionary to scott;Create table t1 as select * from emp;Insert into t1 select * from t1;-- Check the storage partition records whose segments are T1 under scott.Select segment_name, extent_id, file_id, block_id, blocksFrom

In essence, a view is only an SQL statement, but MySQL does not store the SQL statement.Instead, we save the view definition in the form of a file like a table, and use. frm to exist.The SQL statement displayed with show create view is

Question: Oracle 11g Rac is more difficult to maintain than 10g, and more commands are provided, this section summarizes the Votedisk, OCR, and some commands used for resource maintenance of 11g rac for future reference. Recommended reading: Oracle 1

One reason for triggering ora-01200 errors [Oracle @ oracle ~] $ Oerr ora 1, 0120001200,000 00, "actual file size of % s is smaller than correct size of % s blocks"// * Cause: The size of the file as returned by the operating system is smaller//

In projects, tasks that need to be completed regularly, such as regularly updating data and defining statistical data to generate reports, can be completed using Oracle jobs. The following section describes how to automatically create a table in an

Environment: AIX 6.1, Oracle11g ASM After the ASM instance is installed and started properly, the ASM disk group can detect it. Oracle software is installed normally. Then, when creating a database in DBCA, select the ASM disk until the file storage

When using mysqldump for backup, if the storage engine is MyISAM, you can only implement warm backup, and you need to use the option -- lock-all-tables to lock all tables. If the storage engine is InnoDB, The -- single-transaction option can be

For example, I have a user class that contains a label attribute. This label is an array and the elements in the array are embedded documents. The format is as follows: {"_ Id": "195861 ","Tags ":[{& Quot; tagId & quot;: NumberLong (766 ),"OptDate":

Required dependent LibrariesConfig: IniFilesMIME: LiteDBD: mysqlDBISys: SyslogWe recommend that you use CPAN for installation. First, obtain the global read lock, write the data in the cache to the disk, then execute the LVM snapshot, and finally