sid
create index and rebuild index on the original table will be added when the 4 locks on obj $ plus 3 locks to prevent DML operations on the original table create index online and rebuild index online using a temporary table to deal with new or to re-c ...
11g r2 reconstruction em C: \> emca-deconfig dbcontrol db EMCA began 2010-7-16 9:29:21 EM Configuration Assistant, 11.2.0.0.2 official version Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: or ...
sqlplus "/ as sysdba" SQL * Plus: Release 10.2.0.4.0 - Production on Fri Jul 16 19:18:24 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production ...
System environment: redhat-as4.7 oracle10.2.0.4-RAC Why changes? Recent applications have three temporary database problem can not connect, check all nodes alter the log each time a problem was found when a node is recorded alarm log: Tue Jul 6 14:44 ...
First, the database name What is the database name Database name is a database of identity, as the identity cards of the same number. Parameter DB_NAME he said that if more than one machine to upload the entire database, then every database has a dat ...
oracle SID written in / var / opt / oracle / oratab The oratab file in the following line of N into Y can be (if the number of library complete with a SID would not know which library to change woven): orcl: / oracle/product/10.2.0/db_1: N
Rman backup in time with the proposed open automatic backup control file, you can lose the case library catalog directly from the automatic backup set to restore the database CONFIGURE CONTROLFILE AUTOBACKUP ON; Recovery as long as RMAN> restore c ...
oracle execute immediate use in (select / insert / update / delete) Transfer of the Internet, execute immediate http://hi.baidu.com/llscompazz/blog/item/29dccd58851fced99c8204d4.html execute immediate syntax is as follows: execute immediate 'sql& ...
Correct modification and SYSMAN password DBSNMP DBSNMP password changes 1.Stop dbconsole 2.set new password for dbsnmp 3.test dbsnmp new password by connect 4.edit targets.xml Search for the line: <Property NAME="UserName" VALUE="6f ...
oracle create table space in the often encountered when the data file exceeds the limit of large numbers, how to solve this problem? This limit by two parameters one is maxdatafiles, one db_files. maxdatafiles in the control file specified, db_files ...
1. Tkprof of ORACLE is a trace file and generates a more humane clear output executable tool. C: \ oracle \ ora92 \ bin \ tkprof.exe 2. Tkprof full name Reference information http://www.itpub.net/showthread.php?s=cbfea4845ef5b2a3f4adb00de0de9317&threa
1. Tkprof of ORACLE is a trace file and generates a more humane clear output executable tool. C: \ oracle \ ora92 \ bin \ tkprof.exe 2. Tkprof full name Reference information http://www.itpub.net/showthread.php?s=cbfea4845ef5b2a3f4adb00de0de9317& ...
Errors: Node ID does not exist for the current application server ID Applies to: Oracle Applications Framework - Version: 11.5.9 Oracle Applications Technology Stack - Version: 11.5.9 This problem can occur on any platform. Symptoms After login into ...
Table 1: General Form shrink to open the line of migration functions. alter table table_name enable row movement; Maintain the HWM alter table table_name shrink space compact; Retraction table and HWM alter table table_name shrink space; Retraction t ...
It is easy to confuse the two concepts. Concept: OPEN_CURSOR, the definition of each Session the largest number to open the cursor. Defined in the init.ora file, you can select * from v $ parameter where name = 'open_cursors' inquiries. V $ O ...
tnsnames.ora is the client's configuration file; The server configuration file: listener.ora, Stored in the file the client and the server needed to connect the monitor address, and when the server starts listening process information. Descriptio ...
select sid, seq #, event, p1, p1raw, p2, p2raw, p3, p3raw, state from v $ session_wait where event like 'library%'; SQL> set linesize 999 SQL> / SID SEQ # EVENT P1 P1RAW P2 P2RAW P3 P3RAW STATE ---------- ---------- -------------------- ...
SELECT SE.SID, OPNAME, TRUNC (SOFAR / TOTALWORK * 100, 2) | | '%' AS PCT_WORK, ELAPSED_SECONDS ELAPSED, ROUND (ELAPSED_SECONDS * (TOTALWORK - SOFAR) / SOFAR) REMAIN_TIME, SQL_TEXT FROM V $ SESSION_LONGOPS SL, V $ SQLAREA SA, V $ SESSION SE WH ...
Oracle Query current connection users select sid, serial #, username, program, machine, status from v $ session where username = 'DAIMIN' AND STATUS = 'ACTIVE';
oracle session is often locked. But sometimes alter system kill session 'sid, serial #'; does not completely kill the session. Linux can only kill the corresponding process Caixing. Previously been through the v $ session where the logon_time, and
When writing backup script rman allocate channel to indicate the specific path and format Otherwise, If you have fast recovery area flash recovery area, then back up the assembly is automatically assigned to similar ... \ Flash_recovery_area \ SID \ ...
When writing backup script rman allocate channel to indicate the specific path and format Otherwise, If you have fast recovery area flash recovery area, then back up the assembly is automatically assigned to similar ... \ Flash_recovery_area \ SID \ ...
Killed in the lock table oracle rn rn 1. See what rn select s.username, s.osuser, s.sid, s.serial #, p.spid from v $ session s, v $ process p where s.paddr = p.addr and s.username = 'ERPTION' and s.username is not null rn rn 2. View the runni ...
Killed in the lock table oracle rn rn 1. See what rn select s.username, s.osuser, s.sid, s.serial #, p.spid from v $ session s, v $ process p where s.paddr = p.addr and s.username = 'ERPTION' and s.username is not null rn rn 2. View the runni ...
Killed in the lock table oracle rn rn 1. See what rn select s.username, s.osuser, s.sid, s.serial #, p.spid from v $ session s, v $ process p where s.paddr = p.addr and s.username = 'ERPTION' and s.username is not null rn rn 2. View the runni ...
Killed in the lock table oracle rn rn 1. See what rn select s.username, s.osuser, s.sid, s.serial #, p.spid from v $ session s, v $ process p where s.paddr = p.addr and s.username = 'ERPTION' and s.username is not null rn rn 2. View the runni ...
When we log on the database, suggesting that the current user logged in, but we do not know who is logged, and we have to board the Record, we can move out of the user in order to facilitate our login Steps: 1. Su - oralce input passpd 2. Sqlplus / a ...
When you need to maintain the structure of the database or to import and export database when you can to limit the mode to start the database, so that only restricted session privileges of the user (usually the system administrator) can only log data ...
When manually delete the archive logs after, Rman backup will detect deletion log, and thus can not further continue. So now need to manually crosscheck the implementation process can return to normal after the Rman backup. 1.Crosscheck log $ Rman ta ...
SQL> startup; ORACLE instance started. Total System Global Area 1207959552 bytes Fixed Size 2083528 bytes Variable Size 369100088 bytes Database Buffers 822083584 bytes Redo Buffers 14692352 bytes Completion of the loading database. ORA-16004: bac ...
6, monitoring the activities of the current database session 6.1 Monitoring the implementation of statements session 6.1.1 dynamic performance view to find activities through the implementation of statements session select a.SID, a.USERNAME, a.machin ...
Have a partition table 800G, add a field to him: alter table ODS_HTTP_ACCESS_LOG add GPRS_GATEWAY varchar2 (50) default''; Added, and then open another session B: insert into statuser. ODS_HTTP_ACCESS_LOG select * from statuser. ODS_HTTP_ACCE ...
1. Query to get the current database, lock, and unlock: SELECT / * + rule * / s.username, decode (l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL, o.owner, o.object_name, o.object_type, s.sid, s.serial # ...
When we log on the database, suggesting that the current user logged in, but we do not know who is logged, and we have to board the Record, we can move out of the user in order to facilitate our login Steps: 1. Su - oralce input passpd 2. Sqlplus / a ...
Have a windows environment, filled with 10g database reports filed after the inspection log to the host about a dozen left a letter M into a archive file check to see if there are two instances instance of the situation, first cut the old archive to ...
First, what is registered? Registration is to register the database as a service to the listener. Clients do not need to know the database name and instance name, just need to know the database name of the external services may apply to connect to th ...
RMAN provides a separate restore individual BLOCK The Gongneng, this function as a normal recovery method added, for resumption of bad blocks in the database appears to recover quickly in the. RMAN's BLOCKRECOVER is using a full backup as the bas ...
Through v $ sesstat in statistics, statistical rollback the current session, and if out of session, v $ view is no longer saved. rn Of which: statistic # = 4, said user commits statistic # = 5, said user rollbacks From v $ sysstat view to. rn rn SQL ...
View V $ SYSSTAT and V $ SESSTAT description ================================== v $ sysstat shows examples started, an instance of the incremental statistics. View statistics need to connect the name of the view v $ statname, 9i do not start, and the ...
How to determine whether the oracle instance is running rn ORACLE instance starts, you must define ORACLE_SID. TOM on oracle ORACLE_SID explained that under the SID of the hash to uniquely determine the address of an instance. When we open sqlplus / ...
rn Business systems logmnr do log extraction, need to archive logs, but found that some archive logs because the retention time is too short, has been cleared. In order to restore the archive logs needed to restore the backup in rman backup archive l ...
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn This description is based on the bare de ...
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn RMAN Backup and Recovery - RAC environme ...
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn RMAN Backup and Recovery - RAC environme ...
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn RMAN Backup and Recovery - RAC environment da
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn RMAN Backup and Recovery - RAC environme ...
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn RMAN Backup and Recovery - RAC environme ...
rn Special privileges and Oracle login authentication management rn Oracle at the beginning of school, when one thing has been asking me feel very strange why the data is not up in time there is to log on to install the Oracle operating system directly sq
rn RAC environment, backup, recovery and general database backup, recovery is some difference. rn RMAN Backup and Recovery - RAC environment database backup (1): http://yangtingkun.itpub.net/post/468/285260 rn RMAN Backup and Recovery - RAC environment da
Archivelog in Oracle 8i, 9.01,9.2 environment setting method of Li Shouliang 2003-06-16 First, steps of 2, the log parameters and the meaning of the three, filing orders and the meaning of four specific examples To realize these steps: 1, Manager 1) ...
