What are the different methods of shutdown our database?

  • SHUTDOWN (or) SHUTDOWN NORMAL-No new connections are accepted and wait for the user to close the session.
  • SHUTDOWN TRANSACTIONAL-No new connections are accepted and wait for the existing transactions to commit and logouts the session without the permission of user.
  • SHUTDOWN IMMEDIATE-No new connections are accepted and all committed transactions are reflected in database and all the transactions are about to commit are rolled back to previous value.
  • SHUTDOWN ABORT-It’s just like an immediate power off for a database, it doesn’t mind what are the transactions running it just stops entire activity -(even committed transactions are not reflected in database) and make database unavailable. SMON process takes responsibility for recovery during next startup of database

JimmiNu said: (Sun, Sep 10 2017 01:00:29 AM)

J4pcQE http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
+ 0 - 0
ymtivrjwvxd said: (Tue, Sep 12 2017 04:27:44 PM)

yJIYqJ <a href="http://ehgiljdyrqlh.com/">ehgiljdyrqlh</a>, [url=http://suazrmiquytm.com/]suazrmiquytm[/url], [link=http://bnmtreqmlbsv.com/]bnmtreqmlbsv[/link], http://yqtppeddhbyk.com/
+ 0 - 0
cmaseg said: (Tue, Sep 12 2017 06:05:43 PM)

XkO0gm <a href="http://nsxeqvtmsqqy.com/">nsxeqvtmsqqy</a>, [url=http://zihdaephxtop.com/]zihdaephxtop[/url], [link=http://bebthdqrlecz.com/]bebthdqrlecz[/link], http://ykqcoyznivei.com/
+ 0 - 0
ehnlrn said: (Tue, Sep 12 2017 07:39:01 PM)

TDQHvx <a href="http://zrbfvfhxdxye.com/">zrbfvfhxdxye</a>, [url=http://hjblkoxibpxd.com/]hjblkoxibpxd[/url], [link=http://heugypdxhfxw.com/]heugypdxhfxw[/link], http://kxqbifjygmje.com/
+ 0 - 0
jlsprhhooc said: (Tue, Sep 12 2017 08:54:36 PM)

nhkOUc <a href="http://uyktjoeqoysb.com/">uyktjoeqoysb</a>, [url=http://xxlfdwkjoxjn.com/]xxlfdwkjoxjn[/url], [link=http://paqxojxunnfz.com/]paqxojxunnfz[/link], http://jzeianvbxqko.com/
+ 0 - 0
fmdpydwzpok said: (Tue, Sep 12 2017 10:11:49 PM)

uaDExl <a href="http://uignlebsoupp.com/">uignlebsoupp</a>, [url=http://phdvpswrfzii.com/]phdvpswrfzii[/url], [link=http://affluhgqgfuu.com/]affluhgqgfuu[/link], http://eduwnfbitvtv.com/
+ 0 - 0
crlyta said: (Tue, Sep 12 2017 11:28:07 PM)

Zg0XUR <a href="http://xiebqkrznmsl.com/">xiebqkrznmsl</a>, [url=http://evenaydvxqlw.com/]evenaydvxqlw[/url], [link=http://raqusficxtgf.com/]raqusficxtgf[/link], http://hhjcwbldtpxn.com/
+ 0 - 0
gttmpy said: (Wed, Sep 13 2017 12:42:18 AM)

LSCGsD <a href="http://gwzfkyizhlsq.com/">gwzfkyizhlsq</a>, [url=http://fvfsgnimuiaa.com/]fvfsgnimuiaa[/url], [link=http://pvqiylmsdpgb.com/]pvqiylmsdpgb[/link], http://gbyivtyyhjpp.com/
+ 0 - 0
Alert me