Database Administrator

The customer's database uses the cursor_sharing = similar parameter. After testing, it is found that this parameter greatly affects the performance of expdp.The essential reason is that the SQL Execution Plan has changed.Under normal circumstances,

Both views and synonyms are the object names in the database. They do not correspond to actual data storage and all depend on the existence of other objects.View: A view can be viewed as a virtual table or storage query. Unless it is an index view,

Friends who use Oracle 11G may have struggled with this problem. The data exported by the exp command may be inexplicably missing some tables, during the analysis, we will find that these tables are empty tables with no records inserted. The cause

In order to learn, the verify_function function of the database is enabled, and the password expiration time of the default profile is automatically set to 60 days, the password is reused for 18000 days, And the Password meets the complexity

Recently, to delete a record in the software system, you have to associate the record with multiple tables and there are still constraints between them. Therefore, when creating a table, add constraints as follows: SQL foreign key constraints can

Among Java and Oracle, the most common method is to call the Oracle stored procedure. The following briefly describes how Java calls the Oracle stored procedure. I. Java calls the Oracle stored procedure [without output parameters] The process name

An error is reported in the background of the application server today: Java. SQL. SQLException: ORA-01114: IO error when writing blocks to file 201 (block #1015305)ORA-27069: skgfdisp: Try to execute I/O out of file rangeOSD-04026: The passed

In Oracle, the use of insert statements: 1. insert into Table 1 (column name 1, column name 2 ,......) Values (value 1, value 2 ,......) 2. insert into Table 1 (column name 1, column name 2 ,......) Select column name 1, column name 2 ,......

I browsed the official Oracle webpage and unofficial ppt pages and briefly understood the high availability solution provided by Oracle. There are three main types: 1. RAC RAC, Real Application Clusters Multiple Oracle servers form a shared

Install the Oracle database in Linux: 1. Convention: linux System for Linux.5.4-server-x86_64, database for linux. x64_11gR1_database_1013When installing linux, select to install all packages.2. Use the root user to modify the kernel parameters and

To enable OEM or OMS properly, there are two key points:1. Whether the Oracle system service is enabled;2. Are the usernames and passwords used for Logon correct. First, let's talk about Oracle's system services. In the case of full installation,

1, go to Oracle official website download basic-10.2.0.5.0-linux-x64.zip, sqlplus-10.2.0.5.0-linux-x64.zip 2. Extract the two zip packages downloaded in step 1 to the same directory, for example,/fyfeng/instantclient_10_2. 3. environment variable

Yesterday just installed a database at the start of the time, the error ORA-01102, and the installation did not see where the error information, all the way is relatively smooth, and this is the first time I encountered this problem, at that time, I

# Set the execution encoding format to prevent garbled Characters During Chinese Export Export NLS_LANG = "AMERICAN_AMERICA.UTF8" # Load the Oracle client program to the environment variable. Note: This line must be added if the script is placed in

Today, PMO issued a task order. After the database was transformed from the sybase system to the Oracle system, 312 entity tables were created for a total of 20 objects, it must be a monkey year, a month, and does not meet the schedule of the

The Innodb database only marks deleted data and does not actually release the occupied disk space, which leads to the increasing number of InnoDB database files. If you want to completely release the deleted data, you need to export the database,

1. Description of rownum For the rownum problem of Oracle, many documents say that ">,> =, =, between..." in SQL statements are not supported... and "operator. Only the following operators can be used: Not to say ">,> =, =, .. "and" will prompt SQL

When doing GIS engineering, we often use the most famous software in the GIS field of ARCGIS, and the most common file type of ARCGIS is shpfiles, which has three formats of file composition: shp, shx, and dbf. At the same time, the GIS project

Run the following command Sqlplus/as sysdba Create tablespace test datafile '/data/test01.dbf' size 10240 M; Quit; EOF Run the ps-ef | grep sqlplus command to obtain the process id of the Command executed above: 12345 (1) v $ process If the

This series of articles details the process of adding 3rd rac nodes on the basis of two existing rac nodes, without any impact on the use of rac during this period, the operating system of the rac node is CentOS4.8 64-bit, and the database version