Skip to content

Home
About Me
Toggle search form
Search for:

Directory wise folder wise space usage Linux/Unix
findobj.sql Oracle
Disbaling DBA_SCHEDULER_JOBS Oracle
How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
Oracle 11g Environment Setup Oracle
currwait.sql Oracle
Shuffle an array PHP/MYSQL/Wordpress
good note for shared pool tunnig Oracle
v$event_name Oracle
Load testing on Oracle 19C RAC with HammerDB Oracle
PLSQL Table Syntax 2 Oracle
Some OS level threshold for performance. Linux/Unix
move_arch_files.ksh Linux/Unix
Multiple listeners Oracle

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

Post navigation

Previous Post: Histogram Overview

Next Post: Find Time Consuming SQL Statements in Oracle 10g

Related Posts

Locktree.sql Oracle
segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
Index Range Scan Oracle
longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
Temporary Tablespace Information and restriction. Oracle
CTAS with LONG Column for 7.x and 8 and 8i Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

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

How to start CRS manually Oracle
276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
VIvek Encryption Package and Its Usage Oracle
Single character replacement in Unix Linux/Unix
plan10g.sql good1 Oracle
Good link for LIO in Oracle ( Logical IOs) Oracle
Add new columns in dataframe Python/PySpark
temp_use.sql diplays usage of temp ts Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme