Memory2Me

About Oracle and For DBA

Wednesday, May 12, 2010

hang analyze

sqlplus /nolog
connect / as sysdba
oradebug setospid forground_pid
oradebug unlimit
oradebug hanganalyze 3
wait 90 seconds
oradebug hanganalyze 3
exit

Posted by Henry's Blog at 7:50 AM

Labels: SQL command

Newer Post Older Post Home

Search This Blog

Labels

SQL command (15) sample (15) PBT (5) monitoring (4) Error Code (3) configuration (3) oracle11g newfeature (2) EM (1) dataguard (1)

Subscribe Now

Subscribe in a reader

FeedBurner FeedCount

My Oracle Blog List

Tanel Poder's blog: Core IT for Geeks and Pros

Embedding Vectors of the Same Image Rotated Over 360 Degrees - Last year I wrote an article about visualizing embedding vectors of a variety of different pictures as heatmaps. I used TorchVision with ImageNet1K_V1 mode...
5 days ago
Martin Widlake's Yet Another Oracle Blog

Five Years (as David Bowie once sang) – How Covid-19 started for me. - It was about now (10th Jan) 5 years ago when I first became aware of something a little bit wrong happening in China. There was a news article in “New Scie...
1 week ago
Ardent Performance Computing

Postgres Per-Connection Statistics - I’ve had a wish list for a few years now of observability-related things I’d love to see someday in community/open-source Postgres. A few items from my wis...
1 week ago
Hemant's Oracle DBA Blog

Querying the Alert log in RAC - Although v$diag_alert_ext works for a single instance, there is no corresponding gv$ view for RAC. However, the gv$ function can be used to execute a cu...
1 week ago
Laurent Schneider

negative regexp - if you want to grep anything except foo, use grep -v or negative lookahead echo -e 'foo\nbar\nboz'|grep -P '^(?!.*foo).*$' bar boz it is just so beautiful ...
3 months ago
Oradori

Oracle Critical Patch Update Advisory - July 2024 - Oracle Critical Patch Update Advisory - July 2024 http://www.koreaoug.org/news/13380 #koreaoug #한국오라클사용자그룹 #oracle #오라클 #CPU #패치 #보안 #202407
6 months ago
The Oracle Instructor

Pickleball & Longevity - Studien zufolge trägt die Trendsportart Pickleball in nahezu idealer Weise zur Langlebigkeit bei! Wer möchte nicht sein Leben bei guter Gesundheit um 10 Ja...
7 months ago
Online Apps DBA

Power BI in Marketing: Transforming Strategies for Success - Hello Data Enthusiasts!👨‍💻 Explore Power BI for marketing mastery. Uncover data consolidation, interactive dashboards, and predictive analytics. 🌐✨ 📚...
1 year ago
Richard Foote's Oracle Blog

The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”) - Of all my many Oracle blog posts, this particular post will remain with me the longest, for not only is it the last blog post I’ve done in a while, but i...
1 year ago
Kevin Closson's Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases

Following Various Legal Action Regarding “Oracle Cloud Revenue” - As a courtesy, I would like to provide a copy of the latest legal document filed in an action being brought against Oracle leadership resulting from allege...
4 years ago
Oracle related stuff

New Parallel Distribution Method For Direct Path Loads - Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT APPEND and CTAS ...
4 years ago
Oracle Enterprise Manager Grid Control

FINANCIAL SERVICES COMPANY SAVES MORE THAN $2M IN ORACLE RELATED COSTS WITH VXFLEX INTEGRATED RACK - For four years, this financial services company had been running Oracle Exadata on their Oracle databases. During that time, database administrators manage...
5 years ago
Cary Millsap

Sometimes the Simplest Things Are the Most Important - I didn’t ride in First Class a lot during my career, but I can remember one trip, I was sitting in seat 1B. Aisle seat, very front row. Right behind the la...
5 years ago
Jaffar Oracle blog

Intermittent cellsrv crashes with ORA-07445 after upgrading to 12.2.1.1.7 - Exadata X6-2 full and half racks were patched recently with 12.2.1.1.7 Aug/2018 quarterly patch set. An ORA-07445 started to observe and the cellsrv inter...
5 years ago
Striving for Optimal Performance

MIN/MAX Optimization and Asynchronous Global Index Maintenance - In this short post I would like to point out a non-obvious issue that one of my customers recently hit. On the one hand, it’s a typical case where the quer...
5 years ago
So Many Oracle Manuals, So Little Time

Northern California Oracle Users Group organizes the mother of all competitions - In a coolly calculated effort to promote its spring conference featuring a full-day Oracle Database security master class with Oracle ACE director alumnus ...
5 years ago
pdvfirstblog

Ego document - videos - must sink to bottom quickly. - The buzz around RigaDevDays for 2019 made me realize that there are some videos of me out there. Now, I am a bit camera shy: I dont look good on camera, o...
6 years ago
The Arup Nanda Blog

