Oracle 10g Histogram ==================== Oracle uses two types of histograms for column statistics (1) height-balanced histograms (2) frequency histograms The type of histogram is stored in the HISTOGRAM column of the *TAB_COL_STATISTICS views (USER and DBA). This column can have values of HEIGHT BALANCED, FREQUENCY, or NONE. (1) Height-Balanced Histograms In a height-balanced histogram, the…
exp userid=cs file=zip_cutoff_01FEB07.dmp log=zip_cutoff_01FEB07.log compress=N grants=N tables=zip_cutoff statistics=none query=”where delivery_date >=trunc(sysdate)” imp userid=cs file=zip_cutoff_01FEB07.dmp log=zip_cutoff_01FEB07_imp.log ignore=Y grants=N fromuser=cs touser=cs statistics=none
http://www.df.lth.se/~egh/doc/EM/Webhelp/dba/dba.htm
Log File Sync Event =================== Description When a user session commits (or rolls back), the sessions redo information needs to be flushed to the redo logfile. The user session will post the LGWR to write the log buffer to the redo log file. When the LGWR has finished that it will post the user session….
set lines 150 pages 2000 accept v_sqlid prompt ‘Enter SQL_ID : ‘ select * from table(dbms_xplan.display_cursor(‘&v_sqlid’, 0));
set lines 150 pages 2000 accept v_sqlid prompt ‘Enter SQL_ID : ‘ select * from table(dbms_xplan.display_cursor(‘&v_sqlid’, 0));
set lines 150 pages 2000 accept v_sqlid prompt ‘Enter SQL_ID : ‘ select * from table(dbms_xplan.display_cursor(‘&v_sqlid’, 0));
Good Docs. (1) http://www.oracle-training.cc/oracle_tips_hidden_parameters.htm (2) FOR EAAPPPROD22 (UOCQA) ====================== Also I did some research on ‘cache buffer chains’ CBC events and found that wait on UOCQA instance ( on eaappprod22 ) was occurring due to wait on specific chain, not because of wait on specific Block or ROW. As per current configuration, # of linked-list…
dbaltxprod50->WEBP18F@(/home/oracle)/oracle/app/oracle/product/10.2/OPatch/opatch lsinventory Invoking OPatch 10.2.0.2.0 Oracle interim Patch Installer version 10.2.0.2.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /oracle/app/oracle/product/10.2 Central Inventory : /var/opt/oracle/oraInventory from : /oracle/app/oracle/product/10.2/oraInst.loc OPatch version : 10.2.0.2.0 OUI version : 10.2.0.2.0 OUI location : /oracle/app/oracle/product/10.2/oui Log file location : /oracle/app/oracle/product/10.2/cfgtoollogs/opatch/opatch-2006_Aug_28_17-52-47-E DT_Mon.log Lsinventory Output file location : /oracle/app/oracle/product/10.2/cfgtoollogs/opatch/lsinv/lsinventory-2006_Aug_28 _17-52-47-EDT_Mon.txt…
18:02:01 PVM@AWRTEST:-> select * from pvm1; NO ——— 100 20 40 1 2 200 24 7 rows selected. Elapsed: 00:00:00.01 18:02:17 PVM@AWRTEST:-> select no from ( select no, row_number() over (order by no desc) r from pvm1) where r=2; NO ——— 100 1 row selected. Elapsed: 00:00:00.02 18:02:38 PVM@AWRTEST:-> select no from ( select no,…
