Nuovo-Logo-ScriptDBA.com
  • Home
  • About
    • Our Story
    • Resume
  • How to
    • SQL Query In the SQL Query category, you will find numerous queries useful for administering the Oracle database. A SQL Structure Query Language query is a query to a database through SQL code, which is a standard language used to retrieve and manage information from relational databases. Oracle is an RDBMS Relational Database Management System or a DBMS Data Base Management System based on the relational model. This allows you to retrieve data from multiple tables by relating them to each other in order to have the result in a single output. A query consists of a code structure consisting of 2 phases: selection and origin. SELECT * FROM all_users; The third phase follows, which is the condition. We apply a filter to the queries to limit the rows to be recovered: SELECT * FROM all_users WHERE username = ‘ALEX’; This is a simple query that allows us to retrieve the information recorded in the all_users table relating to the ALEX user. On the Foundations of Oracle course, the SQL language in all its forms will be illustrated in detail.
      • Oracle sessions management
        • Oracle SID session query
        • Oracle User Sessions Query
        • Query Oracle sessions to date and time
        • Query to see the RMAN sessions
        • Query Oracle sessions processes transactions cursors
        • Query sessions holding LOCK
        • Query Oracle LOCK and number of LOCKED sessions
        • Query to Identify Sessions Blocked by Another Session
        • KILL Oracle USER sessions on RAC
        • KILL Oracle USER sessions
        • Query disconnect session Oracle
      • Oracle performance statement analysis
        • Query to extract the statement from SQL_ID
        • Query to extract statement from a subsequent SQL_ID EXPLAIN PLAN FOR the statement
      • ASM space management
        • Query to View ASM DiskGroup Spaces
        • ASM LUN CANDIDATE Query
        • Query to view the remaining time of REBALANCE
      • Tablespace management
        • Query size datafiles of a tablespace
        • Query to see the size of all Oracle TABLESPACE
        • Query to retrieve disk space allocated by DATAFILES but not used
        • Query to View TEMPFILE and TEMP TABLESPACE Sizes
        • Query to retrieve disk space allocated by DATAFILES but not used
      • Oracle object management
        • Oracle Objects Query
        • Query for INVALID Objects
        • Query for Compiling INVALID Objects
      • Oracle database Management of LOB objects
        • Oracle Table LOB Query
        • LOB Segment Oracle Query
      • Oracle INDEX management
        • Index Size Query
        • Partitioned Indexes Oracle Query
        • UNUSABLE Indexes Query in Oracle
        • UNUSABLE Partitioned Indexes Query in Oracle
        • Dynamic Query for Generating REBUILD INDEX Command
      • EXTENT management of an Oracle object
        • Query EXTENT Oracle number and size
        • Query EXTENT TABLE Oracle
        • Query Oracle objects with few EXTENTS
      • Users management
        • Query for Oracle User Password Status
        • Query for Oracle User Roles
        • Query for Oracle User Object Privileges
        • DDL for User Creation Roles and Privileges
        • Assignment of DEFAULT_TABLESPACE Quota
        • Query USER PRIVILEGES replicated
      • REDO LOG management
        • Query REDO LOG file name and status
        • Query REDO LOG Switch Count
      • DDL extract Oracle objects
        • DDL Objects in ORACLE
      • Oracle JOBS management
        • Query JOB Oracle status
        • Query JOB Running
        • DBMS_IJOB BROKEN
        • dbms_ijob remove JOB Oracle
        • DBMS_IJOB BROKEN FALSE
    • Comandi CRS
      • CRSCTL commands – CRS Oracle
        • CRS stop
        • CRS start
        • CRS STOP ALL: Complete shutdown of all CRS cluster resources
        • CRS START ALL: Complete startup of all CRS cluster resources
        • Disable CRS
        • Enable CRS
      • SRVCTL commands – CRS Oracle
        • srvctl stop database
        • srvctl start database
        • srvctl stop instance
        • srvctl start instance
        • srvctl stop listener
        • srvctl stop service
        • srvctl start service
        • srvctl relocate service
    • Tutorial Work in progres.
      • Linux