Database Administrator

Add auto-incrementing column in Oracle This is because the database of the other party is Oracle during project creation, and the identity () cannot be the same as that of MSSQL during auto-increment. Create sequence UserID_sequence -- create a

Oracle 10 Gb database creation and remote access configuration Recently, Oracle was used in the project, with oracle10gb. because many people in the group use the database, and the oracle database occupies a lot of memory, it is placed on a separate

Oracle learning-in-depth analysis of Buffer Cache Oracle learning-in-depth analysis of Buffer Cache Server process and database buffer cache: When the server needs a block, it needs to read the block in series steps: 1. First, the server uses the

ORA-01097 shutdown Error SQL> insert into emp2 select * from emp2; 14 rows created. SQL> shutdown immediate ORA-01097: cannot shutdown while in a transaction-commit or rollback first The database cannot be stopped because the DML operation is

Expdp impdp Database Import and Export commands 1. Create a logical directory. This command does not create a real directory in the operating system. It is best to create a directory as an administrator such as system.Create directory dpdata1 as 'd:

Oracle functions-advanced Below are some of the Oracle functions-advanced: 1. CATSTRExample: select catstr (COLUMN_NAME) NAME_LIST FROM DBA_TAB_COLUMNS where trim (TABLE_NAME) = 't_rz_dkdata '-- the query result is in a column.2. INSTR () string

Solve OEM garbled Characters During Windows Access Problem description It is found that the oem button is always garbled when Windows is used to access Oracle installed in Linux. The solution is as follows: OEM introduction and button

Statement used to query dead transactions in Oracle Statement used to query dead transactions in Oracle SQL> SELECT KTUXEUSN, KTUXESLT, KTUXESQN,/* Transaction ID */2 KTUXESTA Status, KTUXECFL Flags, KTUXESIZ3 FROM x $ ktuxe4 WHERE ktuxesta! =

Analysis and Summary of several names that are easily obfuscated in Oracle We know that various names in Oracle often appear in our configuration files, which are roughly as follows: DB_NAME, INSTANCE_NAME, SERVICE_NAME in init. ora When configuring

Draw a sequence chart-use Gnuplot A time sequence chart is a common data plot. The most typical time sequence data is weather data. The weather temperature and humidity change with time, this article provides an example of using gnuplot to plot the

How to create and delete tablespaces in Oracle cainiao 1. When creating a temporary tablespace and creating a tablespace, dbf Files are generally stored in the directory where the datafile file is stored (typically under the folder named by instance

Streams AQ: qmn coordinator waiting for slave to start, streamsqmn This wait event is reported in the Top 5 Timed events of Node2 with a set of 10g RAC (10.2.0.5) today. Top 5 Timed Events Event Waits Time (s) Avg Wait (MS) %

Generate DEM and acgisdem using big data in AcGIS When DEM is generated in ArcGIS, the data sources used are usually some height points and contour lines. These height points and contour lines are dense and may contain tens of millions or even

Subquery (Chapter Summary), subquery Chapter Summary1. Self-query refers to multiple small queries embedded in a complete query. According to different requirements, self-query can appear in any position of the query statement, but in FROM, WHERE

Command to shut down and restart the hpux operating system, and restart the hpux Operating SystemShutdown-hy 0Restart: shutdown-ry 0What is the command for shutting down a LINUX operating system? Shutdown, halt, reboot, and init can all be safely

[Oracle] User Creation and permission management, oracle permission management # Creating a user requires the administrator privilege SQL> create user lzz identified by lzz123; // a common user is created, but not unlocked # change the password for

The script used to check the row lock wait problem (both standalone and rac are common) and the script rac Source: How to use historic ASH data to identify lock conflicts (Doc ID 1593227.1) For the current lock, the script is (applicable to

When case when encounters an empty string to 0, case empty stringNote: If the field is of the varchar type, quotation marks are required for the condition after when. SELECT (CASE 'marate_status' WHEN 0 then' married 'when 1 then' unmarried 'else'

Modify the MySQL database port number. Modify the configuration file when the database service starts. First, shut down the Database Service and modify the configuration file: When you modify the configuration file, there are several areas that

Common oracle functions (2): oracle Functions 1. TRIM ([{LEADING | TRAILING | BOTH} [trim_character] | trim_character} FROM] trim_source) FunctionParameter: If leading is specified, the oracle database removes any starting characters equal to