How To Know If DB Is Loaded Using AWR

Sep 14, 2011

problem is: Our HFM application is running very slow, but we don't know where the bottleneck is. I would like to prove that the DB is not the one causing the issue.

solution: Show AWR metrics that indicate that utilization of the DB

I've been reading thru a lot of articles in the net (Oracle sites and others), but I cannot find a clear AWR baseline that will tell me if my database is heavily loaded. how much of my DB capacity am I using in a said time period. The different OEM graphs show: During non-peak: DB is relatively Idle Peak time: the graph suggest we are just using 30-40% of max capacity. This is when a dataload into the DB happens

So, is my DB loaded if my AWR Load Profile stats are:

CODELoad Profile              Per Second    Per Transaction   Per Exec   Per Call
~~~~~~~~~~~~         ---------------    --------------- ---------- ----------
DB Time(s):                1.0                0.3       0.00       0.00
DB CPU(s):                0.8                0.3       0.00       0.00
Redo size:          408,893.4          125,411.1
Logical reads:            5,606.3            1,719.5
Block changes:            2,119.2              650.0
Physical reads:              455.9              139.8
Physical writes:               83.0               25.5
User calls:              469.4              144.0
Parses:               82.4               25.3
Hard parses:               44.5               13.7
W/A MB processed:        2,383,203.7          730,949.0
Logons:                0.2                0.1
Executes:              345.9              106.1
Rollbacks:                0.0                0.0
Transactions:                3.3

CODETop 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                                                           Avg
                                                          wait   % DB
Event                                 Waits     Time(s)   (ms)   time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
DB CPU                                            8,687          79.5
db file sequential read           1,699,159       1,539      1   14.1 User I/O
log file sync                        35,518         170      5    1.6 Commit
direct path read                    418,577         165      0    1.5 User I/O
enq: TX - index contention            8,136         121     15    1.1 Concurrenc
Host CPU (CPUs:   64 Cores:    8 Sockets:    1)
~~~~~~~~         Load Average
Begin       End     %User   %System      %WIO     %Idle
--------- --------- --------- --------- --------- ---------
1.03      1.29       1.7       0.5       0.0      97.8

Server Stats show CPU is 975 idle

Snap TimeLoad%busy%user%sys%idle%iowait
04-Aug 12:00:591.45
04-Aug 13:00:051.003.082.550.530.0096.92
04-Aug 14:00:111.291.951.460.490.0098.05

View 2 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Know WHEN Table Is Loaded

Jul 19, 2011

I have a table emp_up, daily this table is uploaded by a SQL *LOADER(with REPLACE option) script run by a UNIX JOB.There is no particular timestamp column in this table. Is it possible to know when/AT what time the table is uploaded.

View 2 Replies View Related

SQL & PL/SQL :: Data Loaded Looks Different And Cannot Be Read?

May 1, 2013

I select the data from sql server column type nvarchar2 and load into varchar2 but data once loaded looks very different and can't be read.

let say name column in sqlser values is 'Rajesh' then in oracle it looks like series of square shape.

View 1 Replies View Related

SQL & PL/SQL :: How To Get Partition Name Which Was Recently Loaded

Oct 18, 2013

How can i get the partition name which was recently loaded. When my load start it truncate the partition and load the data.once the data is loaded there is another load which will read from earlier loaded partition table. i want to know on the fly which partition was loaded recently.

View 10 Replies View Related

SQL & PL/SQL :: Inserting Number Of Records Loaded Into Log Table

Mar 8, 2013

I got Scenario that, i need to insert the number of records loaded in target table into the log table.

But the resultset is handled in the in the cursor. how to get the number of records the cursor handles.

/* Formatted on 08/03/2013 15:00:44 (QP5 v5.149.1003.31008) */
CREATE OR REPLACE PROCEDURE DASHBOARD75.SP_STG_MLY_GL_HKP_V1_00
AS
CURSOR GL_HKP
IS
SELECT CAL.MTH_NM,
CAL.YEAR,
GLM.BU_CD,
[code].......

View 7 Replies View Related

Forms :: Enabling All Checkboxes When Block Is Loaded

Dec 6, 2012

My requirement is as below,

I have one main form and there is one button when i click on it, another form should be opened which should display multi records with check box for each record.

I have implemented so far. When the new form is opened by default all the records should be checked. if user does not want some of them then it can be unchecked(This can done manually)..

I have put below code in when-new-block instance trigger

set_item_property('LOCKBOX_DETAILS.CB_SUBMIT', ENABLED, PROPERTY_TRUE);

Unable to load the block with all the records checkboxes checked.

View 4 Replies View Related

Forms :: Bean Not Found When Form Is Loaded

Jan 14, 2009

when i run my form im immediately im geting geting this error message

