Anuj Singh Oracle DBA
Friday, 8 October 2010
ORA-16038: log 1 sequence# cannot be archived
›
SQL> startup; ...
Tuesday, 5 October 2010
Quotes in Strings ----- Oracle Q-quote
›
select q'[dfdsfhgdaskghfkdskhdasfhfkjhasfsaf]' from dual; Q'[DFDSFHGDASKGHFKDSKHDASFHFKJHASF ---------------------------------- ...
ASM diagnostics Report
›
ASM diagnostics Report # From Metalink Note 470211.1 SPOOL ASM_FIRST.HTML SET MARKUP HTML ON SET ECHO ON SET PAGESIZE 200 SELECT * FROM V$AS...
Monday, 4 October 2010
User has no SELECT privilege on V$SESSION v_$sql_plan v_$sql
›
if you are getting this error from scott SQL> select * from table(dbms_xplan.display_cursor(null, null, 'OUTLINE')); PLAN_TABLE_O...
1 comment:
Friday, 24 September 2010
Oracle Table fragmentation
›
declare space_used number ; space_allocated number ; chain_pcent number; begin for i in (select table_name, owner from dba...
Wednesday, 15 September 2010
oracle trace file gzip
›
# Gzips Oracle Trace Files that are older than 5 days /usr/bin/find /opt/oracle/admin/cccdb/udump /opt/oracle/admin/cccdb/bdump -name '*...
Tuesday, 14 September 2010
Put a line No in taxt file
›
awk '{print NR $0}' anuj.txt >anujline.txt
‹
›
Home
View web version