Home » RDBMS Server » Performance Tuning » query output speed very slow (oracle 12c, windows)
query output speed very slow [message #689447] Sun, 31 December 2023 02:14 Go to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear Experts,
When we run the Oracle reports or query in toad, query fetch speed is very slow, we have increase RAM of windows server where oracle DB installed, but still performance still the same, it's too slow to process the DML Queries especially SELECT statement,
Somebody can help pls. how to resolve slowness issue?

Thankful,

Re: query output speed very slow [message #689448 is a reply to message #689447] Sun, 31 December 2023 02:46 Go to previous message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

For any SQL performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.

You can also read:
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

Previous Topic: SQL Profiles after upgrade from 11g to 19c
Next Topic: Table Statistics Keep Getting Stale
Goto Forum:
  


Current Time: Tue Apr 16 15:39:48 CDT 2024