This tutorial is designed for Software Professionals, who are willing to learn PL/SQL Programming Language in simple and easy steps. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. Incidentally there is some clean-up to do when a long-running SELECT is aborted: the previous versions of the rows are no longer needed.PDF Version Quick Guide Resources Job Search Discussion If you are really impatient, you could get the same result by finding the shadow process ( v$process.spid where addr = v$session.paddr and sid=) on the server and just issuing a kill command at the shell. If the shadow process is in a state where it is itself waiting for an operation to complete (such as a big I/O request to the OS) then it is not until that completes that it can advance to the next "tick" and find the break command waiting for it. a signal in Unix terms) across the network. However in order to actually process this, the shadow process on the Oracle side has to come back and read that message - it is a request only, there is no way to send a true interrupt (i.e. Under the covers, when you abort a query, an Oracle client application sends OCIBreak(). I expect you will find Toad is waiting for Oracle to roll back your transaction - which Oracle will continue to do in the background even if Toad is killed.
0 kommentar(er)
