Oracle Client/Server

Do I need Oracle Server  to do some performance tuning?
Does Oracle Client able to do the work also?
I need to know what should I ask for Oracle Server or Client to DBAs to do some performance tuning.
Would I be able to use OEM on Oracle Client?
Who is Participating?

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

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.

slightwv (䄆 Netminder) Commented:
Yes, you need access to a database to tune a database.

When you install the Oracle database software, the client is built in.  You only need an additional client when installing on a remote machine to access the database or when specifically necessary for something like version testing.

OEM is browser based these days so all you need is a browser and access to the server.
lium1Author Commented:
I don't have Oracle software on my machine.
So, which one I need dbas team to install/order, Oracle Client or Oracle Server software and what roles and privileges do I need to ask for to do performance tuning?
slightwv (䄆 Netminder) Commented:
I should also point out that tuning in a different environment can be problematic.  You need to make sure the remote database behaves like the final database as it relates to performance.

Just because a query runs fast on serverA doesn't necessarily mean it will perform the same on serverB unless both servers are shown to have similar data/setup/etc...

>>which one I need dbas team to install/order, Oracle Client or Oracle Server software and what roles and privileges do I need to ask for to do performance tuning

To have a database, you need Server.

Since this will be your database, you should be able to be the DBA.

Like your previous question:  I don't know the specific minimum permissions you need since tuning can mean many things to many people.

I rarely go beyond the EXPLAIN PLAN and access to a few V$ views.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

lium1Author Commented:
Sorry for not addressing the question precisely!
DBAs team has database on Oracle Server.
I have only access to SQL Developer.
What do I need to install/access Oracle Client or Server and do I have to ask them to have access to OEM?
Or, when Oracle software either client or server is installed, OEM is available?
slightwv (䄆 Netminder) Commented:
What you need to install depends on what you want to do.

This question and your previous questions involve tuning.

What I'm not sure about is: tuning what?

If you are just tuning SQL, then SQL Developer may be all you need because EXPLAIN PLAN might be good enough.

If you need to tune the entire database from memory to disk usage, you need more access.

Now:  If you need to do database/performance tuning and don't have access to the production system to perform these tasks on the live system, then you need a system where you can get that access.

If you need another database to tune:  You need Oracle Server.

If you need a remote copy of tools like tkprof/sqlplus, then you need the Client (remember the client is automatically installed with the server).

I cannot say exactly what you need because I don't understand what you specifically need to do.
Mark GeerlingsDatabase AdministratorCommented:
If your DBA team has an Oracle database, and you have SQL Developer, you don't need to install anything else.  You can use SQL Developer to develop, test and run SQL statements and/or PL\SQL procedures, functions, triggers, packages, etc.

Your DBA team will have to give you an Oracle username that you can use in SQL Developer, and they will have to give that Oracle user account whatever database privileges you need.  No, they do not have do anything specific for SQL Developer, because security in Oracle is controlled by the user login name.  The tool that you use, whether that is: SQL Developer, SQL*Plus, TOAD, Oracle Forms or even Excel or any other ODBC-based tool doesn't make any difference for security in an Oracle database.

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
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.