Database Administrator

1: view memory: grep MemTotal/proc/meminfo View swap: grep SwapTotal/proc/meminfo 2: Check the RPM package. Red Hat Enterprise Linux

In RedHat 5.5, Oracle 10 Gb cannot be easily installed. When querying data, the Chinese text displayed on the terminal is garbled: SQL> select name from scott. student where id = 23; NAME ---------- ?? Each Chinese Character displays a question

1. Install unixODBC and freetds in Linux Source code package: freetds-0.82.tar.gz?unixodbc-2.3.0.tar.gz 1. Install unixODBC Gunzip unixODBC-2.3.tar.gz Tar zxvf unixODBC-2.3.tar ./Configure -- prefix =/usr/local/unixODBC Make Make install 2. Install

1. Matlab establishes a connection to the Oracle database through ODBC 1. In Windows, choose Start> Control Panel> performance and maintenance> Administrative Tools and click data source (ODBC )" 2. Select "system DSN"> "add"> select "Oracle in your

Following are the steps to remove DB2 from Unix/Linux: 1. Remove DB [delete database first](1) su-db2inst1(2) db2 list db directory(3) db2 drop db 2. Remove Instance [Delete Instance](1) su-root(2) cd /instance(3)./db2ilist(4)./db2idrop-f 3. Remove

The from_tz function in Oracle can combine a timstamp and timzone into a timestamp with timezoneSql code. SQL>SelectFrom_tz (to_timestamp ('123','Yyyymmdd'),'America/sao_paulo')FromDual; FROM_TZ (TO_TIMESTAMP ('100 --------------------------

I have been trying to modify the rac archive mode for the past few days, but I have not done it. I have been referring to the following documents and added some operations this morning. The change was successful, it is intended to solve this problem

Found onlineNIf you have more information, none of them will succeed successfully. If you are depressed, the level may be limited ...! I have been continuously researching, testing, and fully implementedLinuxStart twoMysql, and have a better

1. The Oracle Database client was installed. The method for connecting to the oracle database on the remote server is as follows: 2. Later, the system was reinstalled and oracle was installed. The method for connecting to the oracle database on the

1. Install and start mySQL: 1. If mySQL already exists in CentOS /Etc/rc. d/init. d/./mysqld start (start mySQL and run mySQL-root) Edit the rc. local file # vi/etc/rc. d/rc. local Add the following startup command /Etc/rc. d/init. d/mysqld

I read something about the Oracle database because of some database problems. For records in a table in an Oracle database, how can we delete repeated values. I will keep a record of my practices for future reference. The data I use is oracle.

Create the table tmp_tab and use the sequence seqId with the primary key id Create sequence: create sequence seqId start with 1 increment by 1; Create table space: create table tmp_tab (id integer constraint seq1 primary key, col1 varchar2 (10),

Oracle's commit is to submit data (here the release lock is not the lock table). Before the commit, all the operations in front of you are updated with the memory and are not updated to the physical file. From the user's perspective, the execution

Install Oracle10gR2 on Red Hat 4 AS U71. Hardware requirements:========================================================== ===At least MB physical memory# Grep MemTotal/proc/meminfo========================================================== ===Swap

Today, I am reading the book "The sword breaks the iceberg". There is a logfile switch waiting problem. There are two solutions in the book: 1. increase the number of dbw processes. 2. to increase the log file size, you only need to change the

First, configure the Oracle service file in the/etc/rc. d/init. d/directory. Touch oracle10gChmod a + x oracle10g Edit the oracle10g file. The script content is as follows.Root@www.bkjia.com ~ # Vi/etc/rc. d/init. d/oracle#! /Bin/bash # Root #

In Oracle 10 Gb, you need to set workarea_size_policy to AUTO, and set the pga_aggregate_target parameter to implement memory management of PGA. SQL> show parameter pga NAMETYPE VALUE ------------------------------------------------------------

The running status of the monitoring program in the past few days. Only the. ***** is displayed when the log starts with 0.. This is used to view the program: Select to_char (num) from AAAAAA, test: SQL> select to_char (0.258) from dual; TO_C----.

UNDO function:1. rollback2. Construct CR blocks to provide read consistency3. rollback: When the instance is restored Undo table empty area status:1. free available rollback segments2. active indicates that there are active uncommitted transaction

The following error occurs when calling the Oracle stored procedure using SHELL today: PLS-00306: The number or type of parameters is incorrect when the stored procedure name is called. Summary: when the number or type of parameters is incorrect