568 reputation
37
bio website ba6.us
location North Carolina
age 42
visits member for 2 years, 7 months
seen Jan 12 at 3:07
Oracle DBA specializing in performance, development and tools. Interests: Oracle, Perl, PL/SQL, Software Development, Source Code Control systems, Compilers

Jan
12
comment SQL developer: Setup debugger for plsql
+1 to REW, I get reports of this all the time. Developer can work fine when database is on their subnet, but working from different network segment or VPN the debugging connection from the server back to SQLDeveloper (or other tool) does not make it. Local firewall may be one issue, but as REW said, if it can't connect back to you that is the root issue. Can you ping from the server to your local workstation?
Sep
16
awarded  Yearling
May
29
awarded  Enlightened
May
29
awarded  Nice Answer
Sep
16
awarded  Yearling
Jun
8
awarded  Caucus
May
23
answered Oracle DB administrator-specific security features
Apr
23
comment How do I limit Oracle to use specific ports?
All I can really say is "I don't know". Personally I wouldn't expect 1 port to take the place of dozens or hundreds of ports... But I have been working with Oracle for 10+ years and I am jaded :) Our client had less than a dozen concurrent connections and used it for ad-hoc queries so the connections were mostly idle. If you are funneling hundreds of OLTP type connections through it... it may handle it just fine I would say test it before you rely on it for production so no surprises.
Apr
23
answered How do I limit Oracle to use specific ports?
Mar
29
comment Reduce Size of SYSAUX
You don't mention your version but if you are using 11g Automatic SQL Plan Management you may be hitting a bug that allows its entried in SYSAUX to grow... a lot... details here juliandontcheff.wordpress.com/2011/06/13/…
Mar
27
comment Oracle GoldenGate replication is stuck
It is not very clear what your configuration is. Oracle or SQL Server as Source? Oracle or SQL Server as Target? Have you viewed the logs for the GG process that is causing the issue? For the target database have you confirmed it is a deadlock?
Feb
28
answered Overhead of DBMS_Profiler
Jan
27
comment Suggestions for SQL query repair tool or tips on building one?
If you have a reproducible test case you might consider forcing the Optimizer Compatibility to be an earlier version. I checked Oracle Support site [DOC ID 835701.1] and this wasn't mentioned as a workaround but it may be worth a shot. ALTER SESSION SET COMPATIBLE='10.2.0.4'; as 10.2.0.5+ is where they 'fixed' the issue which is causing you pain. If that works you can put it in play globally by getting your DBA to set the DATABASE level parameter instead of just setting it manually for your session.
Jan
23
answered How do I find my current SCN?
Jan
10
comment FREETEMPORARY on blob with no reference
@Andy I found the reference - Oracle Metalink Doc ID 802897.1 "How to Release the Temp LOB Space and Avoid Hitting ORA-1652" covers this, for 11g your option is to invoke FREETEMPORARY() or to exit session. They also mention a new event 60025 which is supposed to free temp segments when all the temp LOBs for a session are no longer used, but I didn't see any other detail on that.
Jan
9
comment FREETEMPORARY on blob with no reference
If you are unable to run FREETEMPORARY then I believe your only option is to disconnect/reconnect the session. This will cause a cleanup of any temp blob space used by that session. Had a similar issue here where we couldn't touch the app code, so we ended up tweaking their connection pool to expire and reconnect more frequently.
Jan
6
answered Restricting database access per IP addresses
Dec
28
awarded  Commentator
Dec
28
comment Where can I find autoextend events?
I don't think this is recorded. The closest I can think is DBA_EXTENTS which would have info on the changes in extents that may be a byproduct of an autoextend action, but there are no dates associated with the tables that make up the DBA_EXTENTS view.
Dec
7
comment Oracle Stopping - Can't Login All Of A Sudden -
Any clues in the alert log? What is your PROCESSES and SESSIONS parameter set to? If these are low then you may have bumped your head on this limit when trying to log in.