629 reputation
17
bio website
location
age
visits member for 1 year, 8 months
seen Oct 17 at 4:01

Oct
10
comment How can I prevent having inconsistent data under isolation level serializable in Oracle SQL?
Why don't you merge these two statements (SELECT+UPDATE) into a single one? Try to put the select into where clause of the update.
Sep
25
awarded  Critic
Aug
25
comment Optimal way of loading, registering, indexing and querying a huge XMLDB
They probably are not about to abandon this technology, but that deprecated part of the API in 12c again :(
Aug
25
comment Optimal way of loading, registering, indexing and querying a huge XMLDB
Broad question - vague answer. Oracle completely changed XMLDB between versions 9i and 10g. Since that time they no more push this technology. Few years ago this technology was supposed to "safe the whole world", but today it seams that "XML everywhere" is not so good idea. XMLDB SDK is no more separately downloadable from Oracle. XMLDB client libs are not bundled with InstantClient nor with Oracle Express DB. It's quite hard to find examples(OCI) nor guidelines from Oracle about this technology - so I really wonder what are their intentions with this technology.
Aug
22
comment ORA-02049 and ORA-02063 Errors
Do you execute this Select For UPDATE NOWAIT via Dblink? Or is this table local one? Generally when you session touches a DB link (even for reading) your active transaction (if you have any) is labeled as distributed. Different rules are in play when you are running distributed transaction. Also distributed transaction can not start in a database being accessed via DBLink. The distributed transaction coordinator must be the "first" database - therefore you must execute some DML in your "first" database before executing Select For UPDATE NOWAIT via DBLink. Please provide more complex sample
Aug
20
answered What is the meaning of “sga_max_size= # internally adjusted”
Aug
20
answered How do I tell the actual IOPS used by Oracle?
Aug
18
answered ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”
Aug
13
answered Oracle ROWID, can we assume it is sequential in a insert-only scenario?
Aug
13
comment Oracle 11.2 Explain Plan takes too long
I'm not sure whether is this your case but maybe Oracle has problems to "age out" some other execution plan from library cache. It is a shared area where are all the execution plans stored. Look into AWR report whether you see something related to wait event "library cache mutex". What you are doing is against vendor(Oracle's) recommendations - you application can not scale. Colin is right you should at least use cursor sharing.
Jul
21
comment RAC, data guard, physical stand by and impdp
Yes. Especially when standby is located in some distant location. For every write onto local disk (redo) you also have to wait till data are sent over the network, then written on standby and acknowledge is sent back to primary. For large deployments this might case 30-50% slowdown. If you are about to load a lot of data, maybe you should set protection mode to max performance before the load.
Jul
16
awarded  Informed
Jul
9
comment RAC, data guard, physical stand by and impdp
It should work like that. At least for user not having DBA privs. For users having password in orapw file it might work differently.
Jul
9
answered RAC, data guard, physical stand by and impdp
Jun
16
answered External authentication using Oracle Standard
May
1
comment Oracle equivalent of mysqldump
Maybe try this one sql-dk.globalcode.info.
Mar
26
comment Is not in (a,b,c) faster than where != a, b, c
I'm not sure how is it in MySQL but in Oracle "in" and "not in" is just a syntactic sugar for conjunctions and disjunctions.
Mar
14
comment How to interpret undo statistics in Oracle AWR report?
just one comment. Oracle uses 2 algorithms for allocating space in UNDO. One for fixed sized ones the other for auto-extensible ones. When using fixed size UNDO then Undo Retention parameter is ignored.
Mar
12
comment Oracle RAC Vs SQL Server Cluster
In cluster terminology the difference is "Active-Pasive" vs. "Active-Active" cluster. Or you can say Oracle tries (sometimes really only TRIES) to be both High Availability (HA) and High Performance (HP) cluster.
Feb
28
comment What are definer and invoker rights in database, Oracle and MysQL?
In Oracle the definer rights (default) are something like suid bit in Unix. The procedure is executed with privs of it's owner.