Database Administrator

Oracle 10 Gb provides a web-based management tool db control, which is similar to Oracle 9i OEM tools, but has greatly improved its functionality. A management tool is created when you create a database instance. However, this tool is closely

Environment: CentOS 5.6X64 Oracle 10G Clusterware database This step has been tossing for a long time. First After a long time I finally found the reason. I thought that the rsh service is not required for as5 or later versions. Therefore, the

-- Book tableCreate table book (Book_id VARCHAR2 (20 ),Book_name VARCHAR2 (100 ),Book_publish VARCHAR2 (100)); -- In indicates the input parameter. The default value is in.-- Out indicates the output parameter.Create or replace procedure sp_pro7

1. Use Groovy in EO attributes Excellent: Simple and Direct Missing: disconnected number (New Oracle. jbo. server. SequenceImpl ("XXXX_SEQ", adf. object. getDBTransaction (). getSequenceNumber () 2. assign values to attributes in the create method

1. header file. The API is included in the mysqlclient library. # Include -Lmysqlclient must be added during compilation. 2. Create a variableMYSQLMysql The MYSQL structure represents a database connection handle, which is used by almost all MySQL

We only need to bypass hibernate to call the jdbc API. Of course, the transaction is managed by the hibernate industry:Assume that the following stored procedure is created: Create or replace procedure batchUpdateCustomer (p_age in

When importing the attachment table AFFIX, the data volume is more than items, but AFFIX has a large blob field, which makes the query very slow, the network in the working environment is very unstable. I started to import it for about half.

Record memo: Pfile: Mercury. _ db_cache_size = 289406976 Mercury. _ java_pool_size = 4194304 Mercury. _ large_pool_size = 4194304 Mercury. _ Oracle_base = '/oracle' # ORACLE_BASE set from environment Mercury. _ pga_aggregate_target = 301989888

1. query result set (1) Data Structure Typedef struct st_mysql_res { My_ulonglong row_count; // number of rows in the result set (long or long) Unsigned intfield_count, current_field; // Number of columns in the result set, current

Hibernate helper class (officially recommended) Public class HibernateUtil { Private static final SessionFactorySessionFactory=BuildSessionFactory(); Private static SessionFactory buildSessionFactory (){ Try { // Create the SessionFactory from

Copy the IBS library to orcl1. Create a password file on two databases: Set Oracle_sid = ibs Orapwd file = F: \ BBCLDB \ ORCL1 \ PWDibs1.ora password = system entries = 30 Set oracle_sid = orcl1 Orapwd file = F: \ BBCLDB \ ORCL1 \ PWDorcl1.ora

I. in Oracle databases, we usually use the following methods to copy or migrate records between tables in different databases: 1. The records in Table A are exported to insert statements separated by semicolons and then inserted into Table B. 2.

1. create two new log groupsAlter database add logfile group 4 ('d:/Oracle/ORADATA/ORADB/REDO04_1.LOG ') size 1024 k;Alter database add logfile group 5 ('d:/ORACLE/ORADATA/ORADB/REDO05_1.LOG ') size 1024 k;　　2. Switch the current log to a new log

This section describes how to migrate a single-instance database to the rac environment. In the production environment, as the business and data volume increase, this requirement and scenario are inevitable. Generally, the following four methods are

/Usr/bin/install-c-m 644 'libmystrings. A'/usr/local/mysql/lib/mysql/libmystrings.'Ranlib '/usr/local/mysql/lib/mysql/libmystrings.'Make [2]: Nothing to be done for 'Install-data-am '.Make [2]: Leaving directory

When we used to display the database query results on the page, we always had to judge the null field. If it was null, it would display "". Suddenly we found this method stupid, in addition, "null" appears on the page ". When using the Oracle

First, only the InnoDB Engine allows the use of foreign keys in MySQL versions available in the product environment (4.0.x and 4.1.x). Therefore, our data tables must use the InnoDB engine. Next, we will first create the following database tables

1. Link storage to ensure that the operating system can discover devices 1 2. Change the properties of the storage device file Chown grid: oinstall/dev/mxxxxx 3. Ensure that the disk discovery path of the ASM instance includes the newly added

What is a function? Generally speaking, as long as it can receive input, process input and generate output, it can be called a function. For example, a cow is a function, and it eats grass (input) and milk (output) A function is a program design

1. access the Internet through Linux: After Red Hat 9 is installed on the Virtual Machine VMware, the network connection problem occurs. Determining IP information for eth0. .. failed; no link present. Check cable? This problem has been fixed for