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

Mar
29
comment Is deleting secondary files a bad idea?
how do you know they are superfluous? If they are empty will data be loaded into them again in the future?
Mar
20
comment How to create a function(table_name) that return a collection in Oracle?
@JustinCave Yes, that would be cleaner and less work
Feb
24
comment Optimize large table design
I see many databases that "just grew" that don't have enough memory or free disk space. I don't suppose a hardware upgrade is possible...
Feb
22
comment Selecting from random amount of tables with identical structure
please, just show us some of the table definitions, your example leaves me unclear as to what you are describing
Jan
21
comment Performance tuning of a SQL query
Please add some explain plans so we can see what plan the database is using. Telling us the oracle version is always helpful too.
Dec
18
comment I need to update a Oracle procedure via a .sql script
If you run that script in sql developer it will replace the existing procedure and will not change any data. Oh, and why do you put this on the client box, surely an onlogon trigger run from the database would avoid this?
Dec
11
comment Oracle Enterprise Manager 11g - restricting tablespace access
When he logs into OEM it is likely any commands issued run with the privileges of the OEM user. You should create a read only OEM user as a test.
Dec
8
comment Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express
how big is the database in file size? Does it use partitioning?
Nov
27
comment Oracle Materialized View Overloads Database
Depending on the importance of availability of the tables better hardware is probably cheaper and more effective. I see many production Oracle databases getting by on just enough memory when there is more that could be allocated.
Nov
10
comment Does extending datafiles affect performance
Netapp virtual disks attached to a SAN
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
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
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
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.