Benchmarking Oracle 10G on Windows XP

I am not a database administrator. However, I am working on a web application that lives entirely in the Oracle database (yes, it uses PL / SQL procedures to write HTML code for clobes, and then spews clob in your browser. No, that was not mine idea. wait while you cry.).

We are having performance problems, and I was assigned to find the bottlenecks and remove them. How can I evaluate Oracle performance and find these bottlenecks? Our useless system administrator says that Grid Control did not help, and he had to rely on "his experience" and queries on the data dictionary and "v $".

I would like to run some tests against my local Oracle instance and see if I can reproduce the problems he found so that I can make sure that my changes really improve the situation. Can someone please point me towards learning how to do this?

+3
source share
4 answers

Not surprisingly, entire books have been written on this subject.

Indeed, you need to divide and win.

First of all, you just need to ask yourself some standard common sense questions. Example: performance has slowly deteriorated or there has been a significant decrease in productivity recently.

, - - . , .

, , , , . DBMS_OUTPUT.put_lines . SQLNavigator, , .

, , . EXPLAIN_PLAN .

+3

Grid Control , AWR - $ORACLE_HOME/rdbms/admin db. SQL, (, , / , ) , .

AWR , SQL * Plus script - HTML .

+2

:

DBMS_PROFILER, , , . , IDE PL/SQL-, , IDE. , .

http://www.dba-oracle.com/t_dbms_profiler.htm

http://www.databasejournal.com/features/oracle/article.php/2197231/Oracles-DBMSPROFILER-PLSQL-Performance-Tuning.htm


edit 2:

Profiler PL/SQL Developer. .


:

, , , PL/SQL, .

, , Oracle. - . PL/SQL IDE.

PL/SQL Developer Allaround Automations. , PL/SQL , .

, . .:)

+1
source

"I'm working on a web application that lives entirely in an Oracle database (Yes, it uses PL / SQL procedures to write HTML to clobes and then tear clob in your browser"

Is this an Apex product? That the web application environment is now included as a standard part of the Oracle database (although technically it does not spit CLOB).

If so, there is a whole set of tools already built into the product / environment (for example, it stores the current two-week activity history).

0
source

Source: https://habr.com/ru/post/1723670/


All Articles