Database Administration (MOSC)

MOSC Banner

prompt entry

edited Aug 3, 2014 12:27PM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi,

I try to run the following :

set pages 10000

set long 65536

set linesize 80

break on spid skip page

column osuser format a8 heading "O/SUser"

column process format a7 heading "CPid"

column spid format a7 heading "SPid"

column username format a15 heading "DbUser"

column status format a1 heading "S"

column event format a15 heading "WaitResn"

column wait_time format 99 heading "Time"

accept response prompt "Enter OS User ID, Client PID, or Server PID: "

from here :

Oracle SQL Tuning Guide

Can any one tell me if I should provide all three OS User ID, Client PID, or Server PID ?

Or only one would be enough ? More over how to find the available values from database ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center