138 reputation
9
bio website jeffkemponoracle.com
location Perth, Australia
age 39
visits member for 5 years, 1 month
seen Mar 28 at 7:08

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).


Mar
17
comment User agent string starting with “rm” - hacker?
Appreciate the advice, will do. Just doing the best I can here...
Mar
17
comment User agent string starting with “rm” - hacker?
I've downloaded and installed a patch for bash from suse.com, and now the shellshock tester (shellshocker.net) is reporting my server is no longer vulnerable. Phew!
Mar
16
awarded  Commentator
Mar
16
comment User agent string starting with “rm” - hacker?
Now I'm scared....
Mar
16
revised User agent string starting with “rm” - hacker?
added 747 characters in body
Mar
16
asked User agent string starting with “rm” - hacker?
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