eXhydra
8 FOLLOWERS
Generic technologic posts from a motivated real life DBA to inspire the real life DBA. This blog provides fast tips and workarounds for issues due to technological errors and mainly focus on Oracle articles filled with emotions.
eXhydra
1M ago
Always in linux, update the epel repository to the system current release to get the stress package. Install stress stresslessly using yum ..read more
eXhydra
1M ago
Executing a DDL statement during peak hour of the database queues the sessions until the DML gets completed. So in order to wait in the queue without nowait clause, a parameter ddl_lock_timeout initiates a exclusive DDL lock request on the object until the DML commit the transaction. If it is normal DDL without nowait, then ..read more
eXhydra
1M ago
To Find all the sql command type executing on the database. Any query can be monitored with this query which is universal to all the type of commands. For example, to monitor ‘index rebuild’ the below predicate can be used ..read more
eXhydra
1M ago
eXhydra
1M ago
There are SQL statements which has plan hash value as 0 and that cause some confusions. When those sql are further analyzed, the sql statements are mostly procedures,packages and internal dictionary SQL ..read more
eXhydra
2M ago
There are 3 system databases by default in MongoDB which are used for administration purpose. They are Admin database contains only one collection which is related to version of mongodb. Local database contains the startup log of the database.`> use localswitched to db local> show collectionsstartup_log> db.startup_log.find(){ “_id” : “exhydra-VirtualBox-1668693929960”, “hostname” : “exhydra-VirtualBox”, “startTime ..read more