Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • get_vmstat_solaris Oracle
  • Implementing Listener Security Oracle
  • Jai Shree Ram Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • findobj.sql Oracle
  • Caching sequence in Memory Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Getting started with notebook Python/PySpark
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • Query to Generate aggregate on every 30 mins. Oracle
  • sess1.sql Oracle
  • reset Sequence Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • Validating ORACLE_SID againt oratab file. Linux/Unix

Category: SQL scripts

Giving Grant on v$DATABASE

Posted on 12-Jan-2006 By Admin No Comments on Giving Grant on v$DATABASE

To give grant on v$database or any such synonym, need to follow following steps. 11:02:21 SYS@UOCQA:-> select * from dba_synonyms where synonym_name = ‘V$DATABASE’; OWNER SYNONYM_NAME TABLE_OWNER —————————— —————————— —————————— TABLE_NAME —————————— DB_LINK —————————————————————————————————- PUBLIC V$DATABASE SYS V_$DATABASE Then, 11:02:22 SYS@UOCQA:-> GRANT SELECT ON V_$DATABASE TO PUBLIC;

Oracle, SQL scripts

Very Good Oralce Internal Tuning Book

Posted on 11-Jan-2006 By Admin No Comments on Very Good Oralce Internal Tuning Book

http://www.sun.com/blueprints/0303/817-1781.pdf

Oracle, SQL scripts

Virtual Indexes in Oracle

Posted on 29-Dec-2005 By Admin No Comments on Virtual Indexes in Oracle

Create virtual indexes 11:42:42 CS@UOCQA:-> create index index_1 on BSKT_SHOPPING_BASKET_ITEM (BASKET_RECIPIENT_ID, BASKET_ITEM_ID) nosegment; need to set a hidden parameter as following. 11:42:42 CS@UOCQA:-> alter session set “_use_nosegment_indexes”=true; Indexes created without any segment. cannot views with User_indexes. Can be viewed in USER_OBJECTS. Useful in producton environment where we cannot create any indexes. Existance of this index…

Read More “Virtual Indexes in Oracle” »

Oracle, SQL scripts

Optimizer SORT Operations

Posted on 28-Dec-2005 By Admin No Comments on Optimizer SORT Operations

(1) Operation : SORT UNIQUE Cause : DISTINCT Clause, and IN sub-query where subquery is independent meand no co-relation with parenst query. If for IN subquery, there is an unique index on selected columns then SORT UNIQUE can be avoided. (2) Operation : SORT AGGREGATE Cause : Whenever u use group functions. It does not…

Read More “Optimizer SORT Operations” »

Oracle, SQL scripts

Good Site for Oracle Internals

Posted on 23-Dec-2005 By Admin No Comments on Good Site for Oracle Internals

http://www.EvDBT.com/library.htm

Oracle, SQL scripts

Find All internal Parameters

Posted on 23-Dec-2005 By Admin No Comments on Find All internal Parameters

select a.ksppinm “Parameter”, b.ksppstvl “Session Value”, c.ksppstvl “Instance Value” from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and substr(ksppinm,1,1)=’_’ order by a.ksppinm;

Oracle, SQL scripts

Find Time Consuming SQL Statements in Oracle 10g

Posted on 22-Dec-2005 By Admin No Comments on Find Time Consuming SQL Statements in Oracle 10g

spool badsql5 set lines 132 set pages 300 col USR format a14 col PAR heading “Parsing ID” format 9999999 col ELA heading “ELP time(Sec)” format 9999999.0 col HASH heading “Hash Value” col USR heading “Parsing User” col T heading “SQL Text having Elapsed time > 1 sec” break on HASH on USR on ELA skip…

Read More “Find Time Consuming SQL Statements in Oracle 10g” »

Oracle, SQL scripts

Goog notes on X$ tables

Posted on 21-Dec-2005 By Admin No Comments on Goog notes on X$ tables

http://www.adp-gmbh.ch/ora/misc/x.html http://www.orafaq.com/faqdbain.htm

Oracle, SQL scripts

Histogram Overview

Posted on 20-Dec-2005 By Admin No Comments on Histogram Overview

Histograms ========== For uniformly distributed data, the cost-based approach makes fairly accurate guesses at the cost of executing a particular statement. However, when the data is not uniformly distributed, the optimizer cannot accurately estimate the selectivity of a query. Beginning in release 7.3, for columns which do not have uniform data distribution, Oracle will allow…

Read More “Histogram Overview” »

Oracle, SQL scripts

DBMS_STATS Metalinks Notes

Posted on 15-Dec-2005 By Admin No Comments on DBMS_STATS Metalinks Notes

Note:102334.1 Subject: How to Automate Change Based Statistic Gathering – Monitoring Tables

Oracle, SQL scripts

Posts pagination

Previous 1 … 24 25 26 … 35 Next

Categories

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

Recent Posts

  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Kernel Parameters for Solaris Linux/Unix
  • Single character replacement in Unix Linux/Unix
  • find_err.sql for finding errors from dba_errors. Oracle
  • Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
  • newupload.html PHP/MYSQL/Wordpress
  • Remove DOS CR/LFs (^M) Linux/Unix
  • setting prompt display with .profile Linux/Unix
  • Check Oracle installed products using one command Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme