954 reputation
25
bio website orawin.info
location United Kingdom
age
visits member for 2 years, 7 months
seen Mar 7 '12 at 9:10

Niall Litchfield is a DBA of 15 years standing, and OakTable member since 2003 with extensive experience of running databases on various x86(64) platforms. He blogs at orawin.info


Sep
1
awarded  Yearling
Sep
1
awarded  Yearling
Feb
16
comment How could sequence.nextval be null in Oracle?
Corbin, what I mean (and Kevin) is that something odd is going on between your code and oracle - if you run the test purely in SQL you don't get the effect. But see Phil's comment about the audit trigger (which you could try disabling).
Feb
16
comment Oracle aggregate function performance
do you have a tkprof/xplan showing this behaviour?
Feb
16
answered Database structure for a mailing list.
Feb
16
comment How could sequence.nextval be null in Oracle?
by the way a version with the traditional approach of using a trigger for the the_id column and the procedure as follows also ran quicker create or replace PROCEDURE Insert_Record3 (p_name IN dbse13142.name%type, p_userid IN dbse13142.userid%type, p_theid OUT dbse13142.the_id%type) IS BEGIN INSERT INTO dbse13142 (name, userid) VALUES (p_name, p_userid) returning the_id into p_theid; END; /
Feb
16
answered How could sequence.nextval be null in Oracle?
Feb
8
comment Oracle 11g see transaction or session start time
you could try the "versions of" flashback query in that case.
Feb
8
comment Isssue with Database Links converting OEM Job to DBMS_Scheduler Job
not seen this one myself Leigh, most dblinks I've seen rely on hard coded passwords (which have their own issues).
Feb
8
answered Oracle 11g see transaction or session start time
Jan
26
comment What's the most cost effective or cheapest way for high availabity on Oracle Standard Edition One?
bear in mind that using non-oracle virtualization often has nasty license implications (you have to license the entire underlying hardware the virtual cluster is running on)
Jan
26
comment Oracle Enterprise Manager Jobs Failing Initialization
Leigh I don't expect this to be correct, given its you that asked, but can you double check that the user executing the task has been explicitly granted execute privileges on the package that you reference.
Jan
25
comment How do I find my current SCN?
I see you have your answer. You should also read Riyaj's article at orainternals.com/2012/01/20/scn-what-why-and-how
Jan
19
answered ORA-04020 on Oracle SE1 (11.2.0.1)
Jan
19
answered What's the most cost effective or cheapest way for high availabity on Oracle Standard Edition One?
Jan
13
answered Why performance degradation with query hint FIRST_ROWS(1000)?
Jan
13
comment Where can I find autoextend events?
Jack, theoretically yes, in practice adding a new datafile rather than autoextending will avoid the impact on the users session (and place it on an admin session ).
Jan
12
comment How do you protect against malicious PREPROCESSOR attacks in Oracle External Tables?
bear in mind when doing this that Oracle database code like UTL_FILE for example can almost certainly access the pre-processor folder/directory as well so you might need to review access within the database as well as at the o/s level.
Jan
12
answered Oracle 10g: Is it possible to designate a undo point?
Jan
11
awarded  Editor