138 reputation
8
bio website jeffkemponoracle.com
location Perth, Australia
age 39
visits member for 4 years, 10 months
seen Nov 9 at 0:20

Oracle Database Designer and Developer

Since 2000 Jeffrey has designed, developed, maintained and enhanced a variety of large and small custom applications for the government sector using Oracle Database 7.3, 8i, 9i, 10g and 11g; Application Express 3.1, 3.2, 4.0, 4.1, and 4.2; Oracle Forms 4.5, 6i, 9i and 10g; Oracle Reports 2.5, 6i and 9i.

He has particular interests and experience in Oracle SQL, PL/SQL, database performance tuning, and Oracle Application Express (APEX).


Apr
8
awarded  Popular Question
Apr
20
awarded  Popular Question
Dec
19
awarded  Critic
Jul
26
awarded  Teacher
Jul
26
comment How to diagnose frequent “500 Internal Server Error” on Oracle Apex
thanks - certainly might have been the cause. Thankfully I haven't had this problem for years now. +1 anyway :)
Apr
29
comment How to delete data and free up disk space in Oracle DBMS 9i
What do you mean "supposedly"? In what way do you think that DELETE doesn't delete the data? (i.e. DELETE+COMMIT removes the records from the table so that subsequent (non-flashbacked) queries will not return those records)
Apr
29
comment How to delete data and free up disk space in Oracle DBMS 9i
DELETE only removes records from the table; it never deallocates the segments from the data files, and never coalesces empty space within the data files.
Apr
29
comment How to delete data and free up disk space in Oracle DBMS 9i
I don't think DUMP TRAN is a valid command in Oracle.
Apr
27
answered How to diagnose frequent “500 Internal Server Error” on Oracle Apex
Apr
17
awarded  Editor
Apr
17
revised How to diagnose frequent “500 Internal Server Error” on Oracle Apex
deleted 161 characters in body
Apr
12
answered Database security
Apr
12
comment How to diagnose frequent “500 Internal Server Error” on Oracle Apex
Please note: I'm an Oracle developer, not a DBA or Unix guru :)
Apr
12
asked How to diagnose frequent “500 Internal Server Error” on Oracle Apex
Dec
15
awarded  Student
Dec
14
awarded  Supporter
Dec
14
awarded  Autobiographer
Aug
10
comment Send emails from Linux via Google SMTP
Ok, I've read qmail.jms1.net/test-auth.shtml and worked out how to continue sending emails via the ISP.
Aug
10
comment Send emails from Linux via Google SMTP
Sorry, I really am at sea once I'm outside Oracle - I don't understand how stunnel would work, and the centos link appears to be broken. Also, I did mention that I couldn't get the sendmail option working either.
Aug
10
comment Send emails from Linux via Google SMTP
Definitely need the 101 :) I'm using Oracle Enterprise Linux 5.1, and rhn_register requires a CSI, which I don't have.