Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Move WordPress site from one hosting service to other. PHP/MYSQL/Wordpress
  • Proc code Oracle
  • Privilege to describe the table. Oracle
  • myfile Oracle
  • Important Script Method for tuning Oracle
  • load SPM baseline from cursor cache Oracle
  • Unix command for system configuration Linux/Unix
  • how to find OS block size Oracle
  • Find All internal Parameters Oracle
  • Jai Shree Ram Linux/Unix
  • Renaming the column name Oracle
  • database trigger failing Oracle
  • Korn Shell Arithmatic Linux/Unix
  • dbinv.sql Oracle
  • How can I tell if ASO is installed ? Oracle

Category: Oracle

AWR license

Posted on 12-Oct-201022-May-2023 By Admin No Comments on AWR license

ref: http://blog.tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/ When you access Oracle AWR (and other licensed features/tables/views) then these do show up in DBA_FEATURE_USAGE_STATISTICS. Exporting the contents is the same as accessing these with your SQL. All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT,…

Read More “AWR license” »

Oracle, SQL scripts

Oracle Material from OTN

Posted on 08-Sep-2010 By Admin No Comments on Oracle Material from OTN

Oracle Learning Library ======================= http://apex.oracle.com/pls/apex/f?p=9830:41:0::NO Getting Started with Oracle SQL Developer ========================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/sqldev_mngdb/sqldev_mngdb_otn.htm Using Source Code Control in Oracle SQL Developer ================================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/srccodexmlext/srccode_otn.ht

Oracle, SQL scripts

column level grant syntax

Posted on 22-Jul-2010 By Admin No Comments on column level grant syntax

grant update (colum1, col2) on owner.table_name to other_user/role;

Oracle, SQL scripts

How to see which patches are applied.

Posted on 09-Jul-2010 By Admin No Comments on How to see which patches are applied.

There are 2 ways. 1) opatch lsinventory 2) select * from sys.registry$history;

Oracle, SQL scripts

Temporary Tablespsace Temp tablespace behaviour

Posted on 25-May-2010 By Admin No Comments on Temporary Tablespsace Temp tablespace behaviour

Description =========== When monitoring the size of the available free space in the TEMPORARY tablespace it does not increased once sorts are finished even with no client connections to the database. They may also be a large number of EXTENTS of type TEMPORARY in the temporary tablespace. Users may also experience ORA-1652 when running transactions….

Read More “Temporary Tablespsace Temp tablespace behaviour” »

Oracle, SQL scripts

Handling LOB data in Oracle

Posted on 24-May-2010 By Admin No Comments on Handling LOB data in Oracle

Here is another good example: You can initialize the LOBs by using the following SQL INSERT statement: INSERT INTO lob_table VALUES (1001, EMPTY_BLOB(), NULL, EMPTY_CLOB(), NULL); External LOBs: INSERT INTO lob_table VALUES (21, NULL, NULL, NULL, BFILENAME(‘IMG’, ‘image1.gif’)); INSERT INTO lob_table VALUES (22, NULL, NULL, NULL, BFILENAME(‘IMG’, ‘image2.gif’)); UPDATE lob_table SET f_lob = BFILENAME(‘IMG’, ‘image3.gif’)…

Read More “Handling LOB data in Oracle” »

Oracle, SQL scripts

oracle Dba site

Posted on 07-May-2010 By Admin No Comments on oracle Dba site

Oracle GoldenGate Tutorial 9 – Monitoring GoldenGate

Oracle, SQL scripts

Goldengate document from Porus

Posted on 07-May-2010 By Admin No Comments on Goldengate document from Porus

http://www.oracle.com/technology/pub/articles/havawala-goldengate.html

Oracle, SQL scripts

Goldengate Tutorial

Posted on 07-May-2010 By Admin No Comments on Goldengate Tutorial

GoldenGate Tutorial: Simplest

Oracle, SQL scripts

ORA-3136

Posted on 06-May-2010 By Admin No Comments on ORA-3136

Issue: Inbound connection timed out (ORA-3136) In 10gR2, SQLNET.INBOUND_CONNECT_TIMEOUT the parameters were set to have a default of 60 (seconds). Set the parameters SQLNET.INBOUND_CONNECT_TIMEOUT and INBOUND_CONNECT_TIMEOUT_listenername to 0 (indefinite). What the error is telling you is that a connection attempt was made, but the session authentication was not provided before SQLNET.INBOUND_CONNECT_TIMEOUT seconds. As far as…

Read More “ORA-3136” »

Oracle, SQL scripts

Posts pagination

Previous 1 … 3 4 5 … 40 Next

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • cp_filesystem.sql Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Configure ssh authentications for RAC Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • Find long Running Transaction Linux/Unix
  • database trigger failing Oracle
  • sesswait.sql Oracle
  • to see when crontab is changed. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme