Database Administrator

For some current releases, three dynamic performance views are available for DBAs (Database Administrator, Database Administrator) and developers, namely V $ SQL, V $ SQLAREA, and V $ SQLTEXT.These views can be used to collect statistics about SQL

There are several terms involved, which can be explained as follows:Policy: A security Policy. A security Policy is a set of level, compartment, group, and label.Level: Level. This is the most basic security control Level and must be set.Compartment:

Since Oracle said it was about to provide Linux support at half the price, choosing Oracle or Redhat has become a big problem. However, Gartner recommends that users who want to use Oracle services first test system compatibility and decide whether

Installation File mysql-gui-tools-5.0r11.tar.gzTo setup mysql-gui-tools:Get root right to do it!Shell> tar zxvf mysql-gui-tools-5.0r11.tar.gzShell> cd mysql-gui-commonShell>./configureShell> makeShell> make installShell> cd

Like Mysql in windwos, the default settings are latin1. they are not the gbk we need, or big5. so we still need the user's settings:Whether the login uses telnet or directly enters mysql in Linux: Find the my. cnf file

Today, I learned from the official MySQL website that MySQL announced the closure of the Enterprise Server Source code, which is a heavy blow to open source enthusiasts. Although free users generally only use MySQL Community Server (open-source free

Using foreign key in Mysql is not as simple as Oracle and access. The following describes the issues that should be paid attention to during use:Step 1: Create a tableFirst, open the command line window, enter the Mysql bin directory, select the

When debugging the Oracle EM service on the local machine, the following interface is often displayed: "the security certificate of this website is faulty ". You often directly click "continue to browse this website (not recommended)" to enter the

1. First, use a statement to query data segments with a capacity greater than 1 GB. Select segment_name, sum (bytes)/1024/1024 from dba_segments group by segment_name having sum (bytes)/1024/1024> 1000; The following result is displayed: SYS_LOB00

Symptom C: \ Users \ CHEN> sqlplus "/as sysdba" SQL * Plus: Release 11.2.0.1.0 Production on Wed Oct 10 13:31:28 2012 Copyright (c) 1982,201 0, Oracle. All rights reserved. Connected: Oracle Database 11g Enterprise Edition Release

Memcached is a distributed memory object cache system, which is usually used for dynamic Web applications to reduce database load. Memcached is a hashmap based on a storage key pair. When the table is full, it is replaced by the LRU (least recently

1. Read only table description Before Oracle 11g, if we want to set a table to read-only, we can grant some users the select permission. But for the table owner, it is still read/write. In Oracle 11g, we can directly set the table's read and write

Installing mysql using yum saves many steps for installing the source code package, but sometimes the problem that mysql cannot be started when mysql service is started after yum is packaged with mysql is reported as follows: can't connect to local

Recently, the Oracle 10g RAC migration under the virtual machine, after the migration is completed, the Oracle cluster resource VIP cannot start normally, received the CRS-0233: Resource or relatives are currently involved with another operation

Two users, jytest and jytest1, both have dba permissions. In jytest1, a user creates a table named test. Create user jytest identified by "jytest" Default tablespace users temporary tablespace temp;   Grant dba to jytest; Grant resource to

Today, when logging on to Oracle Data encountered a ora-01033: oracle initialization or shutdown in progress this problem, the company server database is 9i, using vm login on the server db and API have restarted the login or error, and then on the

Experiment with SQL profile fixed execution plan Oracle has outlines before 10 Gb, and SQL profile after 10 Gb is one of the new features. Outlines is insufficient for SQL statements that are not bound to variables. The following is the experiment

The following are some steps to change, but the startup problem still exists. It is easy to modify the SID of a single-instance database. You only need to modify the pfile-related parameters to mount the database. The RAC environment is actually the

Modify the default MySQL engine to innodb. 1. Stop the mysql Service #/Etc/init. d/mysqld stop 2. Back up my. cnf Cd/etc Cp my. cnf my. cnf_bak 3. modify my. cnf [Mysqld] Later # Vi my. cnf Default-storage-engine = InnoDB 4. Delete ib_logfile0 and

Background: Now, I want to practice Incremental backup of rman. The original test database is in non-archive mode. After the shutdown instance is shut down, the open instance cannot start. Sys @ Oracle10> alter database open;Alter database