As a PostgreSQL database administrator, you may come across situations
where you want to check the size of the full database, here is a quick solution
for the same
Here is my PostgreSQL cluster details, there is one database called
technodb,...
Snowflake : show databases command optimized
In snowflake, we use the "show databases"
command to see details about default and created databases, this command shows a
lot of details about databases, what if we just need the names of the database
not whole details about them, after digging out I found this
"databases" is table present in INFORMATION_SCHEMA schema, so we can
query the details...
Snowflake : spool output in log file
In almost all databases features, we have a spool file option, we will discuss the same spool option in snowflakeAssume, you need to execute the script which is a little long and the output can not be captured in a single screenshot, so we can make use of spooling the output in the log file. once you are ready to execute the script, browse to...
MongoDB : How to get config file and log file location
In MongoDB configuration files and log files are important files as far as the daily routine for DBA. We may need to check parameters in the configuration and file and errors in log files. So here we will discuss where and how to check the location of these filesConfiguration files (mongod.conf) The below command will help to list different files...
Granting access on dynamic views (ORA-02030: can only select from fixed tables/views)
There were situations
when the application team asks for access to dynamics views such as V$SESSION or
similar dynamic views. Access on V$SESSION is required in
order to monitor sessions from the application end, so this is a common request
Here, we will
discuss, granting access to dynamic views, if you try to grant access to these
dynamic...
PostgreSQL : How to get data directory location for PostgreSQL instance
Sometimes, you start working on a PostgreSQL instance but forget about the data directory, here we will discuss different methods to know the data directory locationThe database parameter related to the data file directory is "data_directory" Method 1: pg_settingsIf you to know the value of any parameter in PostgreSQL, you can query the table...
Oracle SCN : System Change Number

System Change Number
SCN is a number generated in the database on the
occurrence of an event in the database, the event could be
DML statement executionSELECT statement executionDDL statementCommit statement
Whenever this type of transaction...
Snowflake : Undrop database command
Snowflake database has a lot of features and benefits over the
traditional database, one of the features is undrop database, assume you
changed your mind after dropping a database, you can undo it using undrop
database command,
let's see how
exactly it works. this particular feature is based on the time travel feature
of the snowflake, a schema, database...
Snowflake : Using snowsql for snowflake database
A snowflake data warehouse
is the latest addition to the trending database technology, In this article, we
will be discussing snowsql, a command line tool used to access the snowflake
database, there is another way as well to access the database i.e. web-based
portal. still, there are many DBA's who love working on the command line
instead of a web-based...