Oracle Database is taking too much waiting timeMaterialized view taking too much timeUninstalling Oracle...
Writing Cyrillic text to a file
In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?
what does しにみえてる mean?
My cat mixes up the floors in my building. How can I help him?
What's a good word to describe a public place that looks like it wouldn't be rough?
Incorporating research and background: How much is too much?
Find some digits of factorial 17
Caruana vs Carlsen game 10 (WCC) why not 18...Nxb6?
Can a hotel cancel a confirmed reservation?
How do Chazal know that the descendants of a Mamzer may never marry into the general populace?
Why has the mole been redefined for 2019?
How can I get my players to come to the game session after agreeing to a date?
Why did other German political parties disband so fast when Hitler was appointed chancellor?
Why is mind meld hard for T'pol in Star Trek: Enterprise?
Can I string the D&D Starter Set campaign into another module, keeping the same characters?
Normalization for two bulk RNA-Seq samples to enable reliable fold-change estimation between genes
How to count the characters of jar files by wc
Advice for a new journal editor
What is 6÷2×(1+2) =?
Writing a character who is going through a civilizing process without overdoing it?
Why exactly do action photographers need high fps burst cameras?
Who is this Ant Woman character in this image alongside the Wasp?
Why do no American passenger airlines still operate dedicated cargo flights?
Can placing a counter on a creature after it has been assigned as an attacker remove it from combat
Oracle Database is taking too much waiting time
Materialized view taking too much timeUninstalling Oracle Database Products: Which & How to?Oracle Full Client / Database Client package locationsQuery taking very long time in 12C environment, but the same query is taking just a few seconds in 10G production environmentWhy are all sessions used by SYSMAN?Duplicate Oracle Database from .BKP files - getting “multitenant container database not set up properly”Datapump export taking too much time to completeOracle Database Client 12c Product ComponentsHow to enable Oracle Database In-Memory feature in Oracle 11g R2 to reduce report generation time?Insert Into queries take too much time in Apache spark
Yesterday I have found our database was taking too much wait time. It is a single instance Oracle 12c with around 55gb of SGA memory and 12 CPU cores.
On Enterprise Manager, I have found 5 ADDM findings
The daily expdp job is scheduled to run every day at that time and a few SQL and PL/SQL statements were also running and most of them were Oracle's own of the sysman user queries, and most of them are taking more than 5 minutes. There were more than 300+ sessions with the database and most of them were using the Java environment but after a few hours eventually, the database was backed off to the normal state. I haven't understood some of the ADDM analysis. Is there anyone who could help me with that, so that in future I can prevent database from going into the waiting time?
oracle oracle-12c
asked Dec 23 '17 at 16:16
stevesteve
312
bumped to the homepage by Community♦ 6 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 |
Yesterday I have found our database was taking too much wait time. It is a single instance Oracle 12c with around 55gb of SGA memory and 12 CPU cores.
On Enterprise Manager, I have found 5 ADDM findings
The daily expdp job is scheduled to run every day at that time and a few SQL and PL/SQL statements were also running and most of them were Oracle's own of the sysman user queries, and most of them are taking more than 5 minutes. There were more than 300+ sessions with the database and most of them were using the Java environment but after a few hours eventually, the database was backed off to the normal state. I haven't understood some of the ADDM analysis. Is there anyone who could help me with that, so that in future I can prevent database from going into the waiting time?
oracle oracle-12c
asked Dec 23 '17 at 16:16
stevesteve
312
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
From the instance performance screens, what are the specific wait events?
– sandman
Dec 24 '17 at 6:56
Backup jobs and few sql queries
– steve
Dec 24 '17 at 10:23
Steve please say the exact event.
– mohsen.b
Dec 26 '17 at 9:38
add a comment |
Yesterday I have found our database was taking too much wait time. It is a single instance Oracle 12c with around 55gb of SGA memory and 12 CPU cores.
On Enterprise Manager, I have found 5 ADDM findings
The daily expdp job is scheduled to run every day at that time and a few SQL and PL/SQL statements were also running and most of them were Oracle's own of the sysman user queries, and most of them are taking more than 5 minutes. There were more than 300+ sessions with the database and most of them were using the Java environment but after a few hours eventually, the database was backed off to the normal state. I haven't understood some of the ADDM analysis. Is there anyone who could help me with that, so that in future I can prevent database from going into the waiting time?
oracle oracle-12c
asked Dec 23 '17 at 16:16
stevesteve
312
Yesterday I have found our database was taking too much wait time. It is a single instance Oracle 12c with around 55gb of SGA memory and 12 CPU cores.
On Enterprise Manager, I have found 5 ADDM findings
The daily expdp job is scheduled to run every day at that time and a few SQL and PL/SQL statements were also running and most of them were Oracle's own of the sysman user queries, and most of them are taking more than 5 minutes. There were more than 300+ sessions with the database and most of them were using the Java environment but after a few hours eventually, the database was backed off to the normal state. I haven't understood some of the ADDM analysis. Is there anyone who could help me with that, so that in future I can prevent database from going into the waiting time?
oracle oracle-12c
oracle oracle-12c
asked Dec 23 '17 at 16:16
stevesteve
312
asked Dec 23 '17 at 16:16
stevesteve
312
asked Dec 23 '17 at 16:16
stevesteve
312
asked Dec 23 '17 at 16:16
stevesteve
312
asked Dec 23 '17 at 16:16
stevesteve
312
312
bumped to the homepage by Community♦ 6 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♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
From the instance performance screens, what are the specific wait events?
– sandman
Dec 24 '17 at 6:56
Backup jobs and few sql queries
– steve
Dec 24 '17 at 10:23
Steve please say the exact event.
– mohsen.b
Dec 26 '17 at 9:38
add a comment |
From the instance performance screens, what are the specific wait events?
– sandman
Dec 24 '17 at 6:56
Backup jobs and few sql queries
– steve
Dec 24 '17 at 10:23
Steve please say the exact event.
– mohsen.b
Dec 26 '17 at 9:38
From the instance performance screens, what are the specific wait events?
– sandman
Dec 24 '17 at 6:56
From the instance performance screens, what are the specific wait events?
– sandman
Dec 24 '17 at 6:56
Backup jobs and few sql queries
– steve
Dec 24 '17 at 10:23
Backup jobs and few sql queries
– steve
Dec 24 '17 at 10:23
Steve please say the exact event.
– mohsen.b
Dec 26 '17 at 9:38
Steve please say the exact event.
– mohsen.b
Dec 26 '17 at 9:38
add a comment |
1 Answer
1
active
oldest
votes
Try running an AWR report for the time period that the excessive waits exist. The report will let you see the exact wait type and that will help understand the cause. Searching for the cause using the wait name in Oracle support website or even Google is usually helpful.
answered Feb 3 '18 at 17:11
user3924783user3924783
1
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%2f193886%2foracle-database-is-taking-too-much-waiting-time%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
Try running an AWR report for the time period that the excessive waits exist. The report will let you see the exact wait type and that will help understand the cause. Searching for the cause using the wait name in Oracle support website or even Google is usually helpful.
answered Feb 3 '18 at 17:11
user3924783user3924783
1
add a comment |
Try running an AWR report for the time period that the excessive waits exist. The report will let you see the exact wait type and that will help understand the cause. Searching for the cause using the wait name in Oracle support website or even Google is usually helpful.
answered Feb 3 '18 at 17:11
user3924783user3924783
1
add a comment |
Try running an AWR report for the time period that the excessive waits exist. The report will let you see the exact wait type and that will help understand the cause. Searching for the cause using the wait name in Oracle support website or even Google is usually helpful.
answered Feb 3 '18 at 17:11
user3924783user3924783
1
Try running an AWR report for the time period that the excessive waits exist. The report will let you see the exact wait type and that will help understand the cause. Searching for the cause using the wait name in Oracle support website or even Google is usually helpful.
answered Feb 3 '18 at 17:11
user3924783user3924783
1
answered Feb 3 '18 at 17:11
user3924783user3924783
1
answered Feb 3 '18 at 17:11
user3924783user3924783
1
answered Feb 3 '18 at 17:11
user3924783user3924783
1
1
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%2f193886%2foracle-database-is-taking-too-much-waiting-time%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
From the instance performance screens, what are the specific wait events?
– sandman
Dec 24 '17 at 6:56
Backup jobs and few sql queries
– steve
Dec 24 '17 at 10:23
Steve please say the exact event.
– mohsen.b
Dec 26 '17 at 9:38