Database Administrator

1. Select "Enterprise Manager Configuration Assistant" in "Configuration and Migration Tools "; Create "archive database ": (1) Configure local OMS; (2) create a new archive database; (3)★We recommend that you use the "Custom" method (no need to

A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend suggested that the flashback table of oracle can restore data. After using the flashback table, the results will be good and we will learn it

Generally, it can be divided into three steps:1. Install the Oracle client. Next, you can proceed. You don't have to change anything.2. Configure the local name to parse tnsnames. ora, without directly entering the connection string.3.

There are many automatically executed jobs in Oracle10g. For example, AUTO_SPACE_ADVISOR_JOB and GATHER_STATS_JOB And so on. These automatically executed jobs will consume a certain amount of system resources while facilitating us. If you do not

1. Use two layers of nesting SELECT *FROM (select a. *, ROWNUM RNFROM (SELECT * FROM edw_t100_bal_all)Where rownum Where rn> = 21; 2. Use between... and .. SELECT *FROM (select a. *, rownum rn from (SELECT * FROM edw_t100_bal_all))Where rn

1. Under normal users1.1 view the user_tables ViewSelect table_name from user_tables;TABLE_NAME------------------------------PROJECT_MANAGESALGRADEBONUSEMPDEPT//1.2 view the all_tables view [available to sysdba users or common users]Select

1. Create a database:Create database OrderTicket;Query OK, 1 row affected (0.00 sec)2. database used:Mysql> use OrderTicket;Database changedMysql> show tables;Empty set (0.00 sec) Mysql> use OrderTicket;Database changed3. Create tables (DDL ):Mysql>

There is a table in the Oracle database. You can use PL/SQL to check that the index of the table is not dropped, but the data query on the table is very slow (the query time is about three times the original time ), then I rebuilt the index. Why is

Drop table ABC; Create table ABC (id number, name varchar2 (50), kcName varchar2 (50), score number );Insert into ABC values (1, 'zhang san', 'China', 88 );Insert into ABC values (2, 'zhang san', 'mat', 68 );Insert into ABC values (3, 'zhang san',

There are two possibilities: 1: A Background (instance) process 2: An Oracle (user) process # This is the largest possible. Processing: 1. view the CPU usage of each Session: Select ss. sid, se. command, ss. value CPU, se. username, se. program From

/U01/Oracle/bin/netca: line 178: 11819 Aborted $ JRE $ JRE_OPTIONS-classpath $ CLASSPATH oracle.net. ca. NetCA $ * It is caused by the default host name. Modify the Host Name Oracle@www.bkjia.com ~ $ Cat/etc/sysconfig/network NETWORKING = yes

MySQL table structure Id name parent_id --------------------------- 1 Home 0 2 About 1 3 Contact 1 4 Legal 2 5 Privacy 4 6 Products 1 7 Support 1 The MySQL code is as follows: SELECT T2.id, T2.name FROM ( SELECT @ RAS _ id, (SELECT@

// Overview// Basically, when you want a PLSQL (or java or c) program as a data source rather than a table,// You may use the pipeline function ).// The pipelined function operates like a table.// A pl/SQL function may be used in the database of the

During the monitoring process of the background database of a news website, the database often starts to use swap partitions, which leads to slow response of the entire application system and failure to provide services. The server memory is 8 GB,

Previously, the entire database was backed up, but because a table was accidentally deleted, the accidentally deleted table needs to be restored from the backup. If you directly import the dmp file, it takes a long time because the data volume is

1. Different identifiers. The identifier of the FUNCTION is FUNCTION and the process is PROCEDURE. 2. In a function, variable parameters are generally not used, and function values are directly returned using the function name. If a return value

DM database is a chinese database and is said to be compatible with Oracle. I personally migrated my data from Oracle11g to the database of dream 6.0 and encountered some problems: 1. Incorrect field nameAlthough dm SQL is compatible with the Case

I recently started writing the stored procedure. There is a requirement that the database table has a field (20-bit serial number, which may contain characters, and the last 7 digits are numbers ), this field must be calculated based on the quantity.

The SQL interface is used to query redo logs. Purpose:1. You can use LogMiner to recover the deleted data by mistake. Although you can also use RMAN to recover the data, it is troublesome to transfer the data and query the data before using the

The Master/Slave configuration of the mysql server, which can implement read/write splitting, or restore data from the slave database after the master database fails. Two machines are required, mysql is installed, and the two machines must be in the