Forum Stats

  • 3,824,946 Users
  • 2,260,442 Discussions
  • 7,896,356 Comments

Discussions

Command to start the MMON process

Luís Gustavo Lira
Luís Gustavo Lira Member Posts: 119 Silver Badge
edited Sep 14, 2020 9:33PM in Database Ideas - Ideas

One of the functions of the MMON process is to perform tasks like taking AWR snapshots, but sometime MMON process just crash (for any reason) and when you need it most you realize that snapshots are not being generated.

A possible workaround to start MMON without unavailability would be:

1- Grant restricted session to public

2- Enable restricted sessions

3- Disable restricted sessions

4- Revoke the restricted session from public

I understand that it would be more practical if there was a specific command to start MMON.

Luís Gustavo Lira
1 votes

Active · Last Updated