News of Oracle Server Tuning

Hi,

I want to delete some statements. I am running one simple delete statement in one table with rownum<10000 but it is taking nearly 10 to 15 mins.Table doesn't have any child table rows and triggers. Please tell me how to check this? Help me.

Thanks.

Hi,

I am creating threads to regarding performance tuning.
I need to check the package performance and need to improve the package performance.
1)How to check the package performance "each and every statement in the package"?
2)In the package using the delete statement to delete all records and observed that delete is taking long time to delete all the records in the table.This table is like staging table.
Daily need to clean the data before ...

Hi everyone,

I have Window server 2003 64 bit, Oracle 10g2 64-bit.
Recently i increase the RAM of my database server:
If previously it was a 8gb RAM server, I change to a 16gb RAM. How to I go about assigning the SGA_MAX_SIZE, how much should i increase? Any guideline like how much is use by kernal and so fore. Please suggest me.

Thanks

Hi all,

Why does Oracle prefer CPU cost to less I/O while generating execution plans?

I have been much into query tuning for last 1 month. I have seen that though CPU cost of a plan is low, the query essentially does not consume least time using this plan. By specifying an index hint, I was able to find a plan that caused much less I/O and hence the query took much less time. A ...

Hi,

I need help with the oracle security.
There are 3 users X, Y, and Z. The requirement is to provide an access to user X such a way he should be able to create procedure on User Y but not on User Z.
Does any one know what is the privilege we have to give to the user X to satisfy the user? Please let me know....
I thought to give X user "create ...

Hi,

I am going to install first time n i need help so i create a threads for it.. Hear is all details....
I want to install oracle form builder 10g. Can anyone share me the link from where I can download it? I have already Oracle form builder 6i. Should I uninstall 6i before installing form builder 10g?
Is it very complicated? Can any one give some ideas about it? Thanks in advance......

Thanks.

Hi,

I would like to know the what is the best way to do the Performance tuning on the Sql or pl/sql queries. How to identify those things which query is taking much time and what needs to take the action to avoid for long running queries. Could any one tell me I would like to know. Help me out....

Thanks....

Hi Friends,

We have strange issue of performance in our production database. Recently we upgraded our production database from Oracle 9.2.0.6 to Oracle 11.2.0.1. We already tested before upgrade about all applications working properly or not on UAT database. But after upgrading production database, some of applications are performing very slow behavior which were running so fine in Oracle 9i. An example one of our HR application is taking around 3 hours now in Oracle ...

Forums,

What is RAID? How it useful for deploying Oracle database server or SQL server?

Dear forums,

We impacted performance degradation on one of our very large Oracle database (Oracle 11g on AIX). After certain AWSTAT reports, we found one of big table is affecting with heavy disk I/O. Referenced SQL statements are fetching more rows and due to this reason, big table involved in full table scan. Due to this reason, heavy disk I/O is occurring which resulted in performance degradation of whole server. All other applications are impacting ...