No one should be authorized at server level on instance except DBAs. In some cases, as an exception, you may be granted some users …

  You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from …

  If Goldengate doesn’t start with errors like this, the solution is very easy. Possible errors: Not enough database memory to honor requested MAX_SGA_SIZE of …

  With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates …

One of the information I needed most is the file version. You can learn this in unix systems with the following command. [crayon-6741172d3f1aa450847007/]

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on …

  First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. …

  You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users. You can create …

Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test …