OTW18 Sessions: Data Engineering and Latch Contentions - Thank you all those who came to my sessions at the OakTable World. Here are the presentations materials Think Data; not Database Data Engineering for Data ...
6 years ago
Surachart Opun's Blog

Oracle Database EM 18 XE Available to Remote Clients - I found lot of posts about *Oracle Database 18 XE*. It's very interesting for me. I didn't blog about how to install, because it's very easy for using rpm...
6 years ago
Oracle Secure Enterprise Search results for:product:

Businesses Struggle to Protect Sensitive Cloud Data According to New Oracle and KPMG Cloud Threat Report - Press Release Businesses Struggle to Protect Sensitive Cloud Data According to New Oracle and KPMG Cloud Threat Report Despite defined security policies, ...
6 years ago
Packt Book Feed

Implementing 3 Naive Bayes classifiers in scikit-learn : Bernoulli, Multinomial and Gaussian naive Bayes algorithms - Scikit-learn provide three naive Bayes implementations: Bernoulli, multinomial and Gaussian. The only difference is about the probability distribution ad...
6 years ago
Kerry Osborne's Oracle Blog

Hotsos Symposium 2018 - Just a quick note to say I’m doing a couple of talks at this year’s Hotsos Symposium, which starts next Monday at 8:30AM. It’s not too late to register. ...
6 years ago
The Dutch Prutser's Blog

Oracle Solaris 11.4 Public Beta Released - Yesterday the Oracle Solaris 11.4 Beta was released to the public. You can download it from OTN to have your go with it. Please read the documentation to l...
6 years ago
blog.gralike.com

Oracle and the Autonomous Database (a personal perspective from afar) - Yeah, if you hadn’t seen that one coming, hmmm, what can I say… Lot’s of…
7 years ago
Oracle database internals by Riyaj

