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

sqlplus

Home » sqlplus
Read more about the article 12c: Sqlplus Displays Last Login Time For Non – Sys Users

12c: Sqlplus Displays Last Login Time For Non – Sys Users

  • Post author:Amit Bansal
  • Post published:22 July, 2013
  • Post category:12c
  • Post comments:1 Comment

12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it…

Continue Reading12c: Sqlplus Displays Last Login Time For Non – Sys Users

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

Input is too long (> 2499 characters) – line ignored

  • Post author:Amit Bansal
  • Post published:30 January, 2009
  • Post category:Unix
  • Post comments:0 Comments

There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve…

Continue ReadingInput is too long (> 2499 characters) – line ignored

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