Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to find if a session is resumable
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1079112419.439654_at_yasure...
> > Is there any way to create a demo that would allow students to be shown > the difference between a resumable session and a non-resumable session? > Any suggestions will be appreciated. Code even more so. >
Scenario One:
connect scott/tiger
create tablespace X datafile 'xxxxx' size 2M;
create table bigemp tablespace X as select * from emp;
insert into bigemp select * from bigemp;
/
/
/
/
/
SQL ERROR: Unable to extend bigemp by Y in tablespace X.
Scenario Two:
connect scott/tiger
alter session enable resumable;
create tablespace X datafile 'xxxxx' size 2M;
create table bigemp tablespace X as select * from emp;
insert into bigemp select * from bigemp;
/
/
/
/
/
<Dirty Great Pause>
Run off to the alert log at this point to tail it.
Works well enough for me.
Regards
HJR
Received on Fri Mar 12 2004 - 13:33:22 CST
![]() |
![]() |