IOUG Collaborate 2017 - I have a few presentations scheduled in IOUG Collaborate 2017, Las Vegas. 1. Session: 621: RAC Clusterware internals **Date/time: Mon, Apr 03, 2017 (01:30 ...
7 years ago
Marcelo Ochoa's personal blog

Docker swarm at Oracle Cloud - As I mentioned in a previous post the Oracle Container Service seem to be little for my cloud expectativa. But the Cloud Compute service is enough to implem...
7 years ago
Oracle MVA

Oracle Key Vault: Migrating an Existing TDE Wallet to Oracle Key Vault - Currently I am evaluating Oracle Key Vault (OKV) by setting it up in a VirtualBox environment on my laptop. I have run into some small issues that might be...
8 years ago
H.Tonguc Yılmaz - Oracle Blog

Ücretsiz Davetiye: Türk Hadoop Kullanıcıları Grubu(TRHUG) senelik toplantısı – 25 Kasım Cuma - Türk Hadoop Kullanıcıları Grubu(TRHUG) senelik toplantısı 25 Kasım Cuma günü Kozyatağı Hilton ‘da EMC sponsorluğunda gerçekleşecek. Bu sene Pivotal açık ka...
8 years ago
ORACLENERD

Real World SQL and PL/SQL: Advice from the Experts - *Because my hero is Cary Millsap, I'm going to do what he did and publish my foreword Preface. All joking aside, I consider myself incredibly fortunate...
8 years ago
Oracle by Madrid

ORA-00600 [2663], [12], .... - After not having spotted ORA-00600 for a while a new one showed up. ORA-00600: internal error code, arguments: [2663], [12], [3665664941], [12], [38847178...
8 years ago
Alberto Dell'Era's Oracle blog

“ASH math” of time_waited explained with pictures and simulation - As explained by John Beresniewicz, Graham Wood and Uri Shaft in their excellent overview ASH architecture and advanced usage, avg( v$active_session_history...
8 years ago
Doug's Oracle Blog

Moving Sideways - The past two years have seen a lot of change in my life :- - I moved to Singapore thinking it would be for a year or two at least and is now looking ...
8 years ago
The Blog from the DBA Classroom

Oracle University Provides the Best Test Fests - Oracle University Certification Exams Are once again available at Test Fests at various events. Last year at the TECH14 and APPS14 conferences, the UK Orac...
9 years ago
jarneil

UKOUG Systems Event and Exadata Content - I’ve been involved in organising a couple of upcoming UKOUG events. I will be involved with the engineered systems stream for the annual UKOUG conference, ...
9 years ago
Karen Morton

Find it. Fix it. Real-World SQL Tuning Cases - Jan. 13 Webinar Followup - If you missed my January 13th webinar entitled "Find it. Fix it. Real-World SQL Tuning Cases" you can now access the recording and download the presentatio...
9 years ago
Alejandro Vargas' Blog

How to setup passwordless ssh in Exadata using dcli - Setting passwordless ssh root connection using dcli is fast and simple and will easy later to execute commands on all servers using this utility. In...
10 years ago
Oracle DBA and Apps DBA blog

No Write Permission on ACFS Mount Point - Last night, I managed to create the ACFS Mount Point after resolving the issue *"ACFS-9459: ASVM/ACFS is not supported on this os version"*. But, after c...
10 years ago
Snapshot Too Old

Rolling Out-of-Place patching para Oracle Grid Infrastructure 12c y 11gR2: clonación en esteroides - Mi artículo más reciente para *ToadWorld*, dentro de una serie dedicada a aplicar *patches* con mínima suspensión del servicio. Ahora detallando cómo aplic...
10 years ago
I'm just a simple DBA on a complex production system

On Error Messages - Here’s a pet peeve of mine: Customers who don’t read the error messages. The usual symptom is a belief that there is just on error: “Doesn’t work”, and tha...
10 years ago
The Tom Kyte Blog

Upcoming Events... - I took some time off from the road at the beginning of 2014 - getting ready to get back on the road again, lots of trips scheduled from February till the e...
10 years ago
Database RAC DataGaurd and APPS

When error say nothing about real issue - We want restore backup from source. So we took backup from source and copied it to /dba/share/MYDB on target. My collouge sent me email saying restore fai...
11 years ago
The Oracle Sponge

Little Changed - Incredible and depressing to see people still getting Oracle internals as wrong as this.
11 years ago
Miladin Modrakovic's Blog: Oraclue

GoldenGate error OGG-01755 SQL error: OCI Error 26,723 = ORA-26723 - I was trying to register extract OGG v 11.2 on one of my dev servers GGSCI (tpadldb10.gratiscard.com) 1> dblogin userid srvegate password xxxxx Successfu...
12 years ago
iDevelopment.info News

Oracle Database Name Resolution with OpenLDAP - Oracle Database Name Resolution with OpenLDAP Anyone who has ever worked with the Oracle Database is most likely familiar with the tnsnames.ora file. The...
12 years ago
TheBest

투표하세요 -
12 years ago
Method R Corporation

Front Page - Method R software measures the *performance experience*. Book PDF for 1 developer or DBA 15 Workbench PDF and software for 1 developer or DBA 2,227 ...
13 years ago
Life After Coffee

S107G Mini Helicopter Review - I’m a long-time fan of radio controlled flight, so when XenonProject.com offered me the chance to review the S107G Mini RC Helicopter I was excited for the...
13 years ago
Dion Cho - Oracle Performance Storyteller

Interesting case of the restriction of global hints - One of my colleagues sent following test case, of which he couldn’t control the join order with hints. 1. Create objects – table t1, t2 and t3 2. Now Let’s...
14 years ago
Mufalani - DBA Oracle

Olá mundo - blah
14 years ago
Inside the Oracle Optimizer - Removing the black magic

We have moved! - You might have been wondering why things had gone so quiet on the Optimizer development team's blog Optimizer Magic over the last few months. Well the blog...
14 years ago
We Do Not Use Blogs

The only thing you should NOT ask Icelanders (and maybe Norwegians) to do... - I love to visit Iceland. Not because of the landscape (We Do Not Use landscapes), but because of the people there. Man, they're funny and good to talk to. ...
14 years ago
Ordinary Oracle Joe

Becoming an Oracle DBA part 2 - In an earlier post I discussed how I believed a framework or apprenticeship should be created to promote the career path of DBA to talented individuals. In...
14 years ago
Oracle is not Magic, it just takes years of experience

OOW 2009 1st report - It’s all about innovation that what Larry Ellison/Oracle and Scott McNealy/Sun said at the opening key note. I arrived to san Francisco for oow 2009 and I ...
15 years ago
Anil Passi Oracle Home

Customization and Development Book - About Oracle Apps Development Book Last few months, I have been extremely busy with writing a book about Oracle E-Business Suite development techniques inc...
15 years ago
SQL> oradeblog

Goodbye ORA-600, hello, Blue Gecko - Things are changing a little around here. I have been running ORA-600 Consulting for five years, and have made the big decision to join Blue Gecko, a remot...
15 years ago
The R. M. Menon blog on Database and J2EE

Dealing with Oracle PL/SQL Error "ORA-04068: existing state of packages has been discarded" Transparently in Java/JDBC - My next article is on how to deal with the infamous "ORA-04068" error that occurs when using PL/SQL packages in your application. I first wrote this articl...
17 years ago
Oracle Databases in Action

-
Structured Data

-
HP's Oracle Blog

-
Science of DataBase

-
Oracle DBA - Oracle Apps DBA Instant Solutions

-
The Grumpy DBA blogs . . .

-
Oracle - Tricks of the Trade

-
Frits Hoogland Weblog

-
BLOG RODRIGO ALMEIDA

-
lutz hartmann as sysdba

-
Jiltin's Blog

-
Home

-

Show 5 Show All

Travel theme. Powered by Blogger.