oracle commands

In the OracleRAC environment, run asmcmd with the grid account to enter the asm command mode, such as: [grid @ oradb-node1 ~] $ AsmcmdASMCMDgt; ASMCMD In the Oracle RAC environment, use the grid account to run asmcmd to enter the asm command mode, such as: [grid @ oradb-node1 ~] $ Asmcmd ASMCMDgt; ASMCMD In the Oracle RAC environment, run Run asmcmd to enter the asm command mode, for example: [Grid @

Oracle uses the following command line in windows:Net startOracleserviceorcl // start the ORACLE service [oracleserviceorcl is the actual service name]Net stopOracleserviceorcl // stop the ORACLE serviceNet startOracleoradb10g_home1tnslistener // start the ORACLE listener serviceNet stopOracleoradb10g_home1tnslistener

SGA Abstract4 UGA Summary8 Current call (CGA) Abstract16 User call (CGA) Abstract32 Large call (LGA) Abstract1025 PGA content2050 SGA content4100 UGA content8200 Current call content16400 User call content32800 Large call content7). Sub HeapBefore Oracle 9.0.1Alter session set events 'immediate trace name heapdump_addr level n ';If n is the subheap address, the digest information of the subheap is dumped.If n is the subheap address + 1, the dumped co

The Oracle parameter query command show parameter is a small trick. You can use fuzzy query. For example, if you want to query parameters that contain db _, you can use: SQL> show parameter db _; NAME TYPE VALUE ----------------------------------------------------------------------------- Db_16k_cache_size big integer 0 Db_2k_cache_size big integer 0 Db_32k_cache_size big integer 0 Db_4k_cache_size big integer 0 Db_8k_cache_size big integer 0 Db_block

Chapter 4: Index 1. Creating function-based indexesSQL> Create index summit. item_quantity on Summit. Item (quantity-quantity_shipped ); 2. Create a B-Tree IndexSQL> Create [unique] index index_name on table_name (column,... ASC/DESC) tablespaceSQL> tablespace_name [pctfree integer] [initrans integer] [maxtrans integer]SQL> [logging | nologging] [nosort] storage (initial 200 K next 200 K pctincrease 0SQL> maxextents 50 ); 3. pctfree (INDEX) = (maximum number of rows-initial number of rows) * 100

1. Download gqlplus, download link http://jaist.dl.sourceforge.net/project/gqlplus/gqlplus/1.12/gqlplus-1.12.tar.gz. 2. Upload to linux, decompress and compile and install 2.1tar-zxvfgqlplus-1.12.tar.gz 2.2cdgqlplus-1.12 ./Configure Make 3. log on to the oracle database with gqlplus [Oracle @ Centos ~] $/SQL/gqlplus-1.12/gqlplus/nolog SQL * Plus: Release11.2.0.1.0ProductiononTueSep1713: 27: 242013

1. Unzip the shortcut key installation package: Root@www.bkjia.com ~ # Tar-zxvf rlwap-0.30.tar.gz Root@www.bkjia.com ~ # Cd rlwap-0.30 2. Perform the Configuration: Root@www.bkjia.com ~ #./Configure Root@www.bkjia.com ~ # Make Root@www.bkjia.com ~ # Make check Root@www.bkjia.com ~ # Make install 3. Add it to the Oracle user's environment variables: Oracle@www.bkjia.com ~ $ Vi. bash_profile -----> A

Introduction: Data Pump User Guide10g introduced the latest data pump technology, allowing DBAs or developers to quickly move database metadata (object definition) and data to another Oracle database.Role of Data Pump Export Import (expdp and impdp)1. implement logical backup and logical recovery.2. move objects between database users.3. move objects between databases4. Implement table space migration. Differences between data pump export and traditio

