Database Administrator

-- Conventional load mode---- Load. ctl FileLoad dataInfile 'C: \ 1.txt'Into table deptFields terminated ','(Deptno, dname, loc) ---- The data is as follows:10, Sales, Virginia20, Accounting, Virginia30, Consulting, Virginia40, Finance, Virginia ----

1. Open flashback: Close Database SQL> shutdown immediate; Mount Mode SQL> startup mount; If the archive is not enabled, open archive [because flashback depends on Media recovery, archive must be enabled before flashback is enabled] SQL>

I have previously set up a mongodb development environment. The operating systems are all 32-bit. Yesterday I found a 64-bit win7 system and installed it on the virtual machine. The 32-bit system runs a 64-bit Virtual Machine. No problem. The

The host can obtainCPU, Memory, process count parameters are used as reports, but it is difficult for the database to report performance parameters for a long time.StatspackYesOraclePerformance analysis is a report, but this report can only take the

To access an existing database, you must create a MySQL superuser account in Ruby. The solution is as follows: MySQL defines a method, creates a pipeline to connect to the MySql client, and outputs SQL statements.   DefMysql

Oracle controls the connection of ip addresses (we can also use database triggers to record user logon conditions, but cannot record users with dba permissions), simply set allowed IP addresses and prohibited IP addresses, before oracle9i, there was

Archive logs are stored in the Oracle RAC environment in the following ways:1. Local File System2. Cluster File System3. Network File System (NFS)4. Automatic Storage Management (ASM)The storage method of archive logs determines the backup method

As a DBA, we mainly perform the following operations for table maintenance:1. Increase the table space size.All the tables we create are stored in the tablespace. When the tablespace creation attribute is automatically extended, we usually do not

1. Compare the difference between the current time and the specified time in minutes:Select sysdate,Sysdate-to_date ('2017-04-03 13:45:39 ', 'yyyy-mm-dd hh24: mi: ss ')From dualOutput result: AM 10:45:56 0.875196759259259Select sysdate, to_date ('201

Insert binary content (image files) to MongoDB using Ruby) Ruby code Require'Mongo' Require"Fileutils" @ Conn= Mongo: Connection.New("Localhost", 30000) @ Conn. Database_names.Each{| Name | puts name} @ Db=@ Conn['Sample _ db'] @ Coll=@ Db['

1. Row-Level Lock:(The following statement adds a lock to all rows in the table)Select * from person for update; If this row of record is locked, the system directly throws an error ora-00054 without waitingSelect * from person where id = '1' for

The generated environment is different from the actual environment execution plan, so the real environment does not go through the index. The test environment takes several seconds and the real environment lasts for more than two minutes. Plan

As database software, mysql and Oracle are both based on standard SQL, but there are still some similarities and differences. Here we will list the differences: 1. limit (note that the row number starts from 0) Limit 4th: the first digit indicates

When you use Crosschecking on multiple nodes, you can configure the cluster so that each node in the cluster can access all Database backups, regardless of who generated the database backup. If your cluster is configured like this, you can allocate

1. Disable the startup of related CRS resources and stop these resources (vip, listener, scan, scan_listener, database) 1.1 disable database startup and stop on all nodes [Grid @ rac1 ~] $ Srvctl disable database-d racdb [Grid @ rac1 ~] $ Srvctl

The first time Oracle was installed, there were a variety of problems. After a while, I finally installed it. I will summarize the process and give it to myself and those who needed it! Operating System Preparation 1. OS version restrictions2. Disk

Oracle reads the SQL language used to view tablespaces. SELECT UPPER(F. TABLESPACE_NAME)"Tablespace name", D. TOT_GROOTTE_MB"Tablespace size (MB )", D. TOT_GROOTTE_MB-F. TOTAL_BYTES"Used space (M )", TO_CHAR

1. Check the system packageRpm-q compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc-c ++ libaio-devel libaio libgcc libstdc ++ libstdc ++-devel make sysstat unixODBC-devel pdksh5.2.14 Note that the package pdk5.2.14 does not

In the past two days, a program is being tested. The program has a large amount of data access to the mysql database. Recently, it was accidentally unable to be queried. Using navicat to check the server status, we found that many processes are

In Linux, use mysqldump to regularly back up MySQL databases: #! /Bin/bash PATH =/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin :~ /Bin Export PATH Export LANG = en_US.UTF-8 Savedir =/log/database_bak/ Cd"$ Savedir" Time ="$