Anuj Singh Oracle DBA
Tuesday, 19 October 2010
Oracle Copy or move old archive log file
›
ctime last time the inode changed - ie., chmod, chown, etc. atime last time the file was read (Example: cat, grep, sort, vim, file_get_co...
Friday, 15 October 2010
dbms_metadata package to extract the schema ddl
›
Oracle schema / user ddl via dbms_metadata SET LONG 10000 TRIMSPOOL ON LINES 180 HEADING OFF FEEDBACK OFF PAGES 0 VERIFY OFF EXEC...
dbms_metadata package to extract the schema ddl
›
Oracle dbms_metadata package to extract the schema ddl .... SET LONG 10000 TRIMSPOOL ON LINES 180 HEADING OFF FEEDBACK OFF PAGES 0...
What is a Clustering Factor and how to improve?
›
Clustering Factor is a value that tells Oracle how the rows in a table are randomly distributed with respect to index key values. good Clust...
What is a Clustering Factor and how to improve ?
›
Clustering Factor is a value that tells Oracle how the rows in a table are randomly distributed with respect to index key values. good Clus...
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 ---------------------------------- ...
‹
›
Home
View web version