{"id":1002,"date":"2006-06-20T12:00:00","date_gmt":"2006-06-20T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1002"},"modified":"2006-06-20T12:00:00","modified_gmt":"2006-06-20T12:00:00","slug":"mysterious","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/06\/20\/mysterious\/","title":{"rendered":"Mysterious &#8230;"},"content":{"rendered":"<p>&#8230; and quite funny. I followed an incoming link through Statcounter and arrived <a href=\"http:\/\/www.presslie.plus.com\/\">here<\/a>.<\/p>\n<p>At the moment, the content is :-<\/p>\n<p><\/p>\n<pre>SQL&gt; startup mount<br\/>ORACLE instance started.<br\/><p><\/p><br\/>Total System Global Area 645922816 bytes <br\/>Fixed Size 1250644 bytes <br\/>Variable Size 184552108 bytes <br\/>Database Buffers 457179136 bytes <br\/>Redo Buffers 2940928 bytes <br\/>Database mounted.<br\/>SQL&gt; alter database open;<br\/>Database altered.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8230; and quite funny. I followed an incoming link through Statcounter and arrived here. At the moment, the content is :- SQL&gt; startup mountORACLE instance started.Total System Global Area 645922816 bytes Fixed Size 1250644 bytes Variable Size 184552108 bytes Database Buffers 457179136 bytes Redo Buffers 2940928 bytes Database mounted.SQL&gt; alter database open;Database altered.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1002","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1335,"url":"http:\/\/orcldoug.com\/blog\/2007\/11\/01\/rac-and-aix\/","url_meta":{"origin":1002,"position":0},"title":"RAC and AIX","date":"November 1, 2007","format":false,"excerpt":"One of the interesting aspects of working at my current site is that the DBAs don't install Oracle. Yes, I know, and I'm not going to elaborate on that statement other than to say it's a little frustrating and software management has become a much more interesting experience than I\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1062,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/21\/resumable-storage-allocation\/","url_meta":{"origin":1002,"position":1},"title":"Resumable Storage Allocation","date":"August 21, 2006","format":false,"excerpt":"At the moment I'm writing a short 9i\/10g New Features seminar for the developers at work. The idea is to run through lots of new features very quickly to see if anything lights their candle and they can then go off and investigate further afterwards.It occurred to me while I\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1649,"url":"http:\/\/orcldoug.com\/blog\/2011\/09\/21\/real-time-sql-monitoring-retention-part-2\/","url_meta":{"origin":1002,"position":2},"title":"Real-Time SQL Monitoring &#8211; Retention (part 2)","date":"September 21, 2011","format":false,"excerpt":"As I mentioned in my last post, I've been looking at increasing the SQL Monitoring Retention at my current site using _sqlmon_max_plan but, as well as confirming with Oracle Support that they're happy for us to do so, it would be nice to know what the resulting memory footprint would\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1319,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g\/","url_meta":{"origin":1002,"position":3},"title":"Parallel Query and 11g","date":"September 23, 2007","format":false,"excerpt":"I've been playing around with 11g on and off this week, re-running some of the tests in this document (PDF file).The main edits required to the scripts were simple ones to correct the locations of trace files, for example (where $ORACLE_BASE is \/ora on the 10g system) rm \/ora\/admin\/TEST1020\/udump\/*.trc and\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1320,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g-part-2\/","url_meta":{"origin":1002,"position":4},"title":"Parallel Query and 11g &#8211; Part 2","date":"September 23, 2007","format":false,"excerpt":"Now, that's weird. A little surprising might be more accurate and maybe I'm missing something.During the various tests with and without parallel hints and different parallel_io_cap_enabled settings, I expected the runs that didn't use parallelism to show up \"db file scattered read\" events in the trace files. For example, here's\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1030,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/21\/monitoring-index-usage\/","url_meta":{"origin":1002,"position":5},"title":"Monitoring Index Usage","date":"July 21, 2006","format":false,"excerpt":"A common requirement cropped up this week. A new Data Warehouse has just gone live and is still in the 'do we have the right indexes here' phase. In this case, the suspicion is that there are too many indexes in a specific schema and that a number of them\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1002"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1002\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1002"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}