54 reputation
13
bio website
location Hyderabad, India
age 28
visits member for 2 years, 10 months
seen Feb 14 '12 at 11:34

Jan
30
awarded  Notable Question
Sep
18
awarded  Popular Question
Feb
14
asked copy schema across different physical databases in db2
Dec
29
awarded  Supporter
Dec
29
comment Tuning SQL Server Performance
we are using normal SQL statements to return the blobs. A API Cursor gets created however on the server side to process the results. We are using a forward only result set from the JDBC layer.
Dec
28
revised Tuning SQL Server Performance
edited tags
Dec
28
asked Tuning SQL Server Performance
Dec
13
asked Fatal NI connect error 12170
Dec
5
asked Improve BLOB Writing Performance in Oracle 11g
Nov
17
awarded  Student
Nov
16
comment RAM Impact on Oracle database operations
i've added the trace 10046 at system level for both db's. Once the job finishes i will have more data to add
Nov
16
comment RAM Impact on Oracle database operations
Yup even i guessed the indices were causing an issue and removed them before running the inserts - the difference was still huge.
Nov
16
comment RAM Impact on Oracle database operations
the machines are same in terms of processor capacity and disk and oracle version. The workload is same across both the databases - one application runs against the database that inserts these rows. These inserts are made across multiple sessions - so tracing sessions was not helping.
Nov
16
comment RAM Impact on Oracle database operations
duplicating question from stack overflow - as it was suggested this is better suited.
Nov
16
asked RAM Impact on Oracle database operations
Nov
16
asked RAM Impact on database operations