This note is supplied describing the Oracle Index, its number of rows, leaf blocks and status if it is invalid or valid. For the past couple of days I was thinking how will I know if the query is optimized or not until today I had time to experiment and used SQL Hint on my [...]
More »Here is the SQL statement on how to get the filesize of the Temporary Tablespace in an Oracle datase. select file_name, tablespace_name, bytes/1048576 MB from dba_temp_files; Computation: 1024 Bytes = 1KB
More »
I am Josef Panerio an Oracle Certified Database Administrator and a Pinoy Photographer.
This page is my repository of my recent research related to my Oracle Database career,
Photography and way of life.
With photography, this is my way of expressing my passion in Visual Arts, less privileged to study Fine Arts but I manage express my interest in Computer Studies and linked my passion in Arts with Technology.
