Pages
Categories
Apex Audit Book review Bugs Character sets Database links Dataguard Email General musings Grid control Installs Linux Materialized views Old Oracle forms Performance tuning PL/SQL RAC Rman Scripts Security Sharepoint Space Spfile SQL*Net SQL Developer SQL server Stats Uncategorized Windows WordpressCategories
- Apex (1)
- Audit (1)
- Book review (2)
- Bugs (6)
- Character sets (6)
- Database links (2)
- Dataguard (1)
- Email (3)
- General musings (6)
- Grid control (2)
- Installs (10)
- Linux (16)
- Materialized views (2)
- Old (1)
- Oracle forms (4)
- Performance tuning (17)
- PL/SQL (4)
- RAC (6)
- Rman (10)
- Scripts (30)
- Security (3)
- Sharepoint (1)
- Space (6)
- Spfile (2)
- SQL Developer (1)
- SQL server (5)
- SQL*Net (4)
- Stats (4)
- Uncategorized (7)
- Windows (7)
- Wordpress (3)
Archives
- April 2012
- March 2012
- February 2012
- December 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- April 2009
- March 2009
- November 2008
- January 2008
- November 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
Recent Comments
- Shaikh Mujahid on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- Ranjith on ORA-38029 Object Statistics Are Locked – due to import with rows=n
- Shaikh Mujahid on Oracle Developer Suite 10g 9.0.4.0.1 windows software download media
- Tom on Fix for TOAD error ORA-02404: specified plan table not found
- fayaz on Oracle Forms popup dialog alert box
Monthly Archives: February 2007
10046 tracing in another session
To switch 10046 tracing on in another session (first setting on timed statistics and making max_dump_file_size very large): set pages 9999 verify off col serial new_value serial noprint select serial# serial from v$session where sid = &1 ; exec sys.dbms_system.set_bool_param_in_session(&1,&serial,’timed_statistics’,true) … Continue reading
Posted in Performance tuning, Scripts
Leave a comment
Clone a database
The below SQL generates a SQL script that can be used to clone a database, putting tablespaces into hot backup mode one at a time. Run it on the source database, and edit the output to specify new target file … Continue reading
Posted in Rman, Scripts
Leave a comment
Slow SQL report
Lists slow SQL in library cache for tuning investigations: set pages 9999 spool c.lst select elapsed_time/1000000 secs, executions, elapsed_time/1000000/greatest(executions,1) secs_per_exec, sql_text from v$sql where executions > 50 and elapsed_time/1000000/greatest(executions,1) > 1 order by 3 desc / spool off ed c.lst … Continue reading
Posted in Performance tuning, Scripts
Leave a comment
Silent installer on unix still needs X windows until 10g
It’s not always easy to get X windows properly, or to get hold of X windows emulator software for Windows PCs. So it was a bit of a step backwards when the installer moved away from the ugly but effective … Continue reading
Posted in Installs
Leave a comment
Using 10g datapump and scheduler to copy schemas
Update 13-Feb-07: Setting the datapump table_exists_action to replace does not overwrite views, sequences, plsql objects. They have to be dropped separately before datapump is called, see gotchas and code below. Update 02-Mar-07: dba_ views rather than all_ views have to … Continue reading
Posted in RAC, Scripts
7 Comments