Standard Meaning of "Bounce the Database"

by GWR   Last Updated January 10, 2018 16:06 PM

I have been hearing the term "bounce the database" lately, and researching it, it seems that people take it to mean different things.

Most recently is was an Oracle DBA saying:

"not even the DBAs could access the instance, so we had to bounce the database"

Is there a standard definition?

In the context of Oracle databases, I have seen people use it to refer to a shutdown normal, shutdown immediate, or shutdown abort followed by a restart.

Would it mean the same thing in the context of SQL Server? e.g. stop the service, restart, or kill the service abruptly, restart, etc.

Perhaps in all cases it just means to shutdown and restart a database (or instance?, or server?) and depending on the context, can be achieved in a variety of ways.

Answers 1

It's been consistent for me: bounce generally means restart - Bounce SQL Server = restart the service, normally - Bounce the server = reboot - Bounce the PC = reboot - Bounce IIS = run iisreset

I'd interpret "bounce Oracle" as restart the DB engine processes

January 10, 2018 15:32 PM

Related Questions

Why does Oracle use MINUS instead of EXCEPT?

Updated August 19, 2018 21:06 PM

What is a "partitioned outer join"?

Updated January 14, 2019 10:06 AM

What is a "partitioned view"?

Updated January 27, 2018 23:06 PM

What is a heterogeneous query?

Updated December 19, 2017 23:06 PM