Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Performance

Home » Performance » Page 3

GATHER_STATS_JOB – Is it enabled?

  • Post author:Amit Bansal
  • Post published:18 August, 2009
  • Post category:10g/11g
  • Post comments:9 Comments

Few days back , Martin had posted a series of post on a issue where GATHER_STATS_JOB was failing silently for a large object. If you have missed it, you can…

Continue ReadingGATHER_STATS_JOB – Is it enabled?

Mview Complete Refresh and Atomic_refresh parameter

  • Post author:Amit Bansal
  • Post published:8 July, 2009
  • Post category:10g
  • Post comments:5 Comments

This post discusses issue faced by me while working on Materialized view (mview) creation at new site(database). Starting Oracle 10g, how atomic_refresh works with complete refresh has undergone a change.…

Continue ReadingMview Complete Refresh and Atomic_refresh parameter

dbms_stats.copy_table_stats does not alter low/high value

  • Post author:Amit Bansal
  • Post published:24 June, 2009
  • Post category:Performance
  • Post comments:8 Comments

I was working on a performance issue arising due to missing table stats on a new partition for large Partitioned table.This was a 10.2.0.4 database on IBM AIX 5L. So…

Continue Readingdbms_stats.copy_table_stats does not alter low/high value

You Don’t need SysDBA privilege to run Awrrpt..

  • Post author:Amit Bansal
  • Post published:8 May, 2009
  • Post category:10g
  • Post comments:0 Comments

Well I tried to Sensationalize this post by using such a heading :) Though I just wanted to point out that Awrrpt script can be run without sysdba privilege too.…

Continue ReadingYou Don’t need SysDBA privilege to run Awrrpt..

Connections to DataBase Hang Including “/ as sysdba”

  • Post author:Saurabh Sood
  • Post published:7 April, 2009
  • Post category:10g
  • Post comments:2 Comments

Recently I faced one issue where all the connection to database hung and it was also not possible to login to database using "/ as sysdba". To get access of…

Continue ReadingConnections to DataBase Hang Including “/ as sysdba”

Index Access best approach?? Not Always…

  • Post author:Amit Bansal
  • Post published:17 December, 2008
  • Post category:Performance
  • Post comments:6 Comments

There is a common misconception that Index access is the best access method for query execution. This approach leads to people concentrate on removing Full Table Scans (FTS) from the…

Continue ReadingIndex Access best approach?? Not Always…
  • Go to the previous page
  • 1
  • 2
  • 3
  • 4
  • Go to the next page

Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments

  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
  • Natarajan Gounder on Creating ASM devices on AIX

Trending

  • Resolving Shutdown Immediate Hang Situations
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • MGMTDB: Grid Infrastructure Management Repository
  • User Sessions stuck on resmgr:cpu quantum wait event
  • TNS file functionality for PostgreSQL
  • Tweaking _Shared_pool_reserved_min_alloc and ORA - 4031
  • Simplified Approach to Resolve ORA-4031

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers

Copyright - OceanWP Theme by OceanWP