Reputation
825
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 8
Impact
~34k people reached

  • 0 posts edited
  • 1 helpful flag
  • 32 votes cast
1d
answered Deferrable Foreign Key Constraints
May
22
comment Oracle - Slow queries without prepending schema name or providing hint
what about alter session set current_schema=schema;? Are you using performance baselines on your database?
May
22
answered SQL actually executed as planned in ORACLE?
May
21
awarded  Citizen Patrol
May
20
comment Generate rows based on value in 2 columns. Bug?
There were several issues with CTEs in Oracle. You should mention exact version you use. I'd recommend you to use hins MATERIALIZE and INLINE on factored sub-queries to see if query output changes. I also saw situation where dropping functional index on the table, changed the result of the query.
May
18
answered How to block external connections for an Oracle database?
May
18
comment Install JVM for Oracle 11g XE
OT: if you want investigate problems with email you should set SMTP_SERVER to localhost on your DB server. Then Oracle will imediatelly handover email to Sendmail/Postfix and then it's MTAs problem. In the /var/log/maillog you will find a reason why email delivery was postponed. And Unix admins usualy know what to do in these cases.
May
18
answered Install JVM for Oracle 11g XE
May
18
comment How to block external connections for an Oracle database?
bind listener to localhost(127.0.0.1) only
May
15
comment Out of memory error from Java stored procedure
Then I'm afraid it is best to contact Oracle support. Or try to use Oracle 12c, 11g still uses JVM 1.5.
May
15
comment Out of memory error from Java stored procedure
Just guessing, are you running 32bit or 64bit version of the database?
May
14
comment is it a good practice to ip block dev/test app servers from production database server?
For replication you can use cross-site restores. i.e. you can restore backup of prod db on dev database. By doing this you will get fresh data in dev, you will validate that prod backups can be restored, you will get hand-on practice on backup/restore procedures and also your dev will be identical copy of prod (including physical layout, statistics and exec plans).
May
14
comment TAF vs SCAN in Oracle 11gR2
SCAN works only if you're openning a new connection. Also there are some limitations for JDBC driver. TAF might be usefull for load balancing or for hot-patching.
May
11
comment Oracle database not open and ORA-00600 error
Or maybe even better - contact Oracle support. There might be various solutions like disable parallel recovery, completely bypass media recovery or apply some ad-hoc patch before opening the database, but it's better when it is recommended by Oracle support.
May
7
comment Critical tablespace usage UNDOTBS (96%)
Not necessary, undo night be full of rollback segnents but still it might be ok
May
7
answered Critical tablespace usage UNDOTBS (96%)
May
7
comment How to migrate a database from SQL server to Oracle?
there where whole books written about this subject. Some of them were recommended in this site too. Use Google, search on SO.
May
6
comment Is there any point in specifying the precision and scale of a number for a foreign key?
For example it might help someone to deduce whether integers or floats are stored in it.
Apr
29
answered Oracle 11g encrypt traffic from clients to database server
Apr
29
answered Is using ASM a pre-requisite for RAC?