ref: http://blog.tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/ When you access Oracle AWR (and other licensed features/tables/views) then these do show up in DBA_FEATURE_USAGE_STATISTICS. Exporting the contents is the same as accessing these with your SQL. All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT,…
Oracle Learning Library ======================= http://apex.oracle.com/pls/apex/f?p=9830:41:0::NO Getting Started with Oracle SQL Developer ========================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/sqldev_mngdb/sqldev_mngdb_otn.htm Using Source Code Control in Oracle SQL Developer ================================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/srccodexmlext/srccode_otn.ht
grant update (colum1, col2) on owner.table_name to other_user/role;
There are 2 ways. 1) opatch lsinventory 2) select * from sys.registry$history;
#!/bin/ksh typeset -L30 fieldA typeset -R15 fieldB fieldA=”Paresh” fieldB=”Vatti” echo “${fieldA}${fieldB}”
oracle@dbmonitor*-/export/home/oracle/paresh ==>echo `sum 1.sh` 4206 1 1.sh oracle@dbmonitor*-/export/home/oracle/paresh ==>echo `sum 1.sh` | awk ‘{print $1}’ 4206 oracle@dbmonitor*-/export/home/oracle/paresh ==>echo `sum 1.sh` | awk ‘{print $2}’ 1 oracle@dbmonitor*-/export/home/oracle/paresh ==>
Description =========== When monitoring the size of the available free space in the TEMPORARY tablespace it does not increased once sorts are finished even with no client connections to the database. They may also be a large number of EXTENTS of type TEMPORARY in the temporary tablespace. Users may also experience ORA-1652 when running transactions….
Read More “Temporary Tablespsace Temp tablespace behaviour” »
Here is another good example: You can initialize the LOBs by using the following SQL INSERT statement: INSERT INTO lob_table VALUES (1001, EMPTY_BLOB(), NULL, EMPTY_CLOB(), NULL); External LOBs: INSERT INTO lob_table VALUES (21, NULL, NULL, NULL, BFILENAME(‘IMG’, ‘image1.gif’)); INSERT INTO lob_table VALUES (22, NULL, NULL, NULL, BFILENAME(‘IMG’, ‘image2.gif’)); UPDATE lob_table SET f_lob = BFILENAME(‘IMG’, ‘image3.gif’)…
Oracle GoldenGate Tutorial 9 – Monitoring GoldenGate
http://www.oracle.com/technology/pub/articles/havawala-goldengate.html
