Oracle

How to modify the database name (db_name) and instance name (instance_name or service_name) Nid is a tool that Oracle has provided from 9IR2 and can be used to change the database name without having to go through the cumbersome ways of rebuilding

I. Environmental description SOURCE database: IP Address: 192.168.137.100 Sid:catalog User name: Rman Password: Rman Target database: IP Address: 192.168.137.101 Sid:orcl User name: Rman Password: Rman Create a tnsname to the source database on

If there is a lock waiting, we might be more interested in knowing who locked the table and who's waiting.The following statement can query who locked the table: Copy Code code as follows: SELECT/*+ Rule * * s.username, Decode

Many data conversion processing operations encounter the need to convert 0.007007040000 to 0.7%, and we use Oracle's SQL function To_char to implement this transformation. This function is used to convert a date or Number data type to a string that

After a long period of learning to create Oracle Tablespace, so share with you, after reading this article you certainly have a lot of harvest, hope this article can teach you more things. 1, first query the free space Copy Code code as

Oracle in the database through the corresponding algorithm conversion for data storage, this paper briefly introduces the number of Oracle digital storage and conversion. This is to answer question number No. 2119 on the message board. we can use

Comparison of some simple commands for Oracle and MySQL 1) sql> Select To_char (sysdate, ' Yyyy-mm-dd ') from dual; Sql> Select To_char (sysdate, ' Hh24-mi-ss ') from dual; Mysql> Select Date_format (now (), '%y-%m-%d '); Mysql> Select Time_format

---Friendship tips, more content, you can choose from the top left of the + Directory selection section to facilitate reading. Experimental thinking:--Experimental related trace file: http://download.csdn.net/detail/q947817003/6646723 1. Database

Oracle's Own backups Until now, many developers have recognized the potential of RMAN and its usefulness as a database backup tool. You may recall that RMAN can back up data directly to disk and tape. When a tape solution is involved, RMAN

absrtact: by discussing and studying the characteristics and principles of Oracle Server and Client/server, this paper expounds some principles and methods of improving and adjusting the performance of Oracle Application system. Key Words: Oracle;

Four ways to increase the size of table space in Oracle 1: Add data files to the table space ALTER tablespace App_Data ADD datafile ' D:\ORACLE\PRODUCT\10.2.0\ORADATA\EDWTEST\APP03. DBF ' SIZE 50M; 2: New data files, and allow data files to grow

The effect of high water level and the performance of large concurrent inserts The rule summary of finding available blocks when inserting data blocks: High water level and low high water level: the state of the data blocks existing between the

Data files are deleted directly from the operating system when the database is open Because in a Linux system, a process that has previously opened the file still holds the appropriate file handle, and the file that you point to is still readable

The Dataguard configuration is as follows: Prod main library, sbdb for standby Log Group 1-3 Group is Redolog file,4-6 Group is standby log During the creation of the standby log library, the recovery from the data transfer to the standby is

A transaction is a logical unit of work that divides the activities of a database, and a transaction has a starting point and an end point. The transaction begins when one of the following events occurs: Connects to the database and executes the

If the required archive is lost during recover datafile, the recover cannot be made, and the bbed tool can skip the lost archive for recover datafile. The experimental process is as follows: Sys@orcl>select * from V$version; BANNER --------------

Concept Description The Oracle database is divided into the national character set (character set) and the database character set (db character set). Both are set when you create the database. The national character set is mainly used for nchar,

Before the linux6.6 release, we can configure ASM shared disks in two ways, one is to install the ASM driver package for ASM Disk group configuration, and the other is to use the ASM Disk group configuration by identifying the shared storage UUID

Root user, execute Xhost + and then switch to Oracle user run NETCADISPLAYOn the Linux/unix class operating system, display is used to set where the graphic will be displayed. Direct login to the GUI or login command line interface using STARTX to

(1) Select the most efficient table name order (only valid in the rule-based optimizer): The Oracle parser processes the table name from the FROM clause in a right-to-left order, and the last table written in the FROM clause (base table driving