Hot answers tagged oracle
2
As Ste says in his answer, temp tablespaces should be fine for this, so global temporary tables and other transient storage would be good.
If you wanted to use permanent tablespaces then you could DROP TABLESPACE my_tablespace INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS before system shutdown if the storage was going to be lost, and recreate on ...
2
Oracle does not record checkpoint information in tempfile. So, for the tempfile:
Oracle is able to start even if tempfile is missing. You will get a message in the alter log and you should recreate tempfile.
No backup is taken of tempfile so it's safe to loose it
There is no need to trick with any storage parameter for tempfile if resides on ephemeral ...
2
Depends how much data you need on the second database. Solutions are not to save query results on a second DB but duplicate data for querying on another DB. Basically the following techonologies:
Oracle Streams: it is a replication from one database to another one. Can be done by table or by schema.
Oracle Active Dataguard: it is basically a standby DB ...
1
In addition to what the others have said, you could keep some data in flat files and them copy the files to the ephemeral storage on startup. You could then access it using external tables. I don't know if this would be faster or better, but it is another possible use.
1
Deadlock (ORA-00060) are automatically resolved by Oracle and signalled in the alter.log.
Transactional locks have to solved manually.
You can kill session from sql command line using:
SQL> alter system kill session 'sid, serial#';
This will mark session for being killed whener it's possible. Sometime kill is not immediate. IF you want and immediate ...
Only top voted, non community-wiki answers of a minimum length are eligible
