meta user
network profile
|
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. |
|
Dec 6 |
comment |
How do you show SQL executing on an Oracle database? I think I was just in a rush when I first threw it together... after messing with all that ltrim/tochar/floor/mod stuff I just wanted to name the column and get out :) |
|
Dec 6 |
comment |
How do you show SQL executing on an Oracle database? RUNT = Runtime. |
|
Dec 6 |
answered | How do you show SQL executing on an Oracle database? |
|
Dec 5 |
answered | Oracle Script For Getting Long Active Sessions |
