Oracle DBA by Example. Code samples, Scripts, Reference.

=========== General: =========== Example for Calling stored procedure from bash.  In this case, the stored procedure is using input paramete...

When setting the table to NOLOGGING , what is the expected result? The actual result would depend if database is in ARCHIVE MODE or not, and...

=========== General =========== In short: Stop Cluster unmount    Oracle shared storage Do DBA work remount Oracle shared storage Start Clus...

db_owner Members of the  fixed database role can perform all configuration and maintenance activities on the database, and can also drop the...

USE [master]; GO --Disconnect all existing session. ALTER DATABASE jiradev4 SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO --Change database in ...

Need to copy database from databaseName= dba_util  to  dba_util_test . In SQL Server, several options to do that. Option 1 – Using Backup an...

================== General ================== Bash script that takes 3 parameters, and returns 1 if connection was bad or zero if connection...