Most Oracle DBA & Oracle Apps DBAs are already aware that the technology world is moving fast and that is a fact that no one…
Leave a CommentExpert Oracle Posts
The parallel hint in Oracle Database is used to specify that a particular query or operation should be executed in parallel mode, using multiple parallel…
2 CommentsDepending on the firewall software that is installed on Linux system, to disable the firewall services you will have to work with iptables, ufw (Uncomplicated…
Leave a CommentThe below script can be utilized to find if any UNIX process has a database session linked to it and if yes, provide all the…
Leave a CommentTo change the timezone in Linux, you can use the timedatectl command. You can use the list-timezones option to see a list of all available…
Leave a CommentWhat is Oracle Cloud Infrastructure (OCI) Monitoring service and why is it important? OCI Monitoring is a service that enables you to monitor your cloud…
Leave a CommentHere are a few scripts that can help you find the number of executions of a specific SQL_ID in an Oracle database: Scripts based on…
Leave a CommentIn an Oracle Database, the GC buffer busy acquire wait event occurs when a session tries to acquire a buffer from the buffer cache and…
1 CommentJSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and…
Leave a CommentIostat is a command-line tool that can be used to monitor input/output (I/O) statistics of a Linux system. It can be used to identify I/O…
Leave a Comment