Showing posts with label Sessions. Show all posts
Showing posts with label Sessions. Show all posts
Wednesday, January 31, 2024

How come I cannot logon to my instance as sysdba, when the ORACLE_SID variable is set correctly?

›
Here's a reminder if you use a symbolic link for your ORACLE_HOME variable: You will not be able to attach to your instance using OS a...
Thursday, September 1, 2022

What is the missing privilege when receiving ORA-01031: insufficient privileges when switching container?

›
You need to grant the SET CONTAINER system privilege to a common user, in order for the user to be able to switch container. Eksample: yo...
Wednesday, December 22, 2021

What is the difference between "force parallel" and "enable parallel" used in the "alter session" statement in Oracle?

›
What is the difference between these two statements? ALTER SESSION ENABLE PARALLEL DML | DDL | QUERY; and ALTER SESSION FORCE PARALLEL ...
Wednesday, November 3, 2021

An Oracle procedure that allow users to kill their own sessions

›
First, create a view that lets the users check their own sessions: connect / as sysdba create or replace view my_sessions as select us...
Thursday, March 7, 2019

How to use dbms_session to set client_identifier in your session

›
Logged in as user scott, I set the following in my session: EXEC DBMS_SESSION.SET_IDENTIFIER (client_id=>'vegardk'); Verify t...
Wednesday, March 15, 2017

How to find wait information about a session

›
Yesterday, I had started a script with two long-running queries before I my shift ended, and it was finished when I got back, as expected. ...
Thursday, January 12, 2017

How to solve ORA-02391 exceeded simultaneous SESSIONS_PER_USER limit

›
The error definition: // *Cause: An attempt was made to exceed the maximum number of // concurrent sessions allowed by the SESSI...
Tuesday, December 20, 2016

Will interrupting a "split partition"-command cause any harm to your database?

›
Will interrupting a "alter table split partition"-command cause any harm to your database? No, it will not. It is safe to kill t...
Sunday, December 18, 2016

How to create a common and a local user in a 12c multitenant database

›
In a multitenant container database, there are two types of users: * Common users, who are known in both the root containers and in all th...
Friday, January 23, 2015

What is the difference between a BEQUEATH connection and an IPC connection?

›
A bequeath connection runs on your local host bypasses the listener the protocol creates the server process for you directly An IPC (I...
1 comment:
Tuesday, August 26, 2014

How to find the SID, serial# and their operating system process ID from the database

›
A simple statement to find the SID, serial# and their operating system process ID from the database: SET LINES 300 PAGES 300 SET TRIMSPOOL...
Tuesday, July 15, 2014

What is the difference between the columns PID and SPID in v$process?

›
The PID column is an internal counter that oracle uses for its own processes. It is incremented by one for every new process. Consequently, ...
Thursday, March 6, 2014

How to use v$session_longops to check long running processes

›
I am setting NLS_DATE_FORMAT so that the START_TIME and LAST_UPDATE_TIME will be more accurate. SET TERMOUT OFF ALTER SESSION SET NLS_DATE...
Thursday, February 13, 2014

An easy way to find DML locks

›
The view DBA_DML_LOCKS is a convenient view to use if you want to identify locks caused by uncommited DML statements. Consider the follow...
Friday, January 10, 2014

How to display session information, followed by a kill-statement

›
Often, my customers ask me to kill a runaway session for them, typically this will be in the form "Can you please kill session with ses...
Tuesday, October 29, 2013

How to set the current schema in a session

›
alter session set current_schema=SCOTT; The CURRENT_SCHEMA parameter changes the current schema of the session to the specified schema. S...
Tuesday, October 22, 2013

How to generate scripts to move partitions to a new tablespace while updating the indexes

›
Probably many ways of doing this, but here is how I generated scripts to move table partitions from one tablespace to another: -- Find tab...
Saturday, October 19, 2013

Some useful session views - short description

›
V$SESSION --> displays information about the current session V$SESSION_EVENT --> shows all the wait events waited for by the session...

How to name a trace file to find it more easily

›
alter session set tracefile_identifier = 'your string for easy recognition here'; For example: alter session set tracefile_ident...

How to set a timeout for DDL operations in oracle11g - to avoid "resource busy" error

›
ALTER SESSION SET DDL_LOCK_TIMEOUT = 10; when a DDL statement in the session does not get the exclusive lock, it will not error out. Inst...