Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Jai Shree Ram Linux/Unix
  • Rman Notes -1 Oracle
  • How to start CRS manually Oracle
  • compile_inv.sql Oracle
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Rownum with Order by Oracle
  • Updated LCK.SQL file. Oracle
  • Move WordPress site from one hosting service to other. PHP/MYSQL/Wordpress
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • Export Import with QUERY Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix
  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
  • Finding Oracle Patches with opatch Oracle

Move WordPress site from one hosting service to other.

Posted on 06-Jun-202306-Jun-2023 By Admin No Comments on Move WordPress site from one hosting service to other.

We need to follow the steps below for moving website from one hosting provider to other hosting provider. At Source Hosting   Take backup of existing website. This will take complete backup of all your WP files plus SQL file for database.  The final backup file will be in “.tar.gz” format.  At Target Hosting Create the…

Read More “Move WordPress site from one hosting service to other.” »

PHP/MYSQL/Wordpress

How to hide author name in WordPress BLOG

Posted on 02-Jun-202304-Jun-2023 By Admin No Comments on How to hide author name in WordPress BLOG

Do you want to hide or remove the author name from your WordPress blog posts? Normally, blog posts are supposed to show author name with other meta-data like date and category. However, some blog owners may not want to display the author name next to their blog posts. By default, WordPress does not have an…

Read More “How to hide author name in WordPress BLOG” »

PHP/MYSQL/Wordpress

S3 Basic info

Posted on 30-May-202331-May-2023 By Admin No Comments on S3 Basic info

S3= simple storage service Object based storage. File size can be from 0 to 5TB. S3 provide object storage to store files, it does not provide block storage where you can install OS. Successful uploads generate HTTP 200 status code. You can turn on MFA delete. Files are stored in buckets, that’s another name of…

Read More “S3 Basic info” »

AWS

ENQ: KO – FAST OBJECT CHECKPOINT tips

Posted on 25-May-202325-May-2023 By Admin No Comments on ENQ: KO – FAST OBJECT CHECKPOINT tips

On reporting queries, there are too many “enq: KO – fast object checkpoint” wait event. All reporting queries are doing full table scans concurrently. Oracle uses direct path reads instead of db file scattered reads. And direct path reads require a checkpoint “_serial_direct_read”=NEVER Parameter Session Value Instance Value ————————————————– —————————— —————————— _serial_direct_read auto auto

Oracle

GSQ.sql

Posted on 19-May-202325-May-2023 By Admin No Comments on GSQ.sql

This SQL will be used to identify SQL details of given Session. You need to pass SID and INSTANCE_ID as INPUT. This query will provide session details, SQL_ID, SQL_EXEC_START time and other transaction level details. set echo off feedback off verify offcol Transaction_id format a20col username format a8col days format 99.99col hours1 format 999999col TX_HRS…

Read More “GSQ.sql” »

Oracle, SQL scripts

PHP code to add WordPress posts in bulk programmatically

Posted on 17-May-202303-Jun-2023 By Admin No Comments on PHP code to add WordPress posts in bulk programmatically

Following code will be used for adding multiple entries to <?php // This is needed to use WP functions. require_once(‘../wp-load.php’); //echo “%%%%”. preg_replace(“/:/”, ” “, “21-Dec-2010:10:37:27”, 1); // Category tables are // wp_terms here term_id will present category_id, // wp_term_relationship show relationships with posts. // wp_term_taxonomy-for total post count // 4= oracle, 10-sqlscripts // Read…

Read More “PHP code to add WordPress posts in bulk programmatically” »

PHP/MYSQL/Wordpress

DBA_HIST_SQLSTAT contents

Posted on 10-May-202310-May-2023 By Admin No Comments on DBA_HIST_SQLSTAT contents

Query DBA_HIST_WR_CONTROL to see the interval, retention and the TOPNSQL setting.  For TOPNSQL a setting of DEFAULT translates to: 30 where statistics_level is typical 100 where statistics_level is all Simply because this one SQL appears to consume 7% of the load it may not be in the top SQLs in these categories: Elapsed Time CPU…

Read More “DBA_HIST_SQLSTAT contents” »

Oracle

Find_planinfo.sql

Posted on 08-Apr-202322-Apr-2025 By Admin No Comments on Find_planinfo.sql

/********************************************Author: Paresh MehtaScript Name : find_planinfo.sql********************************************/set lines 200set pages 500set echo offcol execs for 999,999,999col avg_etime for 999,999.999col avg_lio for 999,999,999.9col begin_interval_time for a30col node for 99999col plan_hash_value format 99999999999999col sql_profile format a30col intrvl format a29col component format a20alter session set nls_date_format=’DD-MON-RRRR:HH24:MI:SS’;–break on plan_hash_value,sql_profile on startup_time skip 1accept v_sql_id prompt ‘Enter SQL_ID ->’select s.instance_number, to_char(begin_interval_time,’DD-MON:HH24:MI’)…

Read More “Find_planinfo.sql” »

Oracle, SQL scripts

Wait.sql

Posted on 04-Apr-202322-Apr-2025 By Admin No Comments on Wait.sql

/********************************************Author: Paresh MehtaScript Name : waitt.sqlwaits order by sql start time********************************************/set feedback 1set pages 2000set lines 190column event format a45column machin format a12column modul format a10column prg format a10column osuser1 format a10column username format a10column sesinfo format a15column blockedby format a15alter session set nls_date_format=’DDMONRR:HH24:MI:SS’;select /*+ first_rows(100) */ a.sid || ‘,’ || a.serial# || ‘,@’ ||…

Read More “Wait.sql” »

Oracle, SQL scripts

CPU speed on Linux

Posted on 10-Dec-2010 By Admin No Comments on CPU speed on Linux

less /proc/cpuinfo

Linux/Unix, shell

Posts pagination

Previous 1 2 3 4 … 56 Next

Categories

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

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
  • Export Oracle data and Compress at same time Oracle
  • checking redhat linux version Linux/Unix
  • How to start CRS manually Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • How to know current SID Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • Mutating Table Error while using database trigger Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme