Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Oracle SYS Objects

I'm attempting to create a simple dashboard to help me quickly isolate blocking activity in one of our Oracle databases. Essentially the query I want to run is similar to this:

 

SELECT
a.object,
a.type,
a.sid,
b.username,
b.osuser,
b.program,
c.sql_text
FROM v$access a
join v$session b
on a.sid = b.sid
join v$sql c on c.sql_id = b.sql_id

 

I find that typically my performance is better in powerBI when using direct query when I do NOT use custom queries. I would like to bring each of these three tables in using direct query, but I can't figure out how to specify the 'SYS' user and the objects do not show up in the hierarchy navigation pane, and I can't just changes the schema/user name to 'SYS'. I've tried everything I can think of, but the only way I can get it to work is to use 'select * from v$access' as a custom query. When I do that for all three tables and then join them with the relationship diagram it just performs way too slow. Using the above as a custom query works better.

 

Any tips for grabbing the SYS objects?

 

Here are some examples of the attempts I've tried:

 

 

2 Replies