When is a temporary tablespace used?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
In which cases a temporary tablespace is required?
It's mentioned in Oracle documentation but I do not understand why it's being used.
I'm using Oracle 12c r2
Thanks in advance, Peter
sql oracle
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
asked Nov 16 '18 at 19:32
petarpetar
545
add a comment |
In which cases a temporary tablespace is required?
It's mentioned in Oracle documentation but I do not understand why it's being used.
I'm using Oracle 12c r2
Thanks in advance, Peter
sql oracle
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
asked Nov 16 '18 at 19:32
petarpetar
545
add a comment |
In which cases a temporary tablespace is required?
It's mentioned in Oracle documentation but I do not understand why it's being used.
I'm using Oracle 12c r2
Thanks in advance, Peter
sql oracle
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
asked Nov 16 '18 at 19:32
petarpetar
545
In which cases a temporary tablespace is required?
It's mentioned in Oracle documentation but I do not understand why it's being used.
I'm using Oracle 12c r2
Thanks in advance, Peter
sql oracle
sql oracle
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
asked Nov 16 '18 at 19:32
petarpetar
545
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
asked Nov 16 '18 at 19:32
petarpetar
545
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
edited Nov 17 '18 at 10:40
William Robertson
8,55232233
8,55232233
asked Nov 16 '18 at 19:32
petarpetar
545
asked Nov 16 '18 at 19:32
petarpetar
545
asked Nov 16 '18 at 19:32
petarpetar
545
545
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Temporary tablespaces are used in many places. But a simple example might be a SORT operation that is too big to fit into memory. In the case, the sort "spills" to TEMP - basically the temporary tablespace is used to hold some of the sort segments while the sort takes place in memory.
This is just one of many examples.
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
1
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
1
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53344257%2fwhen-is-a-temporary-tablespace-used%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Temporary tablespaces are used in many places. But a simple example might be a SORT operation that is too big to fit into memory. In the case, the sort "spills" to TEMP - basically the temporary tablespace is used to hold some of the sort segments while the sort takes place in memory.
This is just one of many examples.
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
1
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
1
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
add a comment |
Temporary tablespaces are used in many places. But a simple example might be a SORT operation that is too big to fit into memory. In the case, the sort "spills" to TEMP - basically the temporary tablespace is used to hold some of the sort segments while the sort takes place in memory.
This is just one of many examples.
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
1
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
1
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
add a comment |
Temporary tablespaces are used in many places. But a simple example might be a SORT operation that is too big to fit into memory. In the case, the sort "spills" to TEMP - basically the temporary tablespace is used to hold some of the sort segments while the sort takes place in memory.
This is just one of many examples.
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
Temporary tablespaces are used in many places. But a simple example might be a SORT operation that is too big to fit into memory. In the case, the sort "spills" to TEMP - basically the temporary tablespace is used to hold some of the sort segments while the sort takes place in memory.
This is just one of many examples.
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
answered Nov 16 '18 at 20:17
BobCBobC
2,9621613
2,9621613
1
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
1
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
add a comment |
1
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
1
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
1
1
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
Another example is when joining two tables; depending on the join method, Oracle may need to keep data around temporarily to do that join.
– Mark Stewart
Nov 17 '18 at 4:46
1
1
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
Also used for temporary tables, including the internal ones used when a query needs to temporarily materialise a result set.
– William Robertson
Nov 17 '18 at 10:45
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53344257%2fwhen-is-a-temporary-tablespace-used%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
