Tips and Tricks

How do I monitor my Oracle performance scripts?

How do I monitor my Oracle performance scripts?

Then I will cover these eight important scripts for monitoring the Oracle database:

  1. Check instance availability.
  2. Check listener availability.
  3. Check alert log files for error messages.
  4. Clean up old log files before log destination gets filled.
  5. Analyze tables and indexes for better performance.
  6. Check tablespace usage.

What are the commands in Oracle?

This document discusses SQL commands used by Oracle Database Lite….4.1 SQL Command Types.


Which command is used by DBA remove user?

The “userdel” command is used to delete existing users.

How does Unix shell script connect to Oracle database?

Do the following steps to start SQL*Plus and connect to the default database:

  1. Open a UNIX terminal.
  2. At the command-line prompt, enter the SQL*Plus command in the form: $> sqlplus.
  3. When prompted, enter your Oracle9i username and password.
  4. SQL*Plus starts and connects to the default database.

How do I run a SQL script in Oracle?

To execute a script from the SQL Scripts page:

  1. On the Workspace home page, click SQL Workshop and then SQL Scripts. The SQL Scripts page appears.
  2. Click the View Report icon.
  3. In the far right column, click the Run icon for the script you want to execute.
  4. Click Run Now to submit the script for execution.

Does Oracle DBA need root access?

It is an inherent design feature of the software. If this is a breach of your policies then the policies need to be revised. The DBA will require root access to administer these features.

How do I drop a DBA in Oracle?

In order to drop a user, you must have the Oracle DROP USER system privilege. The command line syntax for dropping a user can be seen below: DROP USER edward CASCADE; If a user owns any database objects, that user can only be dropped with the Oracle DROP USER CASCADE command.

How do I run a shell script in Oracle?

Running a shell script from inside an Oracle database using DBMS_SCHEDULER

  1. create an OS user on the database server.
  2. create an OS group to allow both the new user and the oracle user to access to a common location.
  3. create a shell script owned by the OS user which writes to that common location.

How do I tune a query in Oracle?

Best Practices for Query Tuning in Oracle

  1. Best Practice 1: Clarify Goals.
  2. Best Practice 2: Identify High-Impact SQL Statements.
  3. Best Practice 3: Identify Your Execution Plan.
  4. Best Practice 4: Avoid Large Scans.
  5. Best Practice 5: Optimize SELECTs.
  6. Best Practice 6: Use a Third-Party Tool.

How do I start the Oracle database on HP-UX?

Oracle provides two UNIX / Linux scripts that assist DBAs with starting and stopping the database: dbstart and dbshut. For Windows platforms, the oradim utility is provided for starting and stopping the Oracle instance. As you will see, there are ways of automatically starting the database on HP-UX.

What is true about Oracle database on HP-UX?

Oracle Database on HP-UX has a true asynchronous Input-Output mechanism where Input-Output requests can be issued even though some previously issued Input-Output operations are not complete. This helps to enhance performance and ensures good scalability of parallel Input-Output processes.

What does Oracle DBA need to operate?

Oracle DBA need to operate on Unix/Linux/Solaris/AIX Operating system. He has to locate various file, process, kill session ,clear directories, schedule cron and various other activities.

Where is the oratab file in Linux?

The oratab file will reside in either /etc or /var/opt/oracle, depending on the UNIX / Linux version. It contains three data items separated by colons: The first field is the Oracle SID. The second field is the home directory for that Oracle SID.