Reputation
2,459
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
15 36
Newest
 Tenacious
Impact
~227k people reached

2d
comment What is the best ways to filter data on the fly
more details please, how many records would you return for a typical search, what tool are you using to display the data to the end user, how many columns of what data types --example a query that returns CLOBS/BLOBS requires different solutions than a finance query
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.
Oct
20
comment Reclaiming space from data files in Oracle
What datafiles? Sys or SysAux tablespaces should be regarded with caution. Is the amount of data growing or static? Clob, non Clob?
Oct
2
comment How to load Excel file into temp table in ORACLE
what tools do you have: SQL developer, Toad, PL/SQL developer?? they all have built in's to make it easier
Oct
1
comment Is it possible to downgrade oracle 11.1.0.6.0 to 10.2.0.4.0?
how about a fresh install of 10.2 (out of support for many years) and then import your data from 11g?