OraFAQ Forum: Performance Tuning » Database slow problem

Home » RDBMS Server » Performance Tuning » Database slow problem (10g Database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database slow problem [message #439511]

Mon, 18 January 2010 00:23

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

i have total 18 tables.

1st table has 9 records.
2nd table has 01 record.
3rd table has 01 record.
4th table has 883 record.
5th table has 05 record.
6th table has 17 record.
7th table has 243 record.
8th table has 3432 record.
9th table has 04 record.
10th table has 10 record.
11th table has 743 record.
12th table has 185 record.
13th table has 316 record.
14th table has 614 record.
15th table has 09 record.
16th table has 36 record.
17th table has 05 record.
18th table has 03 record.

i m using oracle database 10g.
i sure thats not enaugh for this database.

i m creating application on this databse in form 6i.

inster, update, delete, select statments use in this databse by using form on the daily

basis.

and now when i use any DML statmetns on this databse then its retrive records very slowly..

what can i do fast my database.

Report message to a moderator

Re: Database slow problem [message #439512 is a reply to message #439511]

Mon, 18 January 2010 00:50

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

allianz2010,

Quote:

and now when i use any DML statmetns on this databse then its retrive records very slowly..

can you please give a specific example with DDL and DML Queries, Plan output etc Please.

-Rahul

[Updated on: Mon, 18 January 2010 00:51]

Report message to a moderator

Re: Database slow problem [message #439513 is a reply to message #439511]

Mon, 18 January 2010 00:56

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

You should read Guidelines

And this Document

sriram Smile

[Updated on: Mon, 18 January 2010 00:57]

Report message to a moderator

Re: Database slow problem [message #439833 is a reply to message #439511]

Tue, 19 January 2010 10:46

PAVB
Messages: 1
Registered: January 2010
Location: Fort Lauderdale, FL

Junior Member

allianz2010 wrote on Mon, 18 January 2010 01:23

and now when i use any DML statmetns on this databse then its retrive records very slowly..

A database that size should perform fantastic even on MS-Access Laughing

- Could you please define "slow"?
- "slow" compared with what?
- Could you please share offending query with us?
- Have you traced offending query?
- What else is running on target host?

Report message to a moderator

Re: Database slow problem [message #439886 is a reply to message #439511]

Tue, 19 January 2010 21:43

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

A database that size should perform fantastic even on MS-Access Laughing

- Could you please define "slow"?
- "slow" compared with what?
- Could you please share offending query with us?
- Have you traced offending query?
- What else is running on target host?

Thanks for reply....
can form 6i use with MS-Access

- slow mean when i retrieve records on form then it take some time...
* slow mean when i create new record then its take some time....

-- I use that code for Find record...

DECLARE
LOV BOOLEAN;
ALRT NUMBER;
BEGIN
LOV := SHOW_LOV('FIND_LOV');
IF :PARAMETER.R_NUM_PMTR IS NOT NULL THEN
GO_BLOCK('STOCK_MANAGER');
EXECUTE_QUERY;
GO_RECORD(:PARAMETER.R_NUM_PMTR);
END IF;
END;

-- I Use that code for Create Record...

DECLARE
ALRT NUMBER;
BEGIN

SET_BLOCK_PROPERTY('STOCK_MANAGER',UPDATE_ALLOWED,PROPERTY_FALSE);
GO_BLOCK('STOCK_MANAGER');
EXECUTE_QUERY;
LAST_RECORD;
IF :STOCK_MANAGER.SM_ID IS NOT NULL THEN
CREATE_RECORD;
END IF;
:PARAMETER.MODE_PMTR := 1; -- 1 - NEW
END;

-- Just Database 10g, Forms & Report 6i running on target host.

i think this answers of your question...

and not that records enough. in this databsae increase records on daily basis but i delete record after 10 days just for running my software....

-- but i know that its not solution of my problem....
-- i discuss this problem with my friend and he said me about watermarks and i have no idea about watermark..

now what you suggest me...
sir i m new in oracle world...

please sir if you give me answer than please please give some examples and steps...

thanks again for your reply...

Report message to a moderator

Re: Database slow problem [message #439925 is a reply to message #439886]

Wed, 20 January 2010 03:44

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

You would only hae a problem with High Watermarks if your tables had previously had a lot more rows in the them than they do now.

The High Watermark is the mark recording the maximum number of rows the table has ever had in it, and when you do a full table scan, the database needs to read up to this mark - thus a table with few rows in it that used to have a large number can take a long time to do a full table scan on.

Can yuo show us the Where clause that is defined on the STOCK_MANAGER block?

I very much doubt that this is a database problem - it's much more likely to be a problem in the Form, or with the computer that Forms is running on.

Report message to a moderator

Previous Topic:	how to avoid multiple Like operators in a single query
Next Topic:	"os thread startup" in top 5 Events

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 01:29:37 CDT 2024