You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from …
Read More »“Not enough database memory” On GoldenGate
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 …
Read More »How To Find Last Backup Dates Of SQL Server Databases
With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates …
Read More »How To Find the Version of the File In Unix Systems(pls, form, report etc.)
One of the information I needed most is the file version. You can learn this in unix systems with the following command. [crayon-6769c48f5b179487303914/]
Read More »Policy-Based Management(Check AutoGrowth Of Database Files-Data File Facet)
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 …
Read More »How To View the Execution Plan of the Query On Oracle
If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on …
Read More »How To Change The Collation Of SQL Server Database, Tables Of Database and Columns Of Tables
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. …
Read More »How to get the network packets between MySQL client and server?
Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the …
Read More »Who is Running the Queries in Your Database On Oracle
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 …
Read More »How To Change SQL Instance/Server Name ANS @@SERVERNAME Function
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 …
Read More »