{"id":1835,"date":"2021-02-08T07:00:00","date_gmt":"2021-02-08T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=1835"},"modified":"2025-08-22T23:08:57","modified_gmt":"2025-08-22T20:08:57","slug":"pos-vriskoyme-grigora-ti-trechei-se-mia","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-grigora-ti-trechei-se-mia\/","title":{"rendered":"How do we find what queries are running in an Oracle database?"},"content":{"rendered":"<p>Many times we will need to quickly search for a session that is executing a query. We may want to see the plan it ran with, the memory it is consuming, the sql text, the session id, if it has an uncommited transaction, the undo it is binding, who it was run by, if it is blocked, the command to kill it, etc. <\/p>\n\n\n\n<p>In this need, I created the query that we will see that combines information from various systemic views.<\/p>\n\n\n\n<p>Putting or removing in <em>where<\/em> the comment <em>&#8220;&#8211;&#8221; <\/em>we can change the criteria we are looking for such as sql id, sid, sql text etc.<\/p>\n\n\n\n<p>We also have the ability to start <strong>trace <\/strong>in this session and see the trace information through a ready command at <strong>tkproof <\/strong>(in this command we will then need to put the corresponding password).<\/p>\n\n\n\n<p>But be careful in the field where we read the trace for tkproof, the information comes from the view <strong>diag_info<\/strong> which exists from version 11 onwards, in case we want to run in an older version, we comment this field.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The query for the current sessions<\/h2>\n\n\n\n<p>With the following query we can find the information from any session that exists at the moment.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">SELECT \n   h.LOGON_TIME,\n   h.SID,\n   h.SERIAL#,\n   p.SPID,\n   h.inst_id,\n   u.username,\n   h.osuser,\n   h.machine,\n   h.program,\n   h.service_name,\n   h.status,\n   h.module,\n   h.STATE,\n   s.sql_text,\n   s.SQL_FULLTEXT,\n   h.sql_id,\n   z.PLAN_HASH_VALUE,\n   h.event,\n   h.blocking_session_status,\n   h.blocking_instance,\n   h.blocking_session,\n   round(s.sharable_mem\/1024\/1024,1) SHARABLE_MEM_MB,  \n   round(s.persistent_mem\/1024\/1024,1) PERSISTENT_MEM_MB,  \n   round(s.runtime_mem\/1024\/1024,1) RUNTIME_MEM_MB,        \n   round(p.PGA_ALLOc_MEM\/1024\/1024,1) PGA_ALLOCATED_MB,\n   (case tr.status when 'ACTIVE' then 'True' else '' end) as Is_Uncommited,\n   round(tr.used_ublk * (select block_size from dba_tablespaces where tablespace_name= 'UNDOTBS1') \/ (1024*1024),2) as UNDO_SIZE_MB\n   ,t.tablespace as Temp_Tablespace\n  , round (((t.blocks * 8192) \/ 1024 \/ 1024 \/ 1024), 2) as Temp_Size_GB\n   ,'exec sys.dbms_system.set_sql_trace_in_session(' ||h.SID||','||h.SERIAL#||',true);' as start_trace\n   ,'tkprof ' ||  (select pap.value from gv$diag_info pap WHERE pap.name = 'Diag Trace' and  pap.inst_id = h.inst_id  ) || '\/' || LOWER(SYS_CONTEXT('userenv','instance_name')) ||   '_ora_' || p.spid || '.trc'  || ' \/home\/oracle\/Scripts\/trace.txt explain='||u.username||'\/Password sort=exeela sys=no' as TKPROOF\n   ,h.failover_type\n   ,h.failover_method\n   ,'alter system kill session '''||sid||', '||h.serial#||', @'||h.inst_id||''' immediate;' KILL_CMD \n   ,'kill -9 '||p.spid kill_spid\nFROM\n   gv$session h\nLEFT JOIN gv$SQLAREA s ON h.sql_hash_value = s.hash_value and h.sql_ADDRESS = s.ADDRESS and h.inst_id = s.inst_id \nLEFT JOIN (select PLAN_HASH_VALUE,SQL_ID,MAX(TIMESTAMP) from gv$sql_plan GROUP BY PLAN_HASH_VALUE,SQL_ID ORDER BY PLAN_HASH_VALUE DESC,MAX(TIMESTAMP) DESC) z ON h.SQL_ID = z.SQL_ID  \nLEFT JOIN DBA_USERS u ON h.USER# = u.USER_ID\nLEFT JOIN gv$process  p ON p.ADDR = h.PADDR and p.inst_id = h.inst_id\nLEFT JOIN gv$transaction tr ON tr.SES_ADDR = h.SADDR and tr.inst_id = h.inst_id \nLEFT JOIN gv$sort_usage t on h.saddr = t.session_addr\nWHERE  1=1\nand h.sid != (select sys_context('USERENV','SID') from dual)\nand h.status = 'ACTIVE'\nand h.service_name != 'SYS$BACKGROUND'\n--and h.SID = 4533\n--and s.sql_id = 'av7nawu9dw14a'\n--and s.sql_text LIKE '%session%'\n--and h.OSUSER LIKE '%app%'\n--and h.blocking_session_status = 'VALID'\n--and u.username LIKE '%SYS%'\nORDER BY h.LOGON_TIME DESC\n\/<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">The result<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"145\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/4-owr.png\" alt=\"\" class=\"wp-image-1847\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/4-owr.png 939w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/4-owr-300x46.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/4-owr-768x119.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"923\" height=\"145\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/5-owr.png\" alt=\"\" class=\"wp-image-1846\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/5-owr.png 923w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/5-owr-300x47.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/5-owr-768x121.png 768w\" sizes=\"auto, (max-width: 923px) 100vw, 923px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"138\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/6-owr-1024x138.png\" alt=\"\" class=\"wp-image-1845\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/6-owr-1024x138.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/6-owr-300x40.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/6-owr-768x104.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/08\/6-owr.png 1031w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In case the query was executed a few hours ago, we should look for it in the history view <strong><a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14237\/dynviews_1007.htm#REFRN30299\" target=\"_blank\" rel=\"noreferrer noopener\">ACTIVE_SESSION_HISTORY<\/a><\/strong> (ASH).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The query for old sessions<\/h2>\n\n\n\n<p>In order to be able to find the corresponding information, we should combine historical views with the central information being in <em>active_session_history<\/em> (ASH)<em> <\/em>which we mentioned before.<\/p>\n\n\n\n<p>Information corresponding to it is recorded there <em>gv$session<\/em> of the active sessions and saves a record for the image that each session had then in each second (<em>sample_time<\/em>).<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select \n  a.inst_id,\n  a.sample_time, \n  a.session_id, \n  a.session_serial#,\n  u.username, \n  a.user_id,\n  a.sql_id,\n  s.sql_text,\n  p.PLAN_HASH_VALUE,\n  a.module, \n  a.machine,\n  a.blocking_session_status,\n  a.blocking_session,\n  a.blocking_session_serial#,\n  round(a.temp_space_allocated\/1024\/1024\/1024) temp_usage_in_gb\nfrom GV$ACTIVE_SESSION_HISTORY a \nLEFT JOIN DBA_USERS u ON a.USER_ID = u.USER_ID\nLEFT JOIN dba_hist_sqltext s ON a.sql_id = s.sql_id\nLEFT JOIN (select distinct PLAN_HASH_VALUE,SQL_ID, TO_CHAR(TIMESTAMP, 'DD-MM-YY HH') as Timin from dba_hist_sql_plan)p ON a.sql_id = p.sql_id and p.Timin = TO_CHAR(a.sample_time, 'DD-MM-YY HH') \nwhere 1=1\n--and s.sql_text like '%FROM CUSTOMER%'\n--and a.session_id = 4570 --switch it\n--and a.session_serial# = 24864 --switch it\n--and u.username LIKE '%SYS%'\n--and a.temp_space_allocated\/1024\/1024\/1024 > 3\norder by a.sample_time DESC\n\/<\/pre>","protected":false},"excerpt":{"rendered":"<p>Many times the need will arise to quickly look for a session that executes a query. We might want to see the plan it ran with, the memory it consumes, the sql text, the session id, if it has an uncommitted transaction, the undo it binds, who it ran from, if you block, the command to [\u2026]<\/p>","protected":false},"author":1,"featured_media":704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,16],"tags":[29,5,48,30],"class_list":["post-1835","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-oracle-db","tag-databases","tag-oracle-database","tag-performance_tuning","tag-rdbms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-grigora-ti-trechei-se-mia\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03b8\u03b1 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b7\u03b8\u03b5\u03af \u03b7 \u03b1\u03bd\u03ac\u03b3\u03ba\u03b7 \u03bd\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c8\u03ac\u03be\u03bf\u03c5\u03bc\u03b5 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1 \u03ad\u03bd\u03b1 session \u03c0\u03bf\u03c5 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03af \u03ad\u03bd\u03b1 query. \u039c\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b8\u03ad\u03bb\u03bf\u03c5\u03bc\u03b5 \u03bd\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c4\u03bf \u03c0\u03bb\u03ac\u03bd\u03bf \u03bc\u03b5 \u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03ad\u03c4\u03c1\u03b5\u03be\u03b5, \u03c4\u03b7 \u03bc\u03bd\u03ae\u03bc\u03b7 \u03c0\u03bf\u03c5 \u03ba\u03b1\u03c4\u03b1\u03bd\u03b1\u03bb\u03ce\u03bd\u03b5\u03b9, \u03c4\u03bf sql text, \u03c4\u03bf session id, \u03b1\u03bd \u03ad\u03c7\u03b5\u03b9 uncommited transaction, \u03c4\u03bf undo \u03c0\u03bf\u03c5 \u03b4\u03b5\u03c3\u03bc\u03b5\u03cd\u03b5\u03b9, \u03b1\u03c0\u03cc \u03c0\u03bf\u03b9\u03cc\u03bd \u03ad\u03c4\u03c1\u03b5\u03be\u03b5, \u03b1\u03bd \u03bc\u03c0\u03bb\u03bf\u03ba\u03ac\u03c1\u03b5\u03c4\u03b5, \u03c4\u03bf command \u03b3\u03b9\u03b1 \u03bd\u03b1 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-grigora-ti-trechei-se-mia\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-08T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-22T20:08:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle\",\"datePublished\":\"2021-02-08T04:00:00+00:00\",\"dateModified\":\"2025-08-22T20:08:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/\"},\"wordCount\":59,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"keywords\":[\"Databases\",\"Oracle Database\",\"Performance Tuning\",\"RDBMS\"],\"articleSection\":[\"Databases\",\"Oracle Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"datePublished\":\"2021-02-08T04:00:00+00:00\",\"dateModified\":\"2025-08-22T20:08:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-grigora-ti-trechei-se-mia\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle Database\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/oracle-db\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle - DataPlatform.gr","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-grigora-ti-trechei-se-mia\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle - DataPlatform.gr","og_description":"\u03a0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03b8\u03b1 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b7\u03b8\u03b5\u03af \u03b7 \u03b1\u03bd\u03ac\u03b3\u03ba\u03b7 \u03bd\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c8\u03ac\u03be\u03bf\u03c5\u03bc\u03b5 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1 \u03ad\u03bd\u03b1 session \u03c0\u03bf\u03c5 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03af \u03ad\u03bd\u03b1 query. \u039c\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b8\u03ad\u03bb\u03bf\u03c5\u03bc\u03b5 \u03bd\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c4\u03bf \u03c0\u03bb\u03ac\u03bd\u03bf \u03bc\u03b5 \u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03ad\u03c4\u03c1\u03b5\u03be\u03b5, \u03c4\u03b7 \u03bc\u03bd\u03ae\u03bc\u03b7 \u03c0\u03bf\u03c5 \u03ba\u03b1\u03c4\u03b1\u03bd\u03b1\u03bb\u03ce\u03bd\u03b5\u03b9, \u03c4\u03bf sql text, \u03c4\u03bf session id, \u03b1\u03bd \u03ad\u03c7\u03b5\u03b9 uncommited transaction, \u03c4\u03bf undo \u03c0\u03bf\u03c5 \u03b4\u03b5\u03c3\u03bc\u03b5\u03cd\u03b5\u03b9, \u03b1\u03c0\u03cc \u03c0\u03bf\u03b9\u03cc\u03bd \u03ad\u03c4\u03c1\u03b5\u03be\u03b5, \u03b1\u03bd \u03bc\u03c0\u03bb\u03bf\u03ba\u03ac\u03c1\u03b5\u03c4\u03b5, \u03c4\u03bf command \u03b3\u03b9\u03b1 \u03bd\u03b1 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-grigora-ti-trechei-se-mia\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-02-08T04:00:00+00:00","article_modified_time":"2025-08-22T20:08:57+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle","datePublished":"2021-02-08T04:00:00+00:00","dateModified":"2025-08-22T20:08:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/"},"wordCount":59,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","keywords":["Databases","Oracle Database","Performance Tuning","RDBMS"],"articleSection":["Databases","Oracle Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/","url":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/","name":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","datePublished":"2021-02-08T04:00:00+00:00","dateModified":"2025-08-22T20:08:57+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-grigora-ti-trechei-se-mia\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Oracle Database","item":"https:\/\/www.dataplatform.gr\/category\/databases\/oracle-db\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 queries \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=1835"}],"version-history":[{"count":11,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1835\/revisions"}],"predecessor-version":[{"id":5942,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1835\/revisions\/5942"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/704"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=1835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=1835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=1835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}