722 reputation
27
bio website
location
age
visits member for 2 years, 1 month
seen 9 hours ago

1d
comment How to check state of oracle databse
what about v$instance?
Mar
27
comment How to disable flashback query logging for a specific table (Oracle)?
I'm afraid this question is not well defined. redo, undo, flashback-logs are different things, although they are strictly connected. Do you have problems with redologs generated, flashback logs generated, undo space usage or disk i/o in general?
Mar
27
revised Compressing partition - what about index?
added 709 characters in body
Mar
27
comment Compressing partition - what about index?
yes you're right. the SQL was wrong. I fixed it - only one partition should be used.
Mar
27
revised Compressing partition - what about index?
added 24 characters in body
Mar
26
answered Compressing partition - what about index?
Mar
25
answered How do i prevent executing os command in oracle 11g
Mar
12
comment IO contention on raid5 happens?
Your question is too generic. For many HW implementations there is practically no difference in performance between RAID5 and RAID1+0. You should at least mention some Oracle AWR stast, OS IO stats and HW specs.
Mar
10
comment ORA-04031: unable to allocate 32 bytes of shared memory
you should also flush the whole shared pool, not just a buffer cache.
Mar
10
comment ORA-04031: unable to allocate 32 bytes of shared memory
this not logged in message look like your session crashes, when you try to flush buffer pool. you should check alert log to prove/disprove it.
Mar
10
answered ORA-04031: unable to allocate 32 bytes of shared memory
Mar
10
comment ORA-04031: unable to allocate 32 bytes of shared memory
oh no sry. this has nothing to od with OS limits. I was wrong. You probably have an application which parses too many SQL statements and Oracle is unable to allocate more ram for library cache.
Mar
10
comment ORA-04031: unable to allocate 32 bytes of shared memory
sure. You have to check SGA sizing against OS limits.
Mar
10
comment ORA-04031: unable to allocate 32 bytes of shared memory
1st you should check altert log file. Then edit your question and add OS platform. And then you also should check installation guide - memory sizing.
Mar
9
comment Queries hang when accessing Oracle via ODBC and Python
possible duplicate of dba.stackexchange.com/questions/59200/…. Also some SSL VPNs do not like TCP packets having OOB bit set. These get either merged into TCP stream or discarded. You can also use DISABLE_OOB.
Mar
2
comment OCIEnvCreate failed to create environment handle after installing oracle_fdw
try to execute lsof -p 3854. Theoretically instant client's libclntsh.so should work even without ORACLE_HOME set, but at least you should have LD_LIBRARY_PATH set. Is it possible that your postresql was started via init.d/rc.d script and necessary env variables were not exported? Try to stop postgresql and start it manually from command line.
Feb
23
comment Why the Order by clause avoid index scan and taking long time in Oracle 11g
It does not matter how important the flag is for users, but what is it's selectivity. So maybe you should exclude them from the index or put a MSMT_TIME before all those flags. PS: your query does not filter by to all the IS_... flags.
Feb
23
answered Why the Order by clause avoid index scan and taking long time in Oracle 11g
Feb
20
comment Is it possible to configure SQLNet / TNS_ADMIN options *without* sqlnet.ora file?
I'm afraid this question should be addressed to Oracle support. And most probably they will answer, that there is no way. BTW: is does not make too much sense to produce these diag traces without having ADRCI installed, but this is also Oracle's problem.
Feb
20
comment Corrupt date fields causing query failure in Oracle
can check exec. plan? If there was an index in all table columns, then the date could be read from an index - instead from table - I'm just guessing. BTW: the date dump looks ok. The older Oracle versions sometimes did not check date format when inserted via OCI, but this does not seem to be this case. You can also execute ALTER DATABASE DUMP BLOCK to get real data from disk. File number and block id can be extracted from ROWID.