{"id":938,"date":"2005-09-29T12:00:00","date_gmt":"2005-09-29T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=938"},"modified":"2005-09-29T12:00:00","modified_gmt":"2005-09-29T12:00:00","slug":"html-db","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/09\/29\/html-db\/","title":{"rendered":"HTML DB"},"content":{"rendered":"

Today I had one of those minor buzzes of excitement when I started to play around with Oracle’s hosted HTML DB environment.<\/p>\n

Without wanting to go into my current feelings about work, you could say things are a little quiet. I’m trying to find things to do but I’ve joined just when there’s a serious lull in work, a lack of communication from my new colleagues and my boss has just gone on holiday. So, rather than sit around surfing the net in someone else\ufffds time, I thought I should keep building my knowledge of Oracle in the hope that it helps the company down the line. When some real work comes up, I\ufffdll drop this activity.<\/p>\n

Anyway, I don’t have access to a database yet (!) so I thought I would combine improving my knowledge of HTML DB with creating a test environment that I can access from anywhere. Oracle answered both questions with it’s hosted HTML DB environment. All you have to do is apply for an account here<\/a><\/p>\n

You supply a few details, including a reason for your request, and Oracle review the request and then create you a workspace, which includes an associated schema. That process took a couple of hours.<\/p>\n

Next, you go to login and there’s a sample application along with a few schema objects that it’s based on and good old EMP and DEPT. However, what I wanted to do was play around with the supplied SH (Sales History) schema that comes with the database > 9i so I picked up the sh_cre.sql script from here<\/a>, uploaded it and ran it. To be honest, I wasn’t expecting it to work first time as I didn’t bother reviewing it in any great detail but it worked perfectly and created all the tables and indexes I was looking for. Cool!<\/p>\n

I still need to load some data, but at least the objects are there. Next I tried creating some surrounding objects – MVs (worked fine) and Bitmap Indexes and so on. Eventually, I ran out of schema space, but when I was looking for some space I could recover, I realised that most of these objects were partitioned because they’re intended to simulate some of the Data Warehousing features. I don’t really need that, so I’ve just converted them to be non-partitioned which will save space for my small tests.<\/p>\n

I’m really surprised at the functionality level on offer for nothing 😉<\/p>\n

So now I have a 10.1.0.3 play schema that’s available at home, work, in a hotel, from the downstairs bedroom …<\/p>\n

I’ve started playing around with one of the examples from my upcoming CASE paper and the first thing to notice is that it doesn\ufffdt allow SQL*Plus formatting commands, which is understandable.<\/p>\n

By the way, while I’ve been typing this, I just had my request for an extra 10Mb approved in 5 minutes! I can’t promise that the service will always be this good, but I’d recommend it unreservedly at this stage. It’s proving to be excellent fun and very useful into the bargain.<\/p>\n

Cheers,<\/p>\n

Doug<\/p>\n","protected":false},"excerpt":{"rendered":"

Today I had one of those minor buzzes of excitement when I started to play around with Oracle’s hosted HTML DB environment. Without wanting to go into my current feelings about work, you could say things are a little quiet. I’m trying to find things to do but I’ve joined just when there’s a serious… Continue reading HTML DB<\/span><\/a><\/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-938","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1429,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/20\/time-matters-db-time\/","url_meta":{"origin":938,"position":0},"title":"Time Matters – DB Time","date":"August 20, 2008","format":false,"excerpt":"[In retrospect, the title of that first blog post might have suited the subject, but doesn't translate too well for subsequent related blog posts. That was a lack of planning or foresight on my part. These blog posts are tumbling out of my head in a fairly incoherent way. Maybe\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1432,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/01\/time-matters-db-cpu\/","url_meta":{"origin":938,"position":1},"title":"Time Matters – DB CPU","date":"September 1, 2008","format":false,"excerpt":"In his comment on the last post, John Beresniewicz mentioned the following property of DB CPU :-\"... 'DB time' fully contains 'DB CPU' and both are measured values (which means in particular that 'DB CPU' is not inflated by runq time)\"I'd like to talk about the end of that sentence\u2026","rel":"","context":"With 24 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/DBCPU4.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1320,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g-part-2\/","url_meta":{"origin":938,"position":2},"title":"Parallel Query and 11g – 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":1506,"url":"http:\/\/orcldoug.com\/blog\/2009\/07\/02\/real-time-sql-monitoring-in-sql-developer\/","url_meta":{"origin":938,"position":3},"title":"Real-Time SQL Monitoring in SQL Developer","date":"July 2, 2009","format":false,"excerpt":"Features in this post require both Diagnostics and Tuning Pack licenses.If you haven't seen 11g's Real Time SQL Monitoring feature, you need to. It's one of the most useful Oracle performance troubleshooting tools I've seen since I started working with Oracle too long ago. I was first aware of it\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/xsqldev1.png.pagespeed.ic.lI55QN9Yna.png","width":350,"height":200},"classes":[]},{"id":971,"url":"http:\/\/orcldoug.com\/blog\/2005\/06\/22\/dba_registry-again\/","url_meta":{"origin":938,"position":4},"title":"dba_registry (again)","date":"June 22, 2005","format":false,"excerpt":"(Switch humour on ...)Many thanks to Pete Finnegan for making sure that my embarassing mistakes kick around on recent entries at Orablogs! (and off)To quote Pete ...Doug seems embarrassed a little by this but this is common mistakeMake that very embarassed, if you don't mind! Here are the reasons 1)\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1367,"url":"http:\/\/orcldoug.com\/blog\/2007\/12\/08\/ukoug-days-three-and-four\/","url_meta":{"origin":938,"position":5},"title":"UKOUG Days Three and Four","date":"December 8, 2007","format":false,"excerpt":"I was up pretty early on Wednesday to carry on working on my presentation. As I said to someone, once they saw how basic the content was, it would be difficult to see why it takes so long but a lot of it is tweaking with the flow and by\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/OFA.jpg","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/938","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=938"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/938\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=938"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}