Clota Blog

Author: Abhishek Sharma

  • Memory Grants Pending

    Hello there, everyone! I hope everything is going well for you. Today In this blog I am going to explain you about Memory Grants Pending and How to monitor it. Memory Grants Pending- The number of processes that are pending a workspace memory grant is known as Pending. Because they are unable to acquire adequate RAM while…

    Read More

    Abhishek Sharma

    //

  • Detach and Attach in SQL Server

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you about Detach and Attach Detach SQL Server Database- A SQL Server database is made up of at least two files: a data file (mdf) and a log file (ldf), though there may be additional data files in some circumstances. Since…

    Read More

    Abhishek Sharma

    //

  • PostgreSQL Architecture and Back-end Process

    Hey guys, in this blog I am going to explain to you about PostgreSQL Architecture and Back-end Process. PostgreSQL- PostgreSQL is an open-source general-purpose object-relational database management system that is one of the most advanced. Because it is open-source software, its source code is available under the PostgreSQL license, which is a broad open-source license.…

    Read More

    Abhishek Sharma

    //

  • PostgreSQL DBA Handbook

    How to connect with PostgreSQL- sudo -i -u postgres Grant the necessary privileges for the new user to connect to yourdatabase: Grant connect on database exampledb to user name; Grant usage on schema public to user name; How to Connect with PSQL Shell- Psql How to select version of PostgreSQL and Current Date- Select Version…

    Read More

    Abhishek Sharma

    //

  • Oracle Database User Creation

    Hey guys, in this blog I am going to explain to you about Oracle Database User Creation. USER- User is basically used to connect to database. All Database objects like table, index, view etc. can be created under that user. In Oracle users and schemas are essentially the same thing. You can consider that a user…

    Read More

    Abhishek Sharma

    //

  • Import and Export in Oracle

    Hey guys, in this blog I am going to explain to you about Import and Export in Oracle. Fig.1  On clota-labl08- Step 1- To Check the Process in Oracle like pmon.  [oracle@clota-labl08 ~]$ ps -ef | grep -i pmon oracle      2207       1  0 Sep26 ?        00:00:05 ora_pmon_clotaDB oracle     43671   37353  0 04:47 pts/4    00:00:00 grep –color=auto -i pmon Step 2 – To Set the Environment…

    Read More

    Abhishek Sharma

    //

  • Blocking Session in Oracle

    Hey guys, in this blog I am going to explain to you about Blocking Session in Oracle. Blocking Session- A blocking session in Oracle Database is one where one session is impeding the progress of another session. When one session has a lock on a resource that another session is attempting to access, this can…

    Read More

    Abhishek Sharma

    //

  • Oracle Connectivity and Networking

    Hey guys, in this blog I am going to explain to you about Oracle Connectivity and Networking. Oracle Connectivity and Networking- Oracle Connectivity and Networking in Oracle Database 19c refers to the set of features and technologies that enable communication between various Oracle Database system components, such as clients, servers, and other database-related elements. In…

    Read More

    Abhishek Sharma

    //

  • Oracle Tablespace

    Hey guys, in this blog I am going to explain to you about Oracle Tablespace. Oracle Tablespace: –  An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database’s data.  A table space is a storage structure; it contains tables, indexes, large objects, and long data.  Type of…

    Read More

    Abhishek Sharma

    //

Search

Categories

Recent Posts