set linesize 100
set pagesize 100
SELECT * FROM
(SELECT substr(sql_text,1,40) sql,
executions, rows_processed, rows_processed/executions "Rows/Exec",
hash_value,address
FROM V$SQLAREA
WHERE executions > 100
ORDER BY executions DESC)
WHERE rownum <=10
;
Archive for the ‘Performance’ Category
Query for Top 10 by Executions:
Posted by Sriram Sanka on September 13, 2022
Posted in Performance, sql | Tagged: oracle, sql | Leave a Comment »
Query for Top 10 by Physical Reads:
Posted by Sriram Sanka on September 13, 2022
set linesize 100
set pagesize 100
SELECT * FROM
(SELECT substr(sql_text,1,40) sql,
disk_reads, executions, disk_reads/executions "Reads/Exec",
hash_value,address
FROM V$SQLAREA
WHERE disk_reads > 1000
ORDER BY disk_reads DESC)
WHERE rownum <=10
;
Posted in Performance, sql | Tagged: Performance, Physical reads, sql | Leave a Comment »
MySQL Load Data Statement – Performance
Posted by Sriram Sanka on December 10, 2021
As mentioned in the MySQL Documentation here https://dev.mysql.com/doc/refman/8.0/en/load-data.html ,
The
LOAD DATAstatement reads rows from a text file into a table at a very high speed. The file can be read from the server host or the client host, depending on whether theLOCALmodifier is given.LOCALalso affects data interpretation and error handling.
Lets Run a Quick Test !
Loading Data Into a Table in the local Database using MySQL workbench Executed around 35Min (2098.781 Sec) for 35K records.
Now Lets Truncate the Table and re-load the data using LOAD DATA Statement
BOOM ! Job Done within 2 Sec.
Posted in LoadTest, MySql, Performance | Leave a Comment »
Sriram Sanka - My Experiences with Databases & More 