Database Administrator

Query the connection information in the database. SQL _COMMAND is an SQL statement that can release a process: Select. SID, B. SPID,. SERIAL #,. lockwait,. USERNAME,. OSUSER,. logon_time,. last_call_et/3600 LAST_HOUR,. STATUS,'Orakill' | sid | ''|

SQL> select * from t_char;--------------------A_ BAcbA % BA' BA/BA \ B%_ASQL> select * from t_char where a like 'A _ B ';--------------------A_ BAcbA % BA' BA/BA \ bSQL> select * from t_char where a like 'a \ _ B 'escape' \ ';--------------------A_

Most databases are composed of two distinct parts: the backend (where data is stored) and the front end (a user interface used to connect data components ). This architecture separates the user interface from the data layer. In this way, a third

Platform: RHEL4.5, Oracle10.2.0.1Plan: db_name = ORCLDB, db_unique_name/ORACLE_SID = WENDINGThe above two parameters can also be set to the same, here is the main difference. 1. Set Environment Variables$ Export ORACLE_BASE =/u01/app/oracle$ Export

When the Oracle archive log is full, you cannot log on to Oracle normally. You must delete some archived logs to log on to Oracle normally. 1. Delete physical files of archived logs. archive logs are generally stored in the archive directory. The

When PowerDesigner is used, the font size and color of the default table are very difficult to see. If you set the font color through Symbol ---> Format, you can only modify the selected most and the newly created Table is invalid. You can modify

Zookeeper manages voting disks 1. Some things that must be known about voting disk:We can use the dd command to back up voting disk before 11g, But oracle no longer supports using dd to back up voting disk after 11g.If the dd or cp command is used,

Introduction to Oracle elastic uard  I. Basic principles of DataGuard When a transaction changes the data in the production database, the Oracle database records the change in an online redo log file. You can configure the log Writing Process in the

You can query from v $ SQL or v $ sqlarea in a short period of time. If you want to query within a week or a month, you may not be able to find it in V $ SQLAREA! The following is obtained through history DBA_HIST_SQLSTAT, Which is retained through

I introduced the use of triggers in my previous blog, and also mentioned that triggers are a special stored procedure. What is a stored procedure? They What are the differences between the two? In fact, the main difference is that the trigger is

1. Types of SQL parse SQL parse is usually divided into hard parsing and soft parsing. When SQL is executed for the first time, hard parsing will occur, and subsequent execution will be soft parsing if it can be found in the shared pool. Therefore,

SQL dialect configuration for oracle, mysql, and sqlserver databases in hibernate4 (SQL Dialects)  Database Type Hibernate SQL Dialect DB2 Org. hibernate. dialect. DB2Dialect DB2 AS/400 Org. hibernate. dialect. DB2

/** Normal paging * 10 records at 1000000 offset on the data file */select * from zol1__92game_net_ecms_bjwhere classid = 303 order by id ASCLIMIT limit, 10; /** efficient paging * 1. Search for the starting Index * 2. Search for 10 results from the

MySQL database Master/Slave server in Linux 1. Network ConfigurationServer:[Root @ CentOS mysql-5.0.40] # ifconfig eth0Eth0 Link encap: Ethernet HWaddr 08: 00: 27: 56: AAInet addr: 2.2.2.135 Bcast: 2.20.255.255 Mask: 255.0.0.0Inet6 addr: fe80: a00: 2

Ora-600 (3020) error was encountered today while restoring a set of test LibrariesSQL> recover datafile 6;ORA-00279: change 1981277 generated at 01/03/2014 14:24:15 needed for thread 1ORA-00289: suggestion:/opt/arch/archive_rj45_834576965.arcORA-0028

Because you do not want to use the background code, you want to use the Oracle trigger for Operation updates. But because the trigger updates the base table, deadlock occurs. Therefore, you can use global variables on the Internet to solve this

1. tablespace description In the previous article (RMAN backup and recovery control file loss), we explained how to control file loss and how to deal with backups in RMAN. This article explains how to deal with offline data file loss. A tablespace

Batch insert operations on the List Object List in MyBatis: First, you must define the Then: InsertOrdersdish (id, ordersId, dishId)ValuesSeparator = ",">(# {Item. id, jdbcType = VARCHAR}, # {item. orderId, jdbcType = BIGINT}, # {item. dishId,

Summary: due to frequent data updates and fast data volume growth, the machine disk cannot keep up with the pace. The database shard and migration history database are used. Currently, data is optimized to reduce disk space occupied by data and save

Set the database to start several dispatcher (start three dispatcher) SQL> alter system set dispatchers = '(protocol = tcp) (dispatchers = 3 )' Set the maximum number of dispatcher instances that can be started in the database at the same time