Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 15 29
Newest
 Enlightened
Impact
~314k people reached

Jul
2
revised Oracle Rac With Scan Error
deleted 11 characters in body; edited tags
Jun
26
comment Partitioning existing table in Oracle
Look for unused columns in the source table.
Jun
17
answered Calculating overlap between groups
Jun
16
comment moving to Oracle 11.2.0.4
Please read the upgrade docs. Those questions are answered there.
Jun
14
reviewed Leave Open Count number of duplicate rows, sort from most to least (statistic)
Jun
14
reviewed Leave Closed Dealing with single quotes in a dynamic query
Jun
14
reviewed Approve Pairwise intersections
Jun
14
revised TNS-12500: TNS:listener failed to start a dedicated server process Oracle9i Database on Windows 2003 64x server
rolled back to a previous revision
Jun
13
comment Can we reuse a .dmp file(expdp) to perform import using data pump utility
Of course it can.
Jun
13
comment TNS-12500: TNS:listener failed to start a dedicated server process Oracle9i Database on Windows 2003 64x server
TNS:permission denied - check the Windows users that are used to start the database and listener service. Also disable UAC if that exists on 2003.
Jun
13
revised TNS-12500: TNS:listener failed to start a dedicated server process Oracle9i Database on Windows 2003 64x server
added 191 characters in body; edited tags
Jun
12
comment all_tables and dba_segments giving different space occupied by the same tables
Are your stats up to date on that table?
Jun
5
revised Duration of adding versus dropping a column
deleted 5 characters in body; edited title
Jun
5
answered Duration of adding versus dropping a column
May
28
comment Failure to start instance resource on1 node of a 3 node of an Oracle 12c RAC
What does the alert log for that instance say? What about the log file indicated in your quote above?
May
12
comment SELECT stuck giving results from the query result cache, though table has changed
Look, you're using undocumented parameters. Unless Oracle specifically advised you to do that, you're on your own. Either you open an SR to see if they feel like helping anyway, or you revert to supported/documented parameters. If you can reproduce the bug with a supported configuration, then you can claim it is a bug.
May
12
comment SELECT stuck giving results from the query result cache, though table has changed
AUTO isn't documented. I suggest you open an SR, playing with undocumented settings is a bit risky.
May
12
comment SELECT stuck giving results from the query result cache, though table has changed
show parameter result_cache
May
12
comment SELECT stuck giving results from the query result cache, though table has changed
Did you set the result cache mode to force? System or session-wide?
May
4
comment Oracle RAC takes forever dropping tables
Not normal tables, dictionary and fixed object stats. See the dbms_stats package.