IO bottlenecks in Oracle databases may cause serious problems. Different from performance problems, slow IO may lead to slow write speed of control files, which may lead to the waiting for obtaining control files The I/O bottleneck in Oracle databases may cause serious problems. Unlike performance problems, slow I/O may lead to slow write speed of control files, which may lead to waiting for control files

In oracle, the delete command starts with delete, which is the same as other SQL statements. The following describes how to delete tables, views, sequences, functions, and data in oracle. After executing the following SQL statement, we can get the SQL statement to be executed, and then copy the SQL statement printed by these programs for execution. -- Delete tables delete a data table The Code is

replace; alter database $ dbname set online" Incremental recovery: osql-U $ user-P "$ password"-d master-S $ instance-Q "alter database $ dbname set offline with rollback immediate; restore database $ dbname from disk = '$ filename' with replace, NORECOVERY; restore database $ dbname from dist =' $ diff_filename 'with recovery; alter database $ dbname set online" III. oracle: Oracle uses rman for backup an

versions of a block in the buffer. 6). Heap Alter session set events 'immediate trace name heapdump level level '; 1 PGA Summary2 SGA Abstract4 UGA Summary8 Current call (CGA) Abstract16 User call (CGA) Abstract32 Large call (LGA) Abstract1025 PGA content2050 SGA content4100 UGA content8200 Current call content16400 User call content32800 Large call content 7). Sub Heap Before Oracle 9.0.1 Alter session set events 'immediate trace name heapdump_addr

An operational http://www.diybl.com/course/7_databases/oracle/oraclejs/20071211/91845.html that gives users the permission to import dataFirst, start SQL * pulsSecond, log in with system/managerThird, create user username identified by password (this step can be omitted if you have already created a user)Fourth, grant create user, drop user, alter user, create any view,Drop any view, EXP_FULL_DATABASE, IMP_FULL_DATABASE,DBA, CONNECT, RESOURCE, create

=[directory_object:]file_name [,....] Directory_object is used to specify the directory object name and file_name to specify the dump file name. Note that if you do not specify Directory_object, the export tool automatically uses directory objects specified by the directory option EXPDP Zftang/zftang@zftang directory=dmp dumpfile=test1.dmp Data Pump tool export steps:1. Create DirectoryCreate directory DIR_DP as ' D:/ORACLE/DIR_DP '; 2. Authoriza

1, primary key and foreign keyPrimary key: A record in a relational database has several attributes, if one of the attribute groups (note is a group, can be one, can be multiple) can uniquely identify a record, then the attribute group is the primary keyFOREIGN key: A column in a relational database table or a combination of several columns whose value matches a column or columns in another table. and is the primary key of another table (that is, one or more columns of this table are the primary

Package com.test; Import Java.io.BufferedInputStream; Import Java.io.BufferedReader; Import Java.io.FileInputStream; Import java.io.IOException; Import Java.io.InputStream; Import Java.io.InputStreamReader; Import Java.util.Date; /** * Java program Import Export database to do program timing (combined with Quartz,log) automatic backup to prevent data loss * * @author leiwei 2011-12-1 * * * Public CLA SS BackupDB {Runtime Runtime = Runtime.getruntime (); Process process = NULL;

1. User Logon Conn system/Manager Conn Scott/Tiger Ii. Change the password Enter passw and press enter to modify the settings as prompted. 3. Switch the Login User Conn username/password 4. display the currently logged-on user Show user V. Start and @ commands For example, if the root directory of disk D contains a Lida. SQL file, the file content is select * from EMP; Run start D: \ Lida. SQL or @ D: \ Lida. SQL to obtain the sa

The code is as follows Copy Code Set Trimspool onSet Linesize 120Set PageSize 2000Set NewPage 1Set Heading offSet term offSpool path + filenameSelect Col1| | ', ' | | col2| | ', ' | | col3| | ', ' | | col4| | '. ' FROM TableName;Spool off With some basic commands 1. Get database name and date createdSELECT name, created, Log_mode, open_mode from V$database; 2, the Oracle