Reputation
339
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 5
Newest
 Yearling
Impact
~19k people reached

  • 0 posts edited
  • 0 helpful flags
  • 37 votes cast
Mar
26
comment Mongo range query became extremely slow on large collection
Have you sorted this out? I have seen a post about a broken index after upgrade (older version though). Have you checked the query plan?
Mar
12
comment Mongo range query became extremely slow on large collection
Have you built the index after you changed the storage engine? My only idea at this moment is index fragmentation.
Oct
30
comment How to isolate 1 MongoDB config server
docs.mongodb.org/manual/tutorial/upgrade-revision/…
Oct
30
comment what is so special about MongoDB indexing?
What did you expect to be special? :-)
Jun
12
comment use of synonyms in oracle
Overview of synonyms
Apr
10
answered Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?
Mar
13
comment Exception in SQL client but not in stored procedure
You don't get the exception or the output?
Sep
6
comment What is the meaning of “select * from relational(owner.table)”?
Found this, might help: forums.oracle.com/thread/1042943?start=0&tstart=0
Mar
23
awarded  Yearling
Jan
30
comment SYSAUX tablespace is 98%
this thread: dba.stackexchange.com/questions/15790/reduce-size-of-sysaux might be of some use
Aug
10
comment Oracle DBCA utility: “Listener is not up or database service is not registered with it”
what does your SID_LIST_LISTENER section look like?
Aug
9
answered Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)
Jun
29
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
@Jim Thio, afaik, yes - if they use it for commercial purposes.
Jun
29
awarded  Commentator
Jun
29
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
Very nice explanation. I also wanted to compare those services to a bank.
Jun
29
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
docs.oracle.com/cd/E12151_01/doc.150/e12155/…
Jun
29
awarded  Critic
Jun
24
comment Which database?
There are too many factors that influence this kind of decision. Size of data is just one of them (and it would be more simple to list systems, which are not suitable for your needs). If there is no one esle in your company, who would be able to answer or give advice, the best you can do, is hire someone.
Jun
21
comment Optimization of an Oracle query
Try to run this on the remote database: EXPLAIN PLAN FOR Select * from Viewname where columnname='somevalue'; SELECT * FROM TABLE(DBMS_XPLAN.display); This will provide the explain plan mentioned by @Ben. Most probably the remote view is not optimal.
Jun
21
comment Optimization of an Oracle query
Is there a suitable index built on the remote table?