ASM Space UsageSimplified/automated datafile free disk space reclaimAdd additional disks to FRA diskgroup in...
How to Build a List from Separate Lists
Isn't a semicolon (';') needed after a function declaration in C++?
Is the percentage symbol a constant?
How can I handle players killing my NPC outside of combat?
Is it possible to narrate a novel in a faux-historical style without alienating the reader?
Proving the Borel-Cantelli Lemma
Python to write multiple dataframes and highlight rows inside an excel file
Did ancient Germans take pride in leaving the land untouched?
Sets which are both Sum-free and Product-free.
Have the UK Conservatives lost the working majority and if so, what does this mean?
Is there a configuration of the 8-puzzle where locking a tile makes it harder?
Why do single electrical receptacles exist?
Boss asked me to sign a resignation paper without a date on it along with my new contract
How do I avoid the "chosen hero" feeling?
Is there any danger of my neighbor having my wife's signature?
In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?
Is Screenshot Time-tracking Common?
How does holding onto an active but un-used credit card affect your ability to get a loan?
Identical projects by students at two different colleges: still plagiarism?
Why don't you get burned by the wood benches in a sauna?
What does an unprocessed RAW file look like?
What does @ mean in a hostname in DNS configuration?
Short story about a man betting a group he could tell a story, and one of them would disappear and the others would not notice
Can an attached stirge deal no more than 10 HP of damage before it detaches?
ASM Space Usage
Simplified/automated datafile free disk space reclaimAdd additional disks to FRA diskgroup in ASMHow to monitor space usage on ASM diskgroupsHow to load .dbf to run select queries?Row Directory in Oracle Block, How does it work?Oracle ASM: Freeing up spaceWhy my Oracle 12c database seems not to be started?After uninstall oracle, there is remaining directory. 'tfa'Database deployment using QSR (Quest Script Runner) is slowMigrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM
Oracle Version: 12.1.0.2
I had about 100 GB freespace on my +ASM diskgroup on Friday.
When I came back on Monday, I see only 45 gigs. How can I find what consumed my space?
Or is there a SQLPlus command (or) TOAD method we can use?
Your help is my salvation.
oracle oracle-11g-r2 oracle-12c oracle-asm
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
Oracle Version: 12.1.0.2
I had about 100 GB freespace on my +ASM diskgroup on Friday.
When I came back on Monday, I see only 45 gigs. How can I find what consumed my space?
Or is there a SQLPlus command (or) TOAD method we can use?
Your help is my salvation.
oracle oracle-11g-r2 oracle-12c oracle-asm
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
SQL Developermight have some pre-built Reports that are useful. How did you see "GB Free"?
– Michael Kutz
Oct 9 '18 at 10:25
add a comment |
Oracle Version: 12.1.0.2
I had about 100 GB freespace on my +ASM diskgroup on Friday.
When I came back on Monday, I see only 45 gigs. How can I find what consumed my space?
Or is there a SQLPlus command (or) TOAD method we can use?
Your help is my salvation.
oracle oracle-11g-r2 oracle-12c oracle-asm
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
Oracle Version: 12.1.0.2
I had about 100 GB freespace on my +ASM diskgroup on Friday.
When I came back on Monday, I see only 45 gigs. How can I find what consumed my space?
Or is there a SQLPlus command (or) TOAD method we can use?
Your help is my salvation.
oracle oracle-11g-r2 oracle-12c oracle-asm
oracle oracle-11g-r2 oracle-12c oracle-asm
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
asked Oct 9 '18 at 2:48
Aravindhan KAravindhan K
1217
1217
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
SQL Developermight have some pre-built Reports that are useful. How did you see "GB Free"?
– Michael Kutz
Oct 9 '18 at 10:25
add a comment |
SQL Developermight have some pre-built Reports that are useful. How did you see "GB Free"?
– Michael Kutz
Oct 9 '18 at 10:25
SQL Developer might have some pre-built Reports that are useful. How did you see "GB Free"?– Michael Kutz
Oct 9 '18 at 10:25
SQL Developer might have some pre-built Reports that are useful. How did you see "GB Free"?– Michael Kutz
Oct 9 '18 at 10:25
add a comment |
1 Answer
1
active
oldest
votes
Just use asmcmd, where you have cd, ls and du.
If you insist on doing this through SQL, then you can use views such as V$ASM_ALIAS, V$ASM_FILE, V$ASM_DISKGROUP.
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f219595%2fasm-space-usage%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
Just use asmcmd, where you have cd, ls and du.
If you insist on doing this through SQL, then you can use views such as V$ASM_ALIAS, V$ASM_FILE, V$ASM_DISKGROUP.
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
add a comment |
Just use asmcmd, where you have cd, ls and du.
If you insist on doing this through SQL, then you can use views such as V$ASM_ALIAS, V$ASM_FILE, V$ASM_DISKGROUP.
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
add a comment |
Just use asmcmd, where you have cd, ls and du.
If you insist on doing this through SQL, then you can use views such as V$ASM_ALIAS, V$ASM_FILE, V$ASM_DISKGROUP.
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
Just use asmcmd, where you have cd, ls and du.
If you insist on doing this through SQL, then you can use views such as V$ASM_ALIAS, V$ASM_FILE, V$ASM_DISKGROUP.
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
answered Oct 11 '18 at 11:22
Balazs PappBalazs Papp
26.2k2931
26.2k2931
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f219595%2fasm-space-usage%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
SQL Developermight have some pre-built Reports that are useful. How did you see "GB Free"?– Michael Kutz
Oct 9 '18 at 10:25