Database Administrator

Non-Oralce user environment variable configuration In the project, you need to configure environment variables for web users of the same server to execute sqlldr of Oracle, and record the implementation steps and problems: (1) copy the settings of

Preparations before installing Oracle 11g RAC in Linux Installation environmentOperating System: RHEL6.2 64bitOracle Database Version: 11.2.0.3Oracle Grid: 11.2.0.3 Software: RHEL6.2 64bit, linux_11gR2_grid, linux_11gR2_database Configure rac ip ----

An example of ORA-00257 archiver error. error Solution An Oracle vulnerability is found here. For example: DELETE JEW_LOG WHERE C_ID IN (SELECT C_ID FROM BAS_BATCHNO WHERE C_WARID = '028' AND C_BATCHNOTYPE = 'P ') The subquery in this DELETE

[Translated from mos] Note: ASMB process exiting due to lack of ASM file activity, asmbexiting Note: ASMB process exiting due to lack of ASM file activity Reference Original:NOTE: ASMB process exiting due to lack of ASM file activity (Doc ID 754110.1

MySQL summary data and mysql SummarySummary data sometimes operations on a data table are not the data itself, but the summary of the data in the table, such as the average, maximum, and minimum values of a column of data. MySQL provides functions

Linux mysql uninstallation, installation, test process, linuxmysqlMysql uninstallYum remove mysql-server mysql-libs compat-mysql51Rm-rf/var/lib/mysqlRm/etc/my. cnfCheck whether there is any mysql software:Rpm-qa | grep mysqlIf yes, continue to

BIEE11g BI_server Jvm parameter adjustment, biee11gbi_server1. Find the user_projects \ domains \ bifoundation_domain \ bin directory. 2. Copy startWeblogic. sh is the new file startAdminWeblogic. sh, copy setDomainEnv. sh to setAdminDomainEnv. sh,

Oracle instant client, tnsping, tnsnames. ora and ORACLE_HOME, oracletnsping Some time ago, I had to remotely connect to the oracle database, but I didn't want to install the oracle client on my computer. So I downloaded the lightweight client

Ii. redis hash operations, redishash================================== Two types: hash type ============================Description: redis-> hash is a string type field and value ing table.Hash is especially suitable for storing objects. It stores

Display the numbers in the database as text, and sort the numbers in the database We often have such a rule in the database: 1 indicates male and 0 indicates female. However, you cannot display 0 or 1 on the page. You must convert the gender

10.2.0.4 to 10.2.0.5 Installation of Patch Set Release (Windows) Environment: 10.2.0.4 cluster database zlm10g (dual-node, zlm10g1, zlm10g2) System: Windows 2003 Server 64Bit Memory: 2 GB RAM Storage: ASM Objective: To upgrade the cluster database

select case when status='UNUSABLE' then 'alter index '||owner||'.'||index_name||' rebuild online compute statistics;' when to_number(degree)>1 then 'alter index /* '||degree ||' */'||owner||'.'||index_name||' noparallel;' end

1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard

SQL Statement tutorial (11) Group Now let's go back to the function. Remember to useSUMThis command is used to calculate all Sales (turnover! What should we do if we want to calculate the turnover (sales) of each store (store_name? In this case, we

Su-mysql-c "mysqld_safe-skip-name-resolve-open-files-limit = 4096 &"Cd/usr/local/mysql/bin/Mysqldump-u username-p password-databases Database Name>/backdata/ddd07-11-15. SQLMysqldump-databases zt>/data/ok1.

Chapter 1 Check System Status 1.1 Use sar to check whether the operating system has IO Problems1.2 Focus on memory vmstat1.3 find the sessions and statements executed by Oracle with extremely large resources1.4 search for the top 10 SQL statements

EF provides the function of updating some data of an object while retaining other data. 1. Re-instance an object and give the ID and fields to be modified. Note: The entity here cannot be queried from the database, but can only be a new instance.

Building oracle11G DG in linux (III): Building a slave Database Environment Name Master Database Slave Database Host Name Bjsrv Shsrv Software Version RedHat performanise5.5, Oracle 11g 11.2.0.1 RedHat

22. You need to create a table for a banking application. One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period.2) The data in the column shoshould be stored in a

Drop procedure if exists P_SEQUENCE; /** temporarily omitting the package @ auto liangrui 2014/6/27 T_PRO_PRODUCT table sorting: sort the entire table by sequence number. Sort the sequence number by sequence number from the creation date of the