ITPub博客

SQL> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64biPL/SQL Release 10.2.0.2.0 - ProductionCORE 10.2.0.2.0 ProductionTNS for Solaris: Version 10.2.0.2.0 - ProductionNLSRTL Version 10.2.0.2.0 - ProductionSQL> ANALYZE TABLE "SAPKBW"."/BI0/F0TCT_C21" PARTITION ("/BI0/F0TCT_C210000000052") ESTIMATE STATISTICS SAMPLE 60 PERCENT FOR TABLE FOR ALL LOCAL INDEX

The following operations support the UPDATE INDEXES clause:ADD PARTITION | SUBPARTITIONCOALESCE PARTITION | SUBPARTITIONDROP PARTITION | SUBPARTITIONEXCHANGE PARTITION | SUBPARTITIONMERGE PARTITION | SUBPARTITIONMOVE PARTITION | SUBPARTITIONSPLIT PARTITION | SUBPARTITIONTRUNCATE PARTITION | SUBPARTITIONSQL> alter table SAPKBW."/BIC/FZSD_C71" move partition "/BIC/FZSD_C710000000123" tablespace PSAPKBWFACT update indexes;Table altered.SQL> set linesize 200SQL> set page

X$ Table This is a summary list of X$ table definitions. The last revision was for Oracle 7.3.2, however, the list is still relevant to later Oracle releases (including Oracle 10g). The main purpose of this list is to show naming conventions. This is also handy when trying read Oracle trace files. For example, if you see a function name starting with k2t%, you know is if from the [K]ernel Layer, [2]-Phase Commit, [T]ransaction handling code. [@more@]Here is the list: [K]ernel Layer [2]-Phas

got an issue that my orcladmin account was not able to login. Here is the approach to reset it:donot get panic when you hit:oracle$ oidpassd unlock_su_acct=TRUE"unable to locate message file: ldap<language>.msb"set $ORACLE_HOME=/u01/home/oracle/product/10gASstzhao:pts/1:drno:rep > oidpasswd connect=tsys unlock_su_acct=trueOID DB user password:OID super user account unlocked successfully.it works then :)[@more@]Usage: oidpasswd [connect=<Net8 Connect Descriptor>] [change_

when change of fail-over host:change the entry accordingly$ pwd/u01/home/aw/site$ cat sosite# Copyright 1992-2003 AppWorx Corporation# All Rights ReservedSQLOPER_HOME=/u01/home/aw;export SQLOPER_HOMEAW_HOME=/u01/home/aw;export AW_HOMEAWWEB_HOME=/u01/home/aw;export AWWEB_HOMESO_OPERATOR=BWPRD-FO;export SO_OPERATOR. $AW_HOME/bin/sqloper.ini# End of system maintained section$ cat awenv.ini[default]AWCOMM_PORT=2136Master=SVRPAWMaster_Ip_Address=svrpawAgent=BWPRD-FOAgntMgr=NoOsType=UNIX[Install]remov

no time to read the manual but want to taste how stream works. here is what you can go through in 30min.[@more@]stream step-by-step1. prerequisite on both databases:stzhao:pts/6:sambar:hdvl > sqlplus "/ as sysdba"SQL*Plus: Release 10.2.0.3.0 - Production on Fri Sep 14 16:52:40 2007Copyright (c) 1982, 2006, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> sho

archivelog format：(9i,10g)%s log sequence number%S log sequence number, zero filled%t thread number%T thread number, zero filled%a activation ID%d database ID[@more@]%c : copy number of backup piece.when duplexing of backup piece is in use备份片的拷贝数%d : name of database数据库名称%D date of month 位于该月中的第几天 (DD)%F: DBID+yyyymmdd+sequence number hex%F 一个基于DBID唯一的名称,这个格式的形式为c-IIIIIIIIII-YYYYMMDD-QQ,其中IIIIIIIIII为该数据库的DBID，YYYYMMDD为日期，QQ是一个1-256的序列%M

The areas you'll want to review and monitor on your database server using Unix utilities are:CPU performance. How busy are the CPUs? How big is the backlog of processes waiting to run on your CPUs? Memory usage. How much memory is being used? Are you swapping out to disk because too much is being used? Do you have unused memory that would allow you to increase the size of your database buffers? Disk output. What is the disk I/O throughput? Is a particular disk a bottleneck? Network usage. What's

Everybody handling a Unix operating system would very well know what chmod 777 means. That the owner, group and the user of the file is given all permissions (Read, Write and Execute on a particular file). This could otherwise be written as “chmod ugo+rwx “. Meaning that you are giving User, Group and Owner of the file, the rights to Read, Write and Execute the file.Here comes the rws scenario. Best example that is available for this rws is /usr/bin/passwd command (just issue a “ls -l /usr/bi