RAC

[Babo]

is there a way to enable the tool to access the gv$ views instead of v$ ?
thank you.
Andrew

 

[Theod]

Hi,

since 10g? the gv$ views exists also on non-Rac and PLD could use them as standard.

But you can edit/customize all session-views yourself.
At Tools/Sessions there is a Button to Define Session Queries.

 

[Babo]

hmm.
i changed the select * from v$session to select * from gv$session.

i don't see column for "inst_id" .... What else do i need to change?

also you said that PLD ca use gv$ views as "standard". Did you mean that i can change from v$ to gv$ for the whole tool ? If so, then how ?

thank you
andrew

 

[Theod]

Hi,

select * from gv$session is right. I'm on a non rac, and there ist inst_id the first column of gv$Session.

Do you see this column if you execute the query in sql-window. I didn't see sometimes another column (SID) in the session window unil I gave an alias.

"PLD could use them as standard" - this was for Marco, so he should change the session-queries.

 

[Babo]

desc gv$session:

inst_id	number	y
saddr	raw(8)	y
sid	number	y
serial#	number	y
audsid	number	y
paddr	raw(8)	y
user#	number	y
username	varchar2(30)	y
command	number	y
ownerid	number	y
taddr	varchar2(16)	y
lockwait	varchar2(16)	y
status	varchar2(8)	y
server	varchar2(9)	y
schema#	number	y
schemaname	varchar2(30)	y
osuser	varchar2(30)	y
process	varchar2(12)	y
machine	varchar2(64)	y
terminal	varchar2(30)	y
program	varchar2(48)	y
type	varchar2(10)	y
sql_address	raw(8)	y
sql_hash_value	number	y
sql_id	varchar2(13)	y
sql_child_number	number	y
prev_sql_addr	raw(8)	y
prev_hash_value	number	y
prev_sql_id	varchar2(13)	y
prev_child_number	number	y
plsql_entry_object_id	number	y
plsql_entry_subprogram_id	number	y
plsql_object_id	number	y
plsql_subprogram_id	number	y
module	varchar2(48)	y
module_hash	number	y
action	varchar2(32)	y
action_hash	number	y
client_info	varchar2(64)	y
fixed_table_sequence	number	y
row_wait_obj#	number	y
row_wait_file#	number	y
row_wait_block#	number	y
row_wait_row#	number	y
logon_time	date	y
last_call_et	number	y
pdml_enabled	varchar2(3)	y
failover_type	varchar2(13)	y
failover_method	varchar2(10)	y
failed_over	varchar2(3)	y
resource_consumer_group	varchar2(32)	y
pdml_status	varchar2(8)	y
pddl_status	varchar2(8)	y
pq_status	varchar2(8)	y
current_queue_duration	number	y
client_identifier	varchar2(64)	y
blocking_session_status	varchar2(11)	y
blocking_instance	number	y
blocking_session	number	y
seq#	number	y
event#	number	y
event	varchar2(64)	y
p1text	varchar2(64)	y
p1	number	y
p1raw	raw(8)	y
p2text	varchar2(64)	y
p2	number	y
p2raw	raw(8)	y
p3text	varchar2(64)	y
p3	number	y
p3raw	raw(8)	y
wait_class_id	number	y
wait_class#	number	y
wait_class	varchar2(64)	y
wait_time	number	y
seconds_in_wait	number	y
state	varchar2(19)	y
service_name	varchar2(64)	y
sql_trace	varchar2(8)	y
sql_trace_waits	varchar2(5)	y
sql_trace_binds	varchar2(5)	y

 

[Theod]

Hi,

yes there is the missed column. But what is now your question? If your'e looking for the bind-Variable try :inst_id.

 

[Babo]

Theod,
i want to see the inst_id in the "Sessions" window. To expend my question - i would like to see tool accessing gv$ views instead of v$ as it does by default.

you also mentioned smth about "alias"? not sure...

I just changed the sql in the "session" definition to "select a.* from gv$session a ... " and now it displays the inst_id.

BUT - it only shows the inst_id =1 . where is the second node ?

Thank you
Andrew

 

[Theod]

Hi,

now your session window works - fine.

Why it only shows inst_id = 1, no idea.
May be you see just your node your'e connected to. Try as SYS?

 

[Babo]

well, if i were indeed connected to the RAC DB i would probably didn't ask silly questions. Oh well

 

[Babo]

so i can report that it does work - i do can see inst_id.
the only question is the it doesn't return the columns in the same order as they are specified in the gv$session view.
It seems that it return the "old" columns ( from the v$session ) nicely formatted and added the "new" ones to the end.

I wonder why and how to change this ?

 

[Theod]

Hi,

for this I use NOT select a.* from ... BUT select a.col1, a.col2 from ...

HTH