• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

admin

Table Vs. Materialized View

by admin

What are Materialized Views Oracle Materialized Views or MVs are a good option for data warehousing and replication. MVs based on inner/outer equijoin can be refreshed on-demand or periodically if desired. MVs that are based on sub-queries on remote tables support bi-directional replication. An MV includes a query that is transparent to the user, and […]

Filed Under: oracle

What are Local and Global Indexes in Oracle Database

by admin

Background information In a local index, all keys in a particular index partition refer only to rows stored in a single underlying table partition. A local index is created by specifying the LOCAL attribute. In a global partitioned index, the keys in a particular index partition may refer to rows stored in multiple underlying table […]

Filed Under: oracle

WITH Clause in ORACLE

by admin

As per Oracle Documentation, the WITH query_name clause lets you assign a name to a subquery block. You can then reference the subquery block multiple places in the query by specifying the query name. Oracle Database optimizes the query by treating the query name as either an inline view or as a temporary table. You […]

Filed Under: oracle

What is the difference between PRIMARY Key and UNIQUE Key

by admin

The primary key is used to ensure that all values in a column are not null and unique. This key combines the unique and not null constraint properties into one key. This type of key can be applied to any data type and is used to avoid missing and duplicate data. You can only have […]

Filed Under: oracle, PL/SQL

Oracle OS watcher (OSWatcher) – Understanding oswmpstat

by admin

Oracle provides a collection of scripts that gather and store metrics for CPU, memory, disk, and network usage. The OSWatcher tool suite automates the gathering of statistics using tools such as top, vmstat, iostat, mpstat, netstat, and traceroute. The general file format for the oswmpstat data is: [node_name]_mpstat_YY.MM.DD:HH24.dat These files will contain output from the […]

Filed Under: Linux, oracle

Oracle OS watcher (OSWatcher) – Understanding oswiostat

by admin

Oracle provides a collection of scripts that gather and store metrics for CPU, memory, disk, and network usage. The OSWatcher tool suite automates the gathering of statistics using tools such as top, vmstat, iostat, mpstat, netstat, and traceroute. The general file format for the oswiostat data is: [node_name]_iostat_YY.MM.DD:HH24.dat These files will contain output from the […]

Filed Under: Linux, oracle

How to Start and Stop OSWatcher

by admin

OSWatcher (oswbb) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support in diagnosing performance issues. As a best practice, all customers should install and run OSWatcher on every node that has a running Oracle instance. In the case of a performance issue, Oracle support […]

Filed Under: Linux, oracle

iotop Command Examples in Linux

by admin

To get a live view of the input and output, or short I/O, bandwidth usage of your system, type iotop. iotop needs to be started with the root user. You can use iotop, for example, to learn how fast your hard disk can read and write, then press the q key to exit. Please read […]

Filed Under: Linux

Basic Commands to Troubleshoot Performance Issues in Linux

by admin

Following is the list of OS commands apart from basic commands that are useful in diagnosing the problems at OS end causing the slow performance. Please note that all the commands mentioned above are tested in a Linux environment only. If you are ready to track down your performance problems, here are some tools to […]

Filed Under: Linux

How to Determine Which Process is Writing to Disk in Linux

by admin

It’s also possible on Linux to get per process I/O statistics, so you can see exactly who is reading and writing heavily, using a program named iotop. iotop needs to be started with the root user. You can use iotop, for example, to learn how fast your hard disk can read and write, then press […]

Filed Under: Linux

« Previous Page
Next Page »

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright