Home » RDBMS Server » Performance Tuning » Database slow problem (10g Database)
Database slow problem [message #439511] Mon, 18 January 2010 00:23 Go to next message
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.
Re: Database slow problem [message #439512 is a reply to message #439511] Mon, 18 January 2010 00:50 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ramoradba
Messages: 2454
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 Go to previous messageGo to next message
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?
Re: Database slow problem [message #439886 is a reply to message #439511] Tue, 19 January 2010 21:43 Go to previous messageGo to next message
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...
Re: Database slow problem [message #439925 is a reply to message #439886] Wed, 20 January 2010 03:44 Go to previous message
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.

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


Current Time: Fri Sep 30 05:29:34 CDT 2016

Total time taken to generate the page: 0.16860 seconds