Oracle Database Administration

  https://github.com/nkarag/oracle_ready2run_scripts/ --------------------------------------------------------------------------------------------- -- Find the available execution plans for a specific SQL_ID -- --              Note that the AVG_ET_SECS (average elpased time) will not be accurate for parallel queries.  -- The ELAPSED_TIME column contains the sum of all parallel slaves. So the  --              script divides the value by the number of PX slaves used which gives an  --              approximation.  -- --              Note also that if parallel slaves are spread across multiple nodes on --              a RAC database the PX_SERVERS_EXECUTIONS column will not be set. -- -- author: Nikos Karagiannidis (C) 2013 - http://oradwstories.blogspot.com ---------------------...