oracle.forms.webutil.file.FileFunctions bean not found.CLIENT_TEXT_IO.fopen will not work

when i searched in meta link i found a solution but not know ing how to implement it..

Symptoms When running a customized Webutil Form an error similar with the following is displayed:

oracle.forms.webutil.file.FileFunctions bean not found. CLIENT_TEXT_IO.fopen will not work.

The exact function that "will not work" may change in the error message depending on the WebUtil code used. There are no errors displayed in the Java Console. The original WebUtil Demo Form runs successfully. Cause The WebUtil code that is failing is placed in triggers that are firing before Forms instantiates the WebUtil PJCs.

This is not allowed when using WebUtil and it is explained in the WebUtil User Guide release 1.0.6, section 5.3: "Once the WebUtil library has been attached to your form you can start to add calls to the various PL/SQL APIs defined by the utility. However, there is an important restriction in the use of WebUtil functions: WebUtil can only start to communicate with the client once the Form has instantiated the WebUtil PJCs. This means that you cannot call WebUtil functions before the Forms user interface is rendered.

This would include triggers such as PRE-FORM, WHEN-NEW-FORM-INSTANCE and WHEN-NEW-BLOCK-INSTANCE for the first block in the Form." SolutionDo not use Webutil code in triggers like PRE-FORM, WHEN-NEW-FORM-INSTANCE and WHEN-NEW-BLOCK-INSTANCE because these triggers are firing before Forms instantiates the WebUtil PJCs Instead, you can test the WebUtil functionality with a WHEN-BUTTON-PRESSED trigger and you can use it in your application in other allowed locations.

View 5 Replies View Related

XML DB :: Error When Parsing XML Data That Is Loaded Using SQL Loader

Sep 7, 2012

I am loading content of an XML file into a table using SQL loader.Below is my Control file script -

LOAD DATA
INFILE *
INTO TABLE xx_cc_response_xml_stg TRUNCATE
xmltype(XML_DATA)
FIELDS
( COLUMN_ID constant 1,
file_name filler char(4000),
XML_DATA LOBFILE(file_name) TERMINATED BY EOF)
BEGINDATA
B2B_MasterDataUpdate_20120906152137.xml
------------------------------------------------------------------------------------

The file B2B_MasterDataUpdate_20120906152137.xml is correct and XML is well formed.When i try to query for XML_DATA (datatype XMLType) column in the table, i cannot see any content in the record, and it appears as (XMLTYPE)When I parse this XML using the below,

select value(d)
from xxnbn_cc_response_xml_stg a,
table(xmlsequence(extract(a.xml_data,'/InventorySearch'))) d;
------------------------------------------------------------------------------------
I get this error:
------------------------------------------------------------------------------------
ORA-00600: internal error code, arguments: [qmcxdsSelf4], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause:    This is the generic internal error number for Oracle program
exceptions.     This indicates that a process has encountered an
exceptional condition.
*Action:   Report as a bug - the first argument is the internal error number
------------------------------------------------------------------------------------

View 1 Replies View Related

SQL & PL/SQL :: Table Comparison - Loaded Data From Source To Destination

Apr 29, 2013

i have 2 tables in two different sources.

I have loaded data from source to destination.

some rows are missed while loading.

i want to know the missing rows

View 11 Replies View Related

Oracle 10g IMP - After Tables Are Loaded Procedure Appears To Hang?

Oct 14, 2011

I have an Oracle IMP that seems to complete, but there are two things that I don't understand:

1) The tables seem to load successfully in about 4 hours. After the tables are loaded, the IMP procedure appears to hang for10+ hours. I can query the tables at this time, so I'm not sure what it's doing. Is it maybe applying constraints?Is it normal for applying constraints to take 3-4X as long as importing the data?

2) I see a few of these messages in the alert log during the import.Thread 1 cannot allocate new log, sequence 2754 I don't see errors in the IMP log so are these messages informational or warnings, or will there be something wrong with my imported data?

View 1 Replies View Related

SQL & PL/SQL :: Remove Data Recently Loaded But Not Disturbing Existing Original Data?

Jun 24, 2010

I have few tables in Oracle 9i/10g , and they already have data in them. I am trying to migrate the data coming from various source systems into these Oracle tables. There is a chance that after loading I might get some unwanted data into these tables.

How do I remove just that data which I have loaded recently, and do not disturb the original data it already has.

Need to backup those tables and reload the data back if there is any problem, but I am looking at a different approach. I just don't want to change the existing system, as lot of users use the system.

View 8 Replies View Related

SQL & PL/SQL :: Pull In Last Loaded Data From Staging Table To Target Table?

Mar 9, 2011

I have a staging table and a target table. How do I pull in last loaded data from staging table to target table?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved