Database Administrator

Share the Android sqlite export and data operation experience. Sqliteadmin.zip is a sqlite visual management software. I uploaded a download channel in csdn. 1. Set the environment variable: Add X: \ android-sdk-windows \ platform-tools (based on

In Oracle 11g, you can use the REGEXP_COUNT function. REGEXP_COUNT returns the number of times the mode appears in the source string, which is used as a supplement to the REGEXP_INSTR function. Note that although COUNT is a set function that

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or

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

I. Check hardwareView memory and swapSpaceAnd disk SIZE command: # grep MemTotal/proc/meminfo" # Grep SwapTotal/proc/meminfo2 G']. Q8 O (A # E# Df-h8 l! B % k s 'd; c6 R# Df-k/tmp8 A; k5 f. k j (q % q8 TRequirement: The minimum memory required is 256

DBWn: the Database Block Writer is responsible for the background process of writing dirty blocks to the disk. CKPT: The Checkpoint Process is only the header of the file for updating the data file to assist in creating the Checkpoint Process (DBWn )

1. view the tablespace size and maximum value of undo.Select t. file_name, t. tablespace_name,T. bytes/1024/1024/1024 "GB", t. maxbytes/1024/1024/1024 "Max GB"From dba_data_files t where t. tablespace_name = 'undotbs1'Data

In linux, the upgrade from 10.2.0.1 to 10.2.0.4 is performed. The main process is recorded below: 1. Download patches Patch: p6810189_10204_Linux-x86.zip can go to Oracle official website download 2. Preparations before Upgrade and Installation 1.

In the Execution Plan, the CARTESIAN cartesian Product sometimes appears. Simply put, What Is CARTESIAN? There are two sets. Any member of each set must be associated with any member of another set... below are some experiments on cartesian: SQL>

1. open_links meaning OPEN_LINKS_PER_INSTANCE specifies the maximum number of migratable open connections globally for each database instance. XA transactions use migratable open connections so that the connections are cached after a transaction is

Oracle Database partitioning is an important means and method for optimizing the performance of Oracle databases. Before doing the project at hand, I only heard the name of an over-area, when I was talking about it at a seminar, I told myself that I

When a user remotely connects to the MySQL database, the connection may fail because of the following reasons: (1) the lowest possible cause-the network is disconnected. Including physical connection failure, network disconnection, and other

Run the following command to install MySQL in Fedora:Yum install mysql-server Then we create a system startup connection for MySQL (in this case, MySQL will be automatically started when the system starts) and start the MySQL server: Chkconfig --

Checking Network Configuration Requirements... Check complete. The overall result of this check is: not executed I checked it on the Internet and many of my friends encountered this problem, but it was easy to solve it. You only need to install

InOracleIf the modification operation is submitted incorrectly,Then you want to view and modify the original value.,In this case, you can use the query to flash back.(Query flashback ). You can query the flash back based on a time value or a

1. Install unixODBC Download the installation package.UnixODBC-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-devel-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm InstallRpm-Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpmRpm-Uvh

When learning Oracle date functions, there are several examples in the Tutorial: Months_between ('01-sep-95 ', '11-jan-94 ') Result: 19.6774194 Add_months adds the expected month to the specified month. For example: Add_months ('11-jan-94 ',

OracleTablespace (TableSpace), Segment (Segment), Disk Area (Extent), Block (Block).OracleThe allocation unit used to save database objects SegmentIt is a database object that consumes storage space, such as tables, indexes, and rollback segments.

(1) copy the table structure and copy the data in the table at the same time. Create table 1 as select * from table 2; (2) copy the table structure. Create table 1 as select * from table 2 where 1 <> 1; Of course, the where clause can also be: 1

1. Check the current data file. Seven data files are displayed on drive F.SQL> select name, file # from v $ datafile; NAME---------------------------FILE #----F: OraclePRODUCT10.2.0ORADATASGECSYSTEM01. DBF1 F: ORACLEPRODUCT10.2.0ORADATASGECUNDOTBS01.