Database Administrator

Oracle cursor type as input and output parameters: -- Cursor type input parameterDECLARE/* CURSOR cur_ttt ISSELECT 1 a FROM dual ;*/TYPE typ_cur is ref cursor;Val_cur typ_cur;PROCEDURE temp_sp1 (x_cur OUT typ_cur) ISBEGINOPEN x_cur for select 1 a

PostgreSQL database provides a lightweight stress testing tool called pgbench, which is actually an executable file with compiled scalability. It is described as follows.Environment:CentOS 5.7 (final)PG: 9.1.2Vmware 1, 8.0Database parameter:

Oracle middleware is used to coordinate distributed databases. It has several notable features. 1. Unified API interface, transparent to the application, the application only sees one library 2. Server Load balancer dynamically detects database

Error message: mcrypt Extensions cannot be loaded. (1) extension = php_mcrypt.dll is changed to extension = php_mcrypt.dll // remove the previous one to make it take effect. [root @ www.bkjia.com ~] # Updatedb # update a database[Root @

Command for viewing logs:1. view log member informationSQL> select group #, member, status from v $ logfile order by group #;2. view the log group information and the currently used log GroupSQL> select * from v $ log;3. Add a log GroupSQL> alter

Because the work requires a new database instance in the Oracle 11gR2 database. We recommend that you use oracle to perform the following operations. The order is as follows: 1. Create a parameter file for instance startup. Modify the default

If Oracle 11g R2 is a single-host file system:Steps:Directly upgrade db soft, data dictionary, install PSU, and install one-off patch.If the single machine uses GRID + ASM:Steps:Install patches, upgrade GI, upgrade db soft, data dictionary, install

When configuring Goldengate, we need to connect to the ASM instance. The configuration method is as follows:Oracle 10g RAC method:Add the following to the listener. ora file on two local RAC nodes:RAC1 node:(SID_DESC =(GLOBAL_NAME = ASM)(ORACLE_HOME

When we re-index a table of about 70 GB, we found that the ora 1653 error would be reported. The problem is that the temp break is not large enough, because sorting is required during index creation, as a result, a large number of temp segments are

Original environment: AIX6.1 and Oracle CRS 11g R2 without DB soft. You need to install a new database and INSTANCE, and prepare to test, upgrade, and install PSU 11.2.0.3.2. During the DBCA process, the ASM disk cannot be identified. The solution

Ubuntu does not support Oracle. online tutorials are too complex and always contain errors. Later, you can find a one that can install XE. Oracle Database 10g Express Edition requires 1006 MB of swap space Echo"Deb http://oss.oracle.com/debian/

If there is a deadlock in the Oracle database, the database will report the error code of the ORA-00060, this deadlock phenomenon is usually caused by the application logic design error, and the oracle database design has nothing to do, now we use

First, let's talk about the truncate command:Syntax: truncate table;The data in the table is cleared and the storage space is released.After the task is run, the task is automatically submitted, including other uncommitted sessions. Once the task is

One of the representatives who used NoSQL in the project years ago, MongoDB, summed up some experiences on Weibo. I would like to share with you here. Refreshing use of MongoDB in development MongoDB is a # NoSQL # database suitable for PHP

1. Uninstall the original mysql: Uninstall 1:Input:# Rpm-qa | grep-I mysqlDisplay:Mysql-libs-5.1.52-1.el6_0.1.i686Uninstall method:Yum-y remove mysql-libs-5.1.52-1.el6_0.1.i686 Uninstall 2:Input:# Rpm-qa | grep-I

During Oracle reading, data is static and there is no dirty read, that is, uncommitted data will never be read. We can understand that at the beginning of Oracle's reading, we took a "photo" for his future content and fixed all the content at a time

Parameters related to shared serverSHARED_SERVERS: Specifies the initial number of shared servers to start and the minimum number of shared servers to keep. This is the only required parameter for using shared servers. MAX_SHARED_SERVERS: Specifies

Global_name and db domain in Oracle 1. YouConnect ToSALES.US.EXAMPLE.COMAndQuery the GLOBAL_NAMEDataDictionaryView ToDetermineCurrent DatabaseGlobal name: CONNECTSYSTEM@Sales.Us.Example.Com SELECT * FROMGLOBAL_NAME; GLOBAL_NAME ------------

Special reminder before backup: 1.In the backupMySQLDatabaseMy. cnfFile,RequiredDatadir = {PATH },Otherwise, the path of the backup data cannot be found.. 2.During the backup processINNODBAfter the data file is backed up, the entire database is

For more information about Undo tablespace management, see Oracle undo tablespace management. We can use the following script to view the information of the Oracle undo segment: /* FormattedOn18:10:55 (QP5 v5.185.11230.41888 )*/ SELECTT1.USN, T2.