Anuj Singh Oracle DBA
Friday, 1 April 2011
How to set SERVICE_NAME in oracle for tnsnames.ora
›
How to set SERVICE_NAME in oracle for tnsnames.ora file col NAME format a30 col VALUE format a30 SQL> select name, value from v$parameter...
2 comments:
Friday, 18 March 2011
Oracle dbv database verify Utility
›
15:57:07 SQL> set linesize 100 15:57:13 SQL> show parameter block NAME_COL_PLUS_SHOW_PARAM ...
1 comment:
Oracle Goldengate download 32bit etc
›
go to this site http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html if you don't find the product Oracle Golde...
Thursday, 17 March 2011
Redo and Number of Checkpoints per hour
›
set feed off; set pagesize 10000; set wrap off; set linesize 200; set heading on; set tab on; set scan on; set verify off; -- spool show_log...
2 comments:
Monday, 14 March 2011
OEM troubleshooting commands
›
https://apt-lnx-tst-01.site:1158/em/console/aboutApplication ...
Friday, 11 March 2011
Unix AT command
›
unix at command unix at to set Unix AT job bash-3.00$ at -t 201103111805 at> cd /apps/documentum/dba/log/0000717c/sysadmin/dm_clean at...
Friday, 4 March 2011
How to review Oracle patch log file ...
›
To put line number on this file ... awk '{print NR $0}' patch.10.2.0.4.log >patch10_number.log grep -i "error" patch10_...
‹
›
Home
View web version