select profile from dba_users where username ='xxxx';
alter profile default limit passsword_life_time unlimited;
alter profile default limit failed_login_attempts unlimited;
select resource_name,limit from dba_profiles where profile='' ;
select resource_name,limit from dba_profiles where profile='' ;
First Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...
No comments:
Post a Comment