Reputation
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
15 37
Newest
 Revival
Impact
~247k people reached

Nov
10
comment Does extending datafiles affect performance
The proposal is to make all datafiles 16GB, old and new. New data would then be added across all the datafiles that have been extended.
Nov
10
asked Does extending datafiles affect performance
Nov
9
awarded  Tenacious
Nov
3
comment Optimizing DB for performance by archiving/partitioning
how much is "huge amounts of data" in terms of number of rows and size?
Oct
30
comment Is there any way to connect to a remote Oracle DB using VB.net?
Then your connection string is incorrect. You need host, database name and port
Oct
30
comment Is there any way to connect to a remote Oracle DB using VB.net?
What is the error you get when you test the connection?
Oct
30
comment Is there any way to connect to a remote Oracle DB using VB.net?
So, from Visual Web Developer can you connect to the database? There should be a "Test connection" option.
Oct
30
comment Is there any way to connect to a remote Oracle DB using VB.net?
assuming you have the oracle dlls in the bin of your web site folder can you connect from Visual Studio? What is the error(s) you get?
Oct
30
revised How to retrieve Oracle Key Performance Indicators in 5 minute intervals within a time range
added 3 characters in body
Oct
30
answered How to retrieve Oracle Key Performance Indicators in 5 minute intervals within a time range
Oct
27
comment Fill a GTT with external data each session
why not just truncate the GTT at the start of every run?
Oct
26
comment Error in trigger: table X is mutating, trigger/function may not see it
@Colin'tHart Well why not add a better answer then?
Oct
22
comment Proper way to upgrade Oracle database
@MindaugasRiauba from here it now says extended support until 2020, fees waived until 2017 but I think this means you must have an extended support contract to get patches blogs.oracle.com/UPGRADE/entry/no_extra_fee_for_extended
Oct
22
awarded  oracle
Oct
21
revised Proper way to upgrade Oracle database
added 468 characters in body
Oct
21
revised Reclaiming space from data files in Oracle
checked a comment I made and corrected it, incorporated in answer
Oct
21
revised Proper way to upgrade Oracle database
added 468 characters in body
Oct
21
answered Proper way to upgrade Oracle database
Oct
20
revised Reclaiming space from data files in Oracle
added 19 characters in body
Oct
20
comment Reclaiming space from data files in Oracle
My guess is you need data integrity more than you need disk space. Doesn't hurt to rebuild the indexes but there should be a reason to do so. Are they fragmented? If not, leave things alone.