Dear sir,
i am not able to generate manual snapshot ( AWR ). but automatically every 1 hour snapshot is getting generated. we have enough space in SYSAUX. background processes are running fine for the database. i disabled gather auto stats job and tried manual snapshot, h'ever it takes time and not getting completed. then i have enabled gather stats job now. coudl you please advise on this.
---iam using below commands
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;
Exec dbms_scheduler.disable('GATHER_STATS_JOB');
Exec dbms_scheduler.enable('GATHER_STATS_JOB');
please advise any other thing should i check further ?
] 
Blog
Search
Help
Members
Register
Login
Home
