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

11g

Home » 11g

Using SQL commands on ADRCI

  • Post author:Amit Bansal
  • Post published:3 January, 2013
  • Post category:11g
  • Post comments:0 Comments

While working with ADRCI , I came to know that we can run normal SQL commands for some of the operation.e.g To display current purge policy , you can run…

Continue ReadingUsing SQL commands on ADRCI

Limiting I/O and CPU resources using 11g Oracle Resource Manager

  • Post author:Amit Bansal
  • Post published:1 September, 2012
  • Post category:11g/Performance
  • Post comments:6 Comments

Recently I was working on using Oracle DBMS_RESOURCE_MANAGER to limit resources usage by read-only queries. This was required to prevent long running ad-hoc and poorly written queries.Instead of writing custom…

Continue ReadingLimiting I/O and CPU resources using 11g Oracle Resource Manager

Sqlplus HTML reports

  • Post author:Amit Bansal
  • Post published:28 June, 2012
  • Post category:10g/11g
  • Post comments:1 Comment

I was working on setting up monitoring for application team to monitor AQ and wanted html formatting of table data. On searching I found this link from Ittichai Chammavanijakul  which makes…

Continue ReadingSqlplus HTML reports

11gR1 CRS start failing with ORA-29702

  • Post author:Amit Bansal
  • Post published:14 December, 2011
  • Post category:11g
  • Post comments:0 Comments

This post was actually a comment from Sasi which came on previous article 10.2 CRS startup issue . I am converting it to a post so that we can get some…

Continue Reading11gR1 CRS start failing with ORA-29702

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
Read more about the article Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password

Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password

  • Post author:Amit Bansal
  • Post published:8 September, 2009
  • Post category:10g
  • Post comments:12 Comments

You have been asked to schedule a shell script which need to connect to a  particular user and perform some action? How do you pass the password to script without…

Continue ReadingUsing Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password
  • 1
  • 2
  • 3
  • 4
  • 5
  • Go to the next page
Copyright - OceanWP Theme by OceanWP