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?
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.
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?
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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.
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.