Asif Faleel
asked on
Check Oracle parameters are configured optimally
Hi,
Are there any tools to check whether the oracle parameters are configured optimally for performance based on the configuration of the Server.
Why i mention is that we are doing a Data migration from SQL to Oracle and seems that the process takes days to complete. Have checked the OS but resources are not fully occupied.
Please help.
Asif
Are there any tools to check whether the oracle parameters are configured optimally for performance based on the configuration of the Server.
Why i mention is that we are doing a Data migration from SQL to Oracle and seems that the process takes days to complete. Have checked the OS but resources are not fully occupied.
Please help.
Asif
By which way you are going to do migration from SQL to Oracle, I mean are you using any converter or manually. If you are using any converter tool then specifications required to configured Oracle will be provided by the tool itself. If not then i don't think so there is any tool that can check the parameters but i found a link may be it will helpful to you http://docs.oracle.com/cd/B10501_01/server.920/a96653/init_params.htm
>>but i found a link may be it will helpful to you
Doubtful. It is for version 9i which hasn't been supported for many years. That is also the Data Guard guide.
>>Are there any tools to check whether the oracle parameters are configured optimally for performance based on the configuration of the Server.
No. Since every database has different needs there really isn't any way for a tool to know what the system needs.
>>Have checked the OS but resources are not fully occupied.
Something has to be working: Which is most active, CPU, Disk I/O ?
If you have a LOT of free RAM: Give more memory to Oracle.
I would also look at how your disks are configured. Make sure you aren't trying to write to the same disks at the same times.
I would disable indexes prior to inserting data then enable them when complete.
How are you doing the data migration?
Doubtful. It is for version 9i which hasn't been supported for many years. That is also the Data Guard guide.
>>Are there any tools to check whether the oracle parameters are configured optimally for performance based on the configuration of the Server.
No. Since every database has different needs there really isn't any way for a tool to know what the system needs.
>>Have checked the OS but resources are not fully occupied.
Something has to be working: Which is most active, CPU, Disk I/O ?
If you have a LOT of free RAM: Give more memory to Oracle.
I would also look at how your disks are configured. Make sure you aren't trying to write to the same disks at the same times.
I would disable indexes prior to inserting data then enable them when complete.
How are you doing the data migration?
One of the advantages of Oracle is that it is very configurable, for different: number of CPUs; number and type of disks; amount of RAM; number of user connections; type of application (transaction-processing or Data Warehouse); size of database; etc.
One of the disadvantages of Oracle is that you have to tune it (or you will be disappointed by the performance).
If you need help tuning Oracle for your server, storage and application, you will have to give us some of your details.
One of the disadvantages of Oracle is that you have to tune it (or you will be disappointed by the performance).
If you need help tuning Oracle for your server, storage and application, you will have to give us some of your details.
ASKER
Server is running Oracle Ent Linux as a Virtual Machine.
RAM 46GB
12 Virtual CPU's
Swap 23GB
Partition which Runs Oracle has 250GB
Running Oracle DB 11g.
Thats to configuration of the server.
RAM 46GB
12 Virtual CPU's
Swap 23GB
Partition which Runs Oracle has 250GB
Running Oracle DB 11g.
Thats to configuration of the server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks