First check table space quota for all user or for specific user using sql query. DBA_TS_QUOTAS describes tablespace quotas for all users.USER_TS_QUOTAS describes tablespace quotas for the current user. select * from…
Here are five ways to reduce fetch time of our sql queries. 1 - If you have access to check the execution plan of you query then check which part…
The error is because of the new version of the mongoose i.e version 6.0.6. useNewUrlParser, useUnifiedTopology, useFindAndModify, and useCreateIndex are no longer supported options. Mongoose 6 always behaves as if useNewUrlParser, useUnifiedTopology, and useCreateIndex are true, and useFindAndModify is false. Please remove…
While working on any project where we may have a requirement to check the size of an array or to get an element whose size is greater or less than…
Some time while performing any operation on user like updating user, dropping user or granting or revoking access, we face error like user not found for particular db. Few thing…
dropdb destroys an existing PostgreSQL database. The user who executes this command must be a database superuser or the owner of the database. dropdb is a wrapper around the SQL command DROP DATABASE. There is no effective…
In the Postgres command line, it always prompts a password if the password is not set. We can avoid this in the following way. Before running any Postgres command-line command…
Many time we want run query with in query to get desirable result. MongoDB provide a aggregation operator to achieve result like this. Lets assume we have a collection with…
