Boss with due respect
connection is different then transaction...
manindra
Last Activity: Nov 26 '07, 11:55 AM
Joined: Oct 29 '07
Location:
-
select * from user_tab_column s...Leave a comment:
-
MSSQL to Oracle Migration Performance issues
Recently we migrated our product from MS-SQL 2000 to Oracle 9i. We see lot of performance degradation due to migration. Some times complex queries are hitting 10 fold slower than SQL Server.
Reasons could be,
1.The Oracle Server with respect to configuration may have issues.
2.The SQL server optimized queries are not suitable for Oracle(The normal cases, such as datatypes, syntax etc are already taken care).
... -
Virtual Private Database
Hi everyone,
I just havea small query.
Is it necessary to have a transaction (through java/j2ee etc code ) even for just reading the rows from the database if the database has vpd implementation.
The reason I am asking this is because , the senior most DBA has asked java developers to have transaction even for getting the read only data , which is not making lot of sense to me . Can any one help me out... -
I am talking in general , the queries were optimezed in sql server but after migration to oracle 9i they are not working fine.
I just want to know if there is some known preexisting technical reasons which is resulting in such a degradation....Leave a comment:
-
MSSQL to Oracle Migration Performance issues
Recently we migrated our product from MS-SQL 2000 to Oracle 9i. We see lot of performance degradation due to migration. Some times complex queries are hitting 10 fold slower than SQL Server.
Reasons could be,
1.The Oracle Server with respect to configuration may have issues.
2.The SQL server optimized queries are not suitable for Oracle(The normal cases, such as datatypes, syntax etc are already taken care).
...
No activity results to display
Leave a comment: