Clota Blog

Category: Oracle

  • About Us

    At CLOTA Technology, we provide innovative solutions in database technologies, web development, cloud maintenance, and software support to help businesses achieve their goals. Our services include expert SQL and NoSQL database design, implementation, and maintenance with certified DBAs boasting 15+ years of experience. We specialize in custom website and app creation, cloud services for migrations,…

  • Table Space addition in Oracle Database

    Default location for Oracle-managed datafiles: show parameter db_create_file_dest; Displays Space Usage for Each Datafile Set lines 999 pages 100 select a.tablespace_name, trunc(SUM(a.bytes)/1024/1024/1024,2) “CurGb”, trunc(SUM(decode(b.maxextend, null, A.BYTES/1024/1024/1024, b.maxextend*8192/1024/1024/1024)),2) “MaxGb”, trunc((SUM(a.bytes)/1024/1024/1024 – round(c.”Free”/1024/1024/1024)),2) “TotalUsedGb”, trunc((SUM(decode(b.maxextend, null, A.BYTES/1024/1024/1024, b.maxextend*8192/1024/1024/1024)) – (SUM(a.bytes)/1024/1024/1024 – round(c.”Free”/1024/1024/1024))),2) “TotalFreeGb”, round(100*(SUM(a.bytes)/1024/1024 – round(c.”Free”/1024/1024))/(SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)))) “UPercent” from dba_data_files a, sys.filext$ b, (SELECT d.tablespace_name…

  • Restore Point Creation in Oracle

    Connect to the DB > sqlplus / as sysdba > show pdbs Connect to the PDB > alter session set container=pdb_name; > create restore point RP_Name guarantee flashback database; Check RP creation status select NAME,TIME,GUARANTEE_FLASHBACK_DATABASE,storage_size/1024/1024/1024 from v$restore_point;

  • Win OS Related Quick Commands

     Find Who Restarted Windows Server –Run the following command to filter the System Logs with Source as User32. Get-EventLog -LogName System | Where Source -eq User32 –You may also filter the system logs with Event ID 1074 with the following command. Get-EventLog -LogName System | Where EventID -eq 1074

  • 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…

  • 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…

  • 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…

  • 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…

  • 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…