How to prevent high memory usage for Oracle RDBMS Kernel Executable?
I had set up Oracle DB 12c to my computer a few days ago and it slowed my computer down badly. I noticed that is causing high memory usage today. This usage stems from Oracle RDBMS Kernel Executable as you see in the picture. What can I do for this?
EDIT:
I tried to restarting the service which is called OracleServiceTEST but it didn't give a solution.
windows-8.1 database memory-leaks oracle-12c
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
|
show 9 more comments
I had set up Oracle DB 12c to my computer a few days ago and it slowed my computer down badly. I noticed that is causing high memory usage today. This usage stems from Oracle RDBMS Kernel Executable as you see in the picture. What can I do for this?
EDIT:
I tried to restarting the service which is called OracleServiceTEST but it didn't give a solution.
windows-8.1 database memory-leaks oracle-12c
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
1
How have you identified this is a leak & not simply high but valid memory usage?
– Tetsujin
Mar 6 '17 at 19:06
@Tetsujin We set it up to different computers. It didn't affect them as in this computer. I am not sure but it seems like leak in this computer.
– NoWeDoR
Mar 6 '17 at 19:10
1
It's only a memory leak if it's not actually doing something valid with the memory. As it's also creating disk usage (see the 0.1mb/s) it seems it maybe actually running a query (abet slowly)?
– djsmiley2k
Mar 6 '17 at 19:29
@djsmiley2k I didn't write any code, or query?
– NoWeDoR
Mar 6 '17 at 19:34
You still have not specifically indicated how you determined there was a memory leak. If there was a memory leak in the version you were using, it would affect all your instances of that version, instead of just a single instance. A memory leak is a programming error, what you describe, is simply high memory usage.
– Ramhound
Mar 6 '17 at 20:35
|
show 9 more comments
I had set up Oracle DB 12c to my computer a few days ago and it slowed my computer down badly. I noticed that is causing high memory usage today. This usage stems from Oracle RDBMS Kernel Executable as you see in the picture. What can I do for this?
EDIT:
I tried to restarting the service which is called OracleServiceTEST but it didn't give a solution.
windows-8.1 database memory-leaks oracle-12c
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
I had set up Oracle DB 12c to my computer a few days ago and it slowed my computer down badly. I noticed that is causing high memory usage today. This usage stems from Oracle RDBMS Kernel Executable as you see in the picture. What can I do for this?
EDIT:
I tried to restarting the service which is called OracleServiceTEST but it didn't give a solution.
windows-8.1 database memory-leaks oracle-12c
windows-8.1 database memory-leaks oracle-12c
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
edited Mar 6 '17 at 22:03
NoWeDoR
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
asked Mar 6 '17 at 19:04
NoWeDoRNoWeDoR
1113
1113
1
How have you identified this is a leak & not simply high but valid memory usage?
– Tetsujin
Mar 6 '17 at 19:06
@Tetsujin We set it up to different computers. It didn't affect them as in this computer. I am not sure but it seems like leak in this computer.
– NoWeDoR
Mar 6 '17 at 19:10
1
It's only a memory leak if it's not actually doing something valid with the memory. As it's also creating disk usage (see the 0.1mb/s) it seems it maybe actually running a query (abet slowly)?
– djsmiley2k
Mar 6 '17 at 19:29
@djsmiley2k I didn't write any code, or query?
– NoWeDoR
Mar 6 '17 at 19:34
You still have not specifically indicated how you determined there was a memory leak. If there was a memory leak in the version you were using, it would affect all your instances of that version, instead of just a single instance. A memory leak is a programming error, what you describe, is simply high memory usage.
– Ramhound
Mar 6 '17 at 20:35
|
show 9 more comments
1
How have you identified this is a leak & not simply high but valid memory usage?
– Tetsujin
Mar 6 '17 at 19:06
@Tetsujin We set it up to different computers. It didn't affect them as in this computer. I am not sure but it seems like leak in this computer.
– NoWeDoR
Mar 6 '17 at 19:10
1
It's only a memory leak if it's not actually doing something valid with the memory. As it's also creating disk usage (see the 0.1mb/s) it seems it maybe actually running a query (abet slowly)?
– djsmiley2k
Mar 6 '17 at 19:29
@djsmiley2k I didn't write any code, or query?
– NoWeDoR
Mar 6 '17 at 19:34
You still have not specifically indicated how you determined there was a memory leak. If there was a memory leak in the version you were using, it would affect all your instances of that version, instead of just a single instance. A memory leak is a programming error, what you describe, is simply high memory usage.
– Ramhound
Mar 6 '17 at 20:35
1
1
How have you identified this is a leak & not simply high but valid memory usage?
– Tetsujin
Mar 6 '17 at 19:06
How have you identified this is a leak & not simply high but valid memory usage?
– Tetsujin
Mar 6 '17 at 19:06
@Tetsujin We set it up to different computers. It didn't affect them as in this computer. I am not sure but it seems like leak in this computer.
– NoWeDoR
Mar 6 '17 at 19:10
@Tetsujin We set it up to different computers. It didn't affect them as in this computer. I am not sure but it seems like leak in this computer.
– NoWeDoR
Mar 6 '17 at 19:10
1
1
It's only a memory leak if it's not actually doing something valid with the memory. As it's also creating disk usage (see the 0.1mb/s) it seems it maybe actually running a query (abet slowly)?
– djsmiley2k
Mar 6 '17 at 19:29
It's only a memory leak if it's not actually doing something valid with the memory. As it's also creating disk usage (see the 0.1mb/s) it seems it maybe actually running a query (abet slowly)?
– djsmiley2k
Mar 6 '17 at 19:29
@djsmiley2k I didn't write any code, or query?
– NoWeDoR
Mar 6 '17 at 19:34
@djsmiley2k I didn't write any code, or query?
– NoWeDoR
Mar 6 '17 at 19:34
You still have not specifically indicated how you determined there was a memory leak. If there was a memory leak in the version you were using, it would affect all your instances of that version, instead of just a single instance. A memory leak is a programming error, what you describe, is simply high memory usage.
– Ramhound
Mar 6 '17 at 20:35
You still have not specifically indicated how you determined there was a memory leak. If there was a memory leak in the version you were using, it would affect all your instances of that version, instead of just a single instance. A memory leak is a programming error, what you describe, is simply high memory usage.
– Ramhound
Mar 6 '17 at 20:35
|
show 9 more comments
1 Answer
1
active
oldest
votes
back up the data in DBS folder of your oracle home. Then run the following commands when connected as sys as sysdba.
Show parameter sga; -
you will see the size will be around 2.5G change it to desired numbers.
Below is an example:
Alter system set sga_max_size=1200M scope=spfile;
alter system set sga_target = 800M scope=spfile;
Shut immediate
Startup
Then check for show parameter sga and you will see new values .
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1185869%2fhow-to-prevent-high-memory-usage-for-oracle-rdbms-kernel-executable%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
back up the data in DBS folder of your oracle home. Then run the following commands when connected as sys as sysdba.
Show parameter sga; -
you will see the size will be around 2.5G change it to desired numbers.
Below is an example:
Alter system set sga_max_size=1200M scope=spfile;
alter system set sga_target = 800M scope=spfile;
Shut immediate
Startup
Then check for show parameter sga and you will see new values .
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
add a comment |
back up the data in DBS folder of your oracle home. Then run the following commands when connected as sys as sysdba.
Show parameter sga; -
you will see the size will be around 2.5G change it to desired numbers.
Below is an example:
Alter system set sga_max_size=1200M scope=spfile;
alter system set sga_target = 800M scope=spfile;
Shut immediate
Startup
Then check for show parameter sga and you will see new values .
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
add a comment |
back up the data in DBS folder of your oracle home. Then run the following commands when connected as sys as sysdba.
Show parameter sga; -
you will see the size will be around 2.5G change it to desired numbers.
Below is an example:
Alter system set sga_max_size=1200M scope=spfile;
alter system set sga_target = 800M scope=spfile;
Shut immediate
Startup
Then check for show parameter sga and you will see new values .
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
back up the data in DBS folder of your oracle home. Then run the following commands when connected as sys as sysdba.
Show parameter sga; -
you will see the size will be around 2.5G change it to desired numbers.
Below is an example:
Alter system set sga_max_size=1200M scope=spfile;
alter system set sga_target = 800M scope=spfile;
Shut immediate
Startup
Then check for show parameter sga and you will see new values .
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
edited Jun 9 '17 at 9:38
styrofoam fly
9762917
9762917
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
answered Jun 9 '17 at 5:21
Nikhil ReddyNikhil Reddy
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1185869%2fhow-to-prevent-high-memory-usage-for-oracle-rdbms-kernel-executable%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
1
How have you identified this is a leak & not simply high but valid memory usage?
– Tetsujin
Mar 6 '17 at 19:06
@Tetsujin We set it up to different computers. It didn't affect them as in this computer. I am not sure but it seems like leak in this computer.
– NoWeDoR
Mar 6 '17 at 19:10
1
It's only a memory leak if it's not actually doing something valid with the memory. As it's also creating disk usage (see the 0.1mb/s) it seems it maybe actually running a query (abet slowly)?
– djsmiley2k
Mar 6 '17 at 19:29
@djsmiley2k I didn't write any code, or query?
– NoWeDoR
Mar 6 '17 at 19:34
You still have not specifically indicated how you determined there was a memory leak. If there was a memory leak in the version you were using, it would affect all your instances of that version, instead of just a single instance. A memory leak is a programming error, what you describe, is simply high memory usage.
– Ramhound
Mar 6 '17 at 20:35