1 If server is using spfile . then how can I edit change in pfile - TopicsExpress



          

1 If server is using spfile . then how can I edit change in pfile . please brief the steps .most important when to shutdown . 2 What happens when I execute the following in unix : kill -9 smon and kill -9 pmon . Will kill -9 pmon kills all the sessions ? and will leave the background processes . 3.What happens if we kill all sessions including background processes . will system crash ? 4. How to avoid deadlocks . That deadlocks never happen . I know that we should have commit after ddl but on database side perspective what should be checked and implemented ? Whats role of ddl_locktimeout. Thanks
Posted on: Sun, 29 Jun 2014 22:26:37 +0000

Trending Topics



Recently Viewed Topics




© 2015