Home » RDBMS Server » Performance Tuning » Performance for Table analysis (11.2.0.1)
Performance for Table analysis [message #583732] Fri, 03 May 2013 07:29 Go to next message
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.
Re: Performance for Table analysis [message #583733 is a reply to message #583732] Fri, 03 May 2013 07:45 Go to previous messageGo to next message
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.
Re: Performance for Table analysis [message #583737 is a reply to message #583733] Fri, 03 May 2013 08:30 Go to previous messageGo to next message
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.
Re: Performance for Table analysis [message #583738 is a reply to message #583737] Fri, 03 May 2013 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You do NOT "tune" tables.
You tune SQL statements.
Re: Performance for Table analysis [message #583739 is a reply to message #583738] Fri, 03 May 2013 08:46 Go to previous messageGo to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
Sorry, not tuning the tables.
Re: Performance for Table analysis [message #583740 is a reply to message #583739] Fri, 03 May 2013 08:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I tune my piano.
Previous Topic: Ideas for fixing plan cardinality error
Next Topic: Does partitioning need constraints to be copied
Goto Forum:
  


Current Time: Thu Mar 28 14:51:23 CDT 2024