With current 12c and 19c database multitenant databases, we may come across situation where we may need to restart oracle pluggable database. Here we will discuss simple steps to discuss the same.pluggable database technopdb is SQL> show pdbs
CON_ID CON_NAME
OPEN...
12cR2 New Feature -sql prompt "history"
12cR2 has really great features to use in day to day life for dba. Here we will be discussing one such feature i.e. SQL prompt "history". Many dba's use history command on UNIX prompt to analyze the things or events, Before 12c, this option was not there to see history of sql's you have executed but from 12cR2 onward this is very much possible.Lets'...
Physical location of datafiles in PostgreSQL
In this article, we will discuss finding the physical location of data files for a particular database.In the logical structure, we can see different databases and tables or any other objects under it but as DBA we should also be aware of how...
Basic Operations on MySQL Users
In this article we are going to discuss about
different operations on mysql user like lock, unlock, grant, revoke etc.Lock-unlockExpire-unexpiredCheck privilegesRevoke privilegesChange passwordRename user (single user, multiple user)Drop
userUser list can be fetched using query mentioned below in the databaseselect
user,host,authentication_string,password_expired,account_locked...
Oracle : STATISTICS_LEVEL parameter
In Oracle as we gather and view statistics though different views or tables can be controlled by instance level parameter STATISTICS_LEVEL
This particular parameter has below three possible settings
BASIC
TYPICAL
ALL
The parameter controls automatic gathering of statistics at two levels
Instance statistics : statistics accumulate withing...
Transferring file from one server to another server [FTP, SFTP, SCP etc]
There are number of ways to transfer file from one server to another server, below are the few methods to to achieve the same
ftp
sftp
scp
windows software (Filehippo, WinScp , FileZilla etc)
We will discuss these in details
1. FTP transfer
File Transfer Protocols basically is set of rules on computer network to communicate with one another....
MongoDB : Capped Collections
There are two types of collections normal collection and capped collection
In comparison to the normal collection, capped collections are created in advance and are fixed in size
Normal collections are created dynamically and...
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
In previous articles, we have learned about user creation and grants in MySQL in detail, but there are a few privileges called global privileges that are meant to be granted to DBA accounts only
for example
PROCESS privileges is a global privilege.
we will try to grant it to user tech_user on author database
mysql>grant process...