Anuj Singh Oracle DBA
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
Friday, 27 August 2010
ORA-12916: Cannot use default permanent tablespace with this release
›
COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 COLUMN description FORMAT A50 SET LINESIZE 200 SELECT * FROM database_pro...
Tuesday, 24 August 2010
Is My Linux 32 bit or 64 bit ?
›
Quick way to find out anuj-amd-02:/home/anujs/Downloads/Goldengate # uname -m x86_64 oracle@anuj:~> uname -m i686
Wednesday, 18 August 2010
How to grant select on v$session (or v$ ) views
›
v$session is synonyms of v_$session . SQL> col OWNER format a15 SQL> col OBJECT_NAME like OWNER SQL> col OBJECT_TYPE like OWNER SQL...
Oracle ORA_ROWSCN Pseudocolumn and AS OF Flashback Query
›
SQL> CREATE TABLE anuj (c1 NUMBER, c2 VARCHAR2(16), c3 DATE) ; SQL> INSERT INTO anuj VALUES (1,'A',SYSDATE); 1 row created. SQ...
‹
›
Home
View web version