Subject Shutting down while changing metadata
Author Aldo Caruso

Normally, when I make a modificacion to the metadata ( DDL ) I shut
down the database because it is not clear to me what happens if I alter
a table or a stored procedure while it is being used or invoked by
another user.
Is it actually necessary to shut down the database in order to do
metadata changes in a production environment ?

Thanks in advance,
Aldo Caruso