noerror.blogspot.com
ORA-06950: This blog is on permanent hold
http://noerror.blogspot.com/2008/01/this-blog-is-on-permanent-hold.html
Thursday, January 24, 2008. This blog is on permanent hold. Instead of being rude and not concluding something, I'm closing this blog. It'll remain as is for as long as Blogger exists, I decide to remove it permanently, or the Earth dies. In other words, it's sticking around for information's sake. Enjoy the historical blogs. Subscribe to: Post Comments (Atom). This blog is on permanent hold. Really Cool Oracle Links. Oracle 9i Docs Index.
noerror.blogspot.com
ORA-06950: 02/01/2005 - 03/01/2005
http://noerror.blogspot.com/2005_02_01_archive.html
Monday, February 14, 2005. Automated alert log archive. Here's a set of scripts (package, PL/SQL and Korn) that when set in place and activated with a Unix cron job, will archive the alert log in a gzipped file. (Note: formatting is messed up in Blogger. Notice that missing pipe characters are missing.). First, put this in place as a package:. CREATE OR REPLACE PACKAGE alert log AS. PROCEDURE bdump dir setup;. PROCEDURE build possible alert log names;. PROCEDURE build alertlog name;. END alert log;.
noerror.blogspot.com
ORA-06950: 01/01/2005 - 02/01/2005
http://noerror.blogspot.com/2005_01_01_archive.html
Wednesday, January 12, 2005. Exp/imp Korn Shell scripts. Today, I am releasing two scripts that will allow the people here to export a schema and re-import it into another database. Both are Korn Shell scripts so obviously they are for Unix or variants. Usage: export.sh -p [dba user password] -d [tns entry of db 2 exp] -f [export file name.dmp] -s [schema nameschema name,shema name. These parameters need to be in the order as shown. The -s option can either be a space or comma (no spaces) list. Now, chec...
noerror.blogspot.com
ORA-06950: 06/01/2005 - 07/01/2005
http://noerror.blogspot.com/2005_06_01_archive.html
Thursday, June 02, 2005. CreateROUserLike.sql - Create read only user like. With this PL/SQL script. Links to this post. Subscribe to: Posts (Atom). CreateROUserLike.sql - Create read only user like. Really Cool Oracle Links. Oracle 9i Docs Index.
ora2oracle.blogspot.com
Ora? err... Ora ERR... Oracle!: November 2005
http://ora2oracle.blogspot.com/2005_11_01_archive.html
Err Ora ERR. Oracle! Searching for that elusive solution to the often heard ORA-XXXXX error, and finding interesting tidbits along the way! Wednesday, November 09, 2005. The Advantages of Patching Part II. This is a second part to "The Advantages of Patching". See the previous entry. Ok, now that I've gotten the patching issue over with, what's the next step? I'm going to do some testing against the application, of course. STEPS TO A] SOLUTION (1):. Turning on the feature to get the tracefiles*. Finally ...
noerror.blogspot.com
ORA-06950: UNDO stats watching...
http://noerror.blogspot.com/2005/07/undo-stats-watching.html
Wednesday, July 27, 2005. After we had some UNDO woes here at work, I had to go through the ugly process of figuring out how much UNDO space we could use and how to set our UNDO RETENTION parameter. Oh, is this a confusing and frustrating process. Here's some statistics of our current systems without the gory detail:. 17 GB of UNDO tablespace and no room to grow. 18000 for the UNDO RETENTION parameter. A 3K second MAX(V$UNDOSTAT.MAXQUERYLEN). Data from 8 days ago (rolling) to current in V$UNDOSTAT. WHERE...
noerror.blogspot.com
ORA-06950: Archive_Schema
http://noerror.blogspot.com/2005/08/archiveschema.html
Thursday, August 11, 2005. CREATE OR REPLACE PROCEDURE Archive Schema( fileDirectory IN VARCHAR2, schemaList IN VARCHAR2, delimiter IN VARCHAR2 DEFAULT ',' ) AUTHID CURRENT USER IS. MOutputFile UTL FILE.FILE TYPE;. MTypeSchemaArchive typeSchemaArchive := typeSchemaArchive();. DBMS SQL.PARSE( mDDLCursorID, 'SELECT instance number, instance name, host name, version, startup time FROM v$instance', DBMS SQL.NATIVE );. DBMS SQL.DEFINE COLUMN( mDDLCursorID, 1, mDBInstanceNumber );. PROCEDURE ParseSchemaList( s...
noerror.blogspot.com
ORA-06950: 08/01/2005 - 09/01/2005
http://noerror.blogspot.com/2005_08_01_archive.html
Thursday, August 11, 2005. CREATE OR REPLACE PROCEDURE Archive Schema( fileDirectory IN VARCHAR2, schemaList IN VARCHAR2, delimiter IN VARCHAR2 DEFAULT ',' ) AUTHID CURRENT USER IS. MOutputFile UTL FILE.FILE TYPE;. MTypeSchemaArchive typeSchemaArchive := typeSchemaArchive();. DBMS SQL.PARSE( mDDLCursorID, 'SELECT instance number, instance name, host name, version, startup time FROM v$instance', DBMS SQL.NATIVE );. DBMS SQL.DEFINE COLUMN( mDDLCursorID, 1, mDBInstanceNumber );. PROCEDURE ParseSchemaList( s...
noerror.blogspot.com
ORA-06950: 07/01/2005 - 08/01/2005
http://noerror.blogspot.com/2005_07_01_archive.html
Wednesday, July 27, 2005. After we had some UNDO woes here at work, I had to go through the ugly process of figuring out how much UNDO space we could use and how to set our UNDO RETENTION parameter. Oh, is this a confusing and frustrating process. Here's some statistics of our current systems without the gory detail:. 17 GB of UNDO tablespace and no room to grow. 18000 for the UNDO RETENTION parameter. A 3K second MAX(V$UNDOSTAT.MAXQUERYLEN). Data from 8 days ago (rolling) to current in V$UNDOSTAT. WHERE...