How to check object owner in Oracle DB
Just a quick note on how to check object owner in Oracle database. Following query can be used: Note that it requires access to ALL_OBJECTS view which is normally requires DBA rights.
Oracle
SQL query to check table size in Oracle database
In order to check size of table in Oracle database you may use following query: View the code on Gist.
Review: Oracle 12c For Dummies (For Dummies
Oracle 12c For Dummies (For Dummies by Chris Ruel\nMy rating: 4 of 5 stars For Dummies series does amazing job in explaining everything in plain language without dramatic loss of depth or excessive oversimplification. They are very good to get you started with the subject.\nMy first tech book long time ago was Networking for Dummies … Review: Oracle 12c For Dummies (For Dummies
How to: get Oracle database files location via PL/SQL query
You may use following query to get names and locations of database files: \n\n SELECT file_name,tablespace_name,bytes,blocks FROM dba_data_files ORDER BY tablespace_name,file_name Example of output you get:
How to check Oracle version via SQL query
You may use following query to check Oracle version: SELECT * FROM product_component_version Or this one: SELECT * FROM v$version Both will return Oracle version information.