Cell services automatically start when the cell is started. You can follow the following procedures to start and stop manually. “CELLSRV, MS and RS” services …
Read More »dbtut
How To Calcutale Database Transaction Count in SQL Server
Transaction count shows that how heavily the database is used. Some third-party applications can show the transaction count graphs of the databases. But each …
Read More »How To Reset Rman Configurations
It is possible to reset Rman configurations to default values. You can see “#default” at the end of the unmodified configurations. It is possible …
Read More »How To Create a Server Level Role in SQL Server
Before reading this article, I suggest you read my article “Fixed Server Level Role in SQL Server“. Apart from the default roles on Instance, …
Read More »ORA-39014, ORA-39029, ORA-31671 and ORA-00600 errors in 12c expdp/impdp operations
In the 12c databases, ORA-39014 ORA-39029 ORA-31671 and ORA-00600 errors can be received during expdp or impdp operation. In such a case, existing processes …
Read More »Fixed Server Level Roles in SQL Server
These roles are the default server level roles at the instance level. You can find the brief description about these roles below. sysadmin sysadmins …
Read More »CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)
In SQL Server, we can join two tables with JOIN operators. You can read the “Join Types in SQL Server” article. With the CROSS …
Read More »ORA-01105 error in alter system flush redo operation
The “alter system flush redo” command, which is used to transfer operations in the redo log files in the primary database to the standby …
Read More »How To Limit a User’s Resource Usage Using Resource Governor
Resource Governor announced with SQL Server 2008. We are able to limit resources of a session using Resource Governor. For example, a report user …
Read More »How To Get an Existing Oracle User’s Create Script
In this article, I will tell you to get the create script of an oracle user. First, we will create a file named user.sql that …
Read More »