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.<\/p>\n
It occurred to me while I was putting some slides together that 9i’s resumable storage allocation feature is under-used so I thought I’d blog about it here. It’s amazing how many times this facility would have helped us avoid big problems at work.<\/p>\n
I also realised, and not for the first time, that what differentiates the best people I’ve worked alongside from the rest is that they realise how easy it is to knock up a quick demonstration of a feature to make sure it works as expected and show it to others. I wasn’t sure of how the contents of one of the views would look so I tried it out. Of course, you need a play database for this (but everyone should have at least one of those kicking around) but this entire demo took 10 minutes to put together, even allowing for initial head-scratching, typos etc. I’d far rather spend 10 minutes playing than asking different people and surfing the net. The hands-on aspect makes the information ‘stick’ better and you might come across quirks you weren’t expecting. Anyway, here’s the example<\/p>\n
TEST1020> create tablespace resumable_testThis session will hang because it’s filled up the tablespace. You can see this in another DBA session<\/p>\n
TEST1020> select user_id, status, sql_text, error_msg\nAnd if we go back and look at the TESTUSER session, the statement has completed<\/p>\n
TEST1020> insert into res select * from res;\nFull documentation for 9i is here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"