Database Administrator

Background: Myeclipse character encoding GBK Oracle Database character encoding GBK The character encoding UTF-8 that inserts content from a third party using the webservice Interface Problem description: Pre-compiled by java PreparedStatement to

Before giving you a detailed introduction to Oracle Hints, let's first understand what Oracle Hints is, and then give a comprehensive introduction to Oracle Hints, hoping to be useful to you. The cost-based optimizer is very intelligent. In most

Related reading: Install and start MongoDB in Linux Advanced query example in MongoDB MongoDB Java API for insert and single collection basic query examples Query operations under MongoDB (corresponding to Java API query operations) [Root @

The CR blocks created:  Oracle metric is the number of CURRENT blocks cloned to create CR (consistent read) blocks. The most common reason for cloning is that the buffer is held in an incompatible mode.   Read consistency is used when competing

1. Environment VariablesJava code Export Oracle_HOME =/home/app/oracle/product/10.2.0/Db_1 Export ORACLE_BASE =/home/app/oracle Export ORACLE_SID = ifm30 Export ORACLE_HOME =/home/app/oracle/product/10.2.0/db_1export ORACLE_BASE

SQL> select * from v $ version where rownum BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production Create index I _test_owner on test (owner ); SQL>

1. Library Cache description LibraryCache is a component of the Shared pool in Oracle SGA. For details about Shared Pool, refer to this article: Oracle Shared pool details Here we will focus on a management mechanism of Library Cache. I have

Background: Because the Linux server used for development is in a relatively closed environment, only port 22 is accessed through SSH. Therefore, putty is used to create an SSH forwarding, which maps the port 27018 of the local machine to the remote

Many problems occurred when installing RAC. The summary is as follows: 1. During installation, ohasd cannot be started because root. sh is running at the same time at two nodes and an error occurs. Then delete and reinstall the disk. The previously

The Administrator cannot delete the DB Link created by other users (for example, emcd ): (1) you can log on to the database as an administrator, query dba_users, and write down the values of the user's emcd password: SQL> select username, password

Test Code: DECLARE BEGIN -- Most normal way to handle exception. DECLARE Except_test0 EXCEPTION; BEGIN RAISE effect_test0; EXCEPTION WHEN effect_test0 THEN Dbms_output.put_line ('Test0 effect_test0: SQLCODE ='| SQLCODE | ', SQLERRM ='

Recursive query of Oracle PL/SQL-CONNECT BY PRIOR: Duzz $ scott @ orcl>SELECTEmployee_id, last_name, job_id, manager_id 2FROMEmployees 3 STARTWITHMaid = 101 4CONNECT BY PRIOREmployee_id = manager_id; (PRIOR: Previous, with priority; perform

Skip the theoretical things and go to the web page to introduce automatic sharding. Or test with million data Insert million pieces of data to a database without sharding. Data storage: Performance_^ [root @:/usr/local/mongodb/data/mongodb/test] #

Description:Originally, one-way transmission of Streams was directly configured on two database servers,The original source database is two clusters of 64-bit HP-UNIX Oracle11gR2 database,The original target database is a 64-bit Linux Oracle11gR2

Because the data structure design of some modules of the project is not strictly in accordance with certain specifications, the data structure can only be queried from the database. The information to be queried is as follows: field name, data type,

An error occurred while backing up CentOS 5.6x64: RMAN> backup archivelog all format = '/opt/Oracle/backup/arch _ % T _ % s _ % p. Bak ';Starting backup at 31-AUG-11 Using target database control file instead of recovery catalog Allocated channel:

Oralce has a special "Take care" of the position after sorting the NULL value, which is the "nulls first" and "nulls last" options, with this option, you can forcibly specify the position where the NULL value appears in SQL sorting (whether it is

The following is an article about SQL Injection found on the Internet. Recently, the project involved the prevention of SQL injection. However, because PYTHON and MYSQL are used, some of the ready-made methods provided in JAVA code cannot be used,

The lock mechanism is used to manage concurrent access to shared resources. In Oracle, the transaction should be committed at the appropriate time, because the transaction is very long or very large, generally there is no pressure on the system; row-

After the database server is set up, the first thing we need to do is not to consider which MySQL-initiated programs should be run on the server that supports the database, but when the database is damaged, how to safely restore to the last normal