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

Feb
4
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
Feb
1
answered Serialize :new in trigger
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
25
answered Sync data between 2 databases Oracle 10g
Nov
24
revised Oracle - Service Account vs Database Account?
added 32 characters in body
Nov
24
answered Oracle - Service Account vs Database Account?
Nov
10
comment Does extending datafiles affect performance
Netapp virtual disks attached to a SAN
Nov
10
revised Does extending datafiles affect performance
added 52 characters in body
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?