Toggle Navigation
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