meta user
network profile
| bio | website | orawin.info |
|---|---|---|
| location | United Kingdom | |
| age | ||
| visits | member for | 1 year, 9 months |
| seen | Mar 7 '12 at 9:10 | |
| stats | profile views | 101 |
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 |
|
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 |
answered | Oracle Enterprise Manager Jobs Failing Initialization |
|
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 |
|
Jan 11 |
revised |
Where can I find autoextend events? added 1030 characters in body |
