599 reputation
16
bio website
location
age
visits member for 1 year, 5 months
seen 4 hours ago

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.
Feb
24
comment unable to allocate 4064 bytes of shared memory
As a 1st try look into V$SGA_RESIZE_OPS (resp. V$SGASTAT). There will you find reason why sga regions were resized and sizes of various SGA components. But the best you can do is to contact Oracle support. These types of errors might be very hard to investigate.
Feb
19
answered Oracle idle connections lost
Feb
14
comment What useful information can I get from ASH report which I cannot get from AWR report?
For example you might help you tell "What happend just before tha database crashed?"
Feb
10
comment Displaying user's password
This is real life situation. You can tell developers at least WHEN then password was changed. Then with some effort you can guess by whom it was changed. Of course you can not tell what the new password is. But at least you can identify the "culprit".
Feb
10
answered Displaying user's password
Feb
1
awarded  Yearling
Jan
13
comment Oracle 11g DBMS_CRYPTO invalid identifier
This package is not granted to PUBLIC by default. Ask DBAs for exec privs.
Jan
10
comment Oracle Transaction recovery: lock conflict caught and ignored
Is this message connected to same ORA- error number?
Dec
19
comment Automatically schema backup in Oracle
old fashioned exp/imp
Dec
17
answered Best Data compression technique in Oracle