OraFAQ Forum: Performance Tuning » Performance for Table analysis

Home » RDBMS Server » Performance Tuning » Performance for Table analysis (11.2.0.1)

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

Performance for Table analysis [message #583732]

Fri, 03 May 2013 07:29

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi,

I have one query regarding my analysis on table.

Table is loading with the data daily around 15 to 20 lakhs. Table does not have anything except primary key.

Please advice how to analyse my table with performance wise and which is the best method or any document for analysis of the table/database.

Report message to a moderator

Re: Performance for Table analysis [message #583733 is a reply to message #583732]

Fri, 03 May 2013 07:45

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

First you're really going to have to explain what problem you're trying to solve (excessive redo/excessive space waste/excessive runtime and so on) - then we can perhaps assist in the best method.

It doesnt sound like you have an issue identified yet, but I may be wrong.

Report message to a moderator

Re: Performance for Table analysis [message #583737 is a reply to message #583733]

Fri, 03 May 2013 08:30

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

I have problem with all the scenarios like excessive runtime,excessive redo and excessive space waste. I need to get tuned the table like partitiong, purging, indexing, table restructuring etc.

Report message to a moderator