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
GulfITAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

amilie wilsonCommented:
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
slightwv (䄆 Netminder) Commented:
>>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?
Mark GeerlingsDatabase AdministratorCommented:
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.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

GulfITAuthor Commented:
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.
slightwv (䄆 Netminder) Commented:
Not sure what all that is supposed to tell us.

Hopefully your VM host software is supported by Oracle.  If you are running VMWare, you are out of luck.

Back to the question:
As we have mentioned, there is no magic wand to wave and have everything set up for you.

Off the top of my head I can think of a few questions that you need to know before you can even begin to configure your system:
What type of database (OLTP/DSS)?
How many concurrent users?
Types, sizes and numbers of expected transactions per day.

Even if you answer those, there are many more.  We really cannot cover everything you need to know on a Q&A site like this.

I suggest you bring in a hired consultant to sit with you to learn your proposed systems to help you design the database.

In a nutshell:
Give Oracle ALL the RAM you can as long as you NEVER swap to disk.  Then monitor and adjust as necessary.

>>Running Oracle DB 11g.

11g is pretty much at the end of its life.  For a new system, I would suggest 12c.

https://blogs.oracle.com/UPGRADE/entry/premier_support_for_oracle_11
End of Premier Support means that Oracle will not offer fixes for new issues unless an extra-cost offer called Extended Support has been purchased. But you'll still get Sustaining Support until you'll stop working on the release. For a description what terms such as Premier Support, Extended Support and Sustaining Support mean please refer to the Lifetime Support Policy.
.
For Oracle Database 11.2.0.4 - the Terminal (final) Patch Set for Oracle Database 11.2 - Oracle will waive (no extra cost, no action required) the first year of Extended Support to every customer with a valid support contract. Premier Support for Oracle Database 11.2 will still end on Jan-31, 2015, but you'll get Extended Support for Oracle Database 11.2.0.4 for one additional year at no extra cost. You can extend the Extended Support for Oracle Database 11.2.0.4 by a maximum of two additional years until 31-JAN-2018 - but then at the usual extra cost.
This information can be found in MOS Note:742060.1.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GulfITAuthor Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.