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 2

V$SQL_SHARED_CURSOR in 11.2.0.2

  • Post author:Amit Bansal
  • Post published:16 December, 2011
  • Post category:Performance
  • Post comments:0 Comments

Oracle 11.2.0.2 has introduced new column "REASON" to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which…

Continue ReadingV$SQL_SHARED_CURSOR in 11.2.0.2

Oracle Database Appliance Introduced

  • Post author:Saurabh Sood
  • Post published:22 September, 2011
  • Post category:11g
  • Post comments:2 Comments

Oracle has introduced it new product: ODA (Oracle Database Appliance) I was not able to join Oracle President Mark Hurd's webcast where he supposed to announce a new Oracle product[It…

Continue ReadingOracle Database Appliance Introduced

Performance Management Guide on AIX

  • Post author:Saurabh Sood
  • Post published:14 February, 2011
  • Post category:10g/11g
  • Post comments:0 Comments

While trying to find the amount of physical memory used by oracle process on AIX, I got reference of a document from Metalink: Performance Management Guide It tell us about…

Continue ReadingPerformance Management Guide on AIX

ORA-01722 with Full Table Scan

  • Post author:Saurabh Sood
  • Post published:26 December, 2010
  • Post category:11g
  • Post comments:8 Comments

My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 "invalid number" after an upgrade…

Continue ReadingORA-01722 with Full Table Scan

October 2010 Blogroll Report

  • Post author:Amit Bansal
  • Post published:29 October, 2010
  • Post category:Random
  • Post comments:3 Comments

It's been time since we saw log-buffer edition with last being published on 1st October 2010 and  Coskan's weekly blogroll report I found them really useful to read top blog…

Continue ReadingOctober 2010 Blogroll Report

Sqlplus connection on AIX taking too long

  • Post author:Amit Bansal
  • Post published:23 September, 2009
  • Post category:10g
  • Post comments:3 Comments

Recently we faced a performance issue, where in sqlplus connection from application server A (AIX 5.3) to Database server DB (different physical server,10gR2 on AIX 5.3) was taking nearly 1-2…

Continue ReadingSqlplus connection on AIX taking too long
  • 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