Oracle Developer Suite 10g 9.0.4.0.1 for Windows (forms developer) is not easy to obtain now, out of support by Oracle for a long time, but that version is still in use out there. So I have zipped both installation CDs here.
Read More Oracle Developer Suite 10g 9.0.4.0.1 windows software download mediaWerner Puschitz has details of how to use ulimit and limits.conf to change maximum processes and open file descriptors. But for processes running from cron, I found I had to additionally make the below changes (this is on old version: 32 bit Linux 2.4.21-27.ELsmp Red Hat Enterprise Linux AS release 3 (Taroon Update 4) – […]
Read More Cron fix for ulimit: max user processes: cannot modify limit:operation not permittedWant to connect as a particular user but don’t know their password? You can temporarily change it and then reset it back, if you have DBA/alter any user privilege: set pages 9999 lines 132 long 9999 column col1 form a132 SELECT DBMS_METADATA.get_ddl ( ‘USER’ , ‘MYUSER’ ) AS col1 FROM DUAL ; ALTER USER myuser […]
Read More Change oracle password temporarilyComments are used much less often in spfile than they were in old init.ora’s. Syntax for them is like: SQL> alter system set pga_aggregate_target=1g comment=’Andrew Fraser 13-May-2010 was 390m’ scope=spfile sid=’*’ ;
Read More Comments in spfile alter systemTo see when tables (or other objects) were created, first change your date format to display time: alter session set nls_date_format=’Dy DD-Mon-YYYY HH24:MI:SS’; Then in Oracle SQL Developer, right click on the table or object in question, select ‘open‘, and look at the ‘details‘ tab. Or alternatively still in SQL, look at the created column: […]
Read More Show date time tables were created