473,385 Members | 2,004 Online

Home Posts Topics Members FAQ

home > topics > can i delete some statisitcs table(s) from oracle to tune it?

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Can I delete some statisitcs table(s) from Oracle to tune it?

Does anyone know? Thanks so much.

Jul 19 '05 #1

Subscribe Post Reply

3

2729

Your question isn't clear, please provide more details as to what you
want to achieve.

Daniel

Jul 19 '05 #2

G M

To tune database? You probably want to know what the problems are
before trying to tune it. Usually people would analyze tables
periodically so the oracle optimizer would work properly.

HTH.

Guang
bl*********@hotmail.com (Jason) wrote in message news:<f5**************************@posting.google. com>...

Does anyone know? Thanks so much.

Jul 19 '05 #3

Jason wrote:

Does anyone know? Thanks so much.

analyze table .... delete statistics, will delete the statistics.

But that wil not tune anything.
--
------------------------------------------------------------------------

*Michael Willer*
*Oracle & J2EE architect*

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

Poor performance after oracle 8i upgrade

by: Ruth | last post by:

Hi All I am not a DBA, but a unix administrator. After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our test server, we have noticed a big slow down in our application...

Oracle Database

Equivilant of Oracle's DB Links in DB2

by: Nick Palmer | last post by:

Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB...

by: Mitchell Thomas | last post by:

I have 3 tables and they are all a one-one relationship. The tables are in oracle with Access as the front end. If user deletes a record from Table1, how do I programmatically delete the...

Microsoft Access / VBA

ON DELETE trigger blocks delete from my table

by: Naeem Bari | last post by:

Hi, I am using postgres 7.4.5 on Redhat Enterprise Linux 3. My background is really on Oracle, and I am porting a largish database over to postgres. Here is my problem: On oracle, I...

PostgreSQL Database

How to delete a SQL Server record (descending from another record of the same table) with a C# application

by: polocar | last post by:

Hi, I'm writing a program in Visual C# 2005 Professional Edition. This program connects to a SQL Server 2005 database called "Generations" (in which there is only one table, called...

Oracle 10g and XP

by: JoeUK | last post by:

I'm running Windows XP Service pack 2 I have 1GB of RAM I have an AMD 64 processor 3000+ I'm a back end oracle programmer by trade with commercial experience of 8i. I'm trying to get myself...

Oracle Database

Help: Trigger -Not able to delete data from trigger table.

by: Alexis | last post by:

Hello, I'm facing oracle trigger problem. Anyone can help or advise how to resolve it? Below are the explaination on my problem I've created a trigger for my program. When there is a new...

Oracle Database

Can I delete some statisitcs table(s) from Oracle to tune it?

by: Jason | last post by:

Does anyone know? Thanks so much.

Oracle Database

How to reduce table size using delete or truncate statement in 10G

by: ananthaisin | last post by:

How to reduce the table size for any table while using truncate or delete statements. In oracle 8i it was truncating the storage space but in 10g it is not .... I have given truncate statement in...

Oracle Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!