Month: August 2006

How often I did meet ORA-01555: snapshot too old: rollback segment too small ? I cannot count. On one of the database I am currently administrating it is about once a day. Back to Oracle 7 and 8, the solution was usually to size the rollback segments properly. Using big rollback segments for big jobs, […]

Linux x86

Solaris Sparc 64bits Solaris Sparc 32bits

Patchset 9.2.0.8 is out for a few plateform. I am quite surprised it did not come out on Solaris 32bits first, as I expected, but rather on the following Microsoft Windows 32bits Microsoft Windows 64bits Linux Itanium Linux x86_64 HP UX PA-RISC IBM AIX5L IBM z/OS (OS 390) This is the terminal release of 9iR2

the sessions I registered with for oracle open world 2006 are the following : Monday 10:45 : Bryn LLewellyn, PLSQL Manager, will talk about PLSQL future in the next release (11g) : session S281172 Monday 12:30 : Andrew Clarke, Oracle ACE, will talk about unit testing in PL/SQL : session 282112 Monday 15:15 : Thomas […]

Do not switch to blogger beta. It failed, and everything is corrupted on my page, I cannot fix it yet (this message will probably only be readable as feed). Take care!

I created a new group in OpenWorld Connect. In San Francisco I would like to meat other people writing and reading blogs. If you have not actived openworld connect yet, you can update your profile on http://www.cplan.com/oracleopenworld2006/leverageoptin, than join the Oracle Blogger group at Oracle Blogger

I just had to guide one of our DBA this morning. How to get free of segments in SYSTEM tablespace : tables SQL> select owner, table_name from dba_tables where tablespace_name=’SYSTEM’ and owner not in (‘SYS’,’SYSTEM’,’OUTLN’); OWNER TABLE_NAME —– ———- SCOTT T SQL> alter table scott.t move tablespace users; Table altered. SQL> select owner, table_name from […]

Huge downtime on forums.oracle.com today. After landing on an Error-500 page, I discovered a quick and neat overview of oracle patchsets, accessible without metalink account : http://www.oracle.com/technology/support/patches.htm Still waiting for 9.2.0.8 Solaris by the way, announced for 2006Q3, whatever this mean

I recently posted about Oracle Password Repository (OPR). I did get a comment from Andreas Piesk about something similar in Oracle, the wallet. Let’s do a quick test. First, I create a .sqlnet.ora in my home directory (I do not want to mess up the system-wide sqlnet.ora). $ cat /home/lsc/.sqlnet.ora SQLNET.WALLET_OVERRIDE=TRUE WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/home/lsc))) I now create […]

I just read about a query to retrieve last modification row of a date SQL> SELECT ora_rowscn FROM tab_test; ORA_ROWSCN ———- 351744 351744 351744 351744 351744 351744 6 rows selected. SQL> UPDATE tab_test SET valeur=valeur*1.1 WHERE col_id=1; 3 rows updated. SQL> commit; Commit complete SQL> SELECT ora_rowscn FROM tab_test: ORA_ROWSCN ———- 351744 351744 351744 371423 […]

I just registered to Oracle OpenWorld in October in San Francisco… Well, I know it is a long long long way to the west, but I will survive again, but this time I will avoid Delta Airlines, they refused to serve me a glass of wine last year in the plane! I am going to […]

I read forums.oracle.com frequently. I have read and answered thousands of questions there. Those days, they launched a new release, I do not know what the improvements are, but it is fairly unstable. Well, it has been worst in the past, but I keep getting We’re sorry, the server encountered an unexpected condition and timetouts […]