mbreslow

# I was running spectaql to generate documentation for my GraphQL API and it complained about
# directives that I had in my schema file. I threw errors including
#   - Unknown directive "@model".
#   - Unknown directive "@auth".
#   - Unknown directive "@index".
#   - Unknown directive "@hasOne".
# These are all directives you would use when developing an Amplify app.
#
# Created this file to include as the first schemaFile in specaql.yml so that the graphql
# parser is aware of the directives and can simply ignore them.

mbreslow

SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       S.Username,
       S.Program,
       'exec rdsadmin.rdsadmin_util.kill('||s.sid||','||s.serial#||');'
FROM   gv$session s
       Join Gv$process P On P.Addr = S.Paddr And P.Inst_Id = S.Inst_Id
Where  S.Type != 'BACKGROUND'