SQL & PL/SQL :: User Session Details

Sep 14, 2010

How can I find out a user session/connection details like ( his last connection time, his activity etc)

Here is the issue, a old dba_user_id who physically no longer exists is not removed from the database. At some time, a session is opened under his user_id and some activity runs and closes the session. So, checked scheduled jobs under him and disabled them. But not sure whether the scheduled jobs are creating a session under his user_id or some thing else.

I checked in v$session, but since I am not sure at what time his session opens, so I am not able to get his session details.

View 5 Replies


ADVERTISEMENT

Session Details For A User

Nov 22, 2010

I have a user in my oracle database, I would like to know details such as, how many times and by using which tools same user has got logged for past one week.

How do I do that. I have sql which shows the current session either he is logged in, if so then which application or not logged in. But I required the information for past one week How do I get those details.

View 1 Replies View Related

Security :: Grant To Select Session Details

Mar 13, 2006

Developers they use Toad and in that they want to use session browser option so that they can see the SQL running and open Cursor,other session specific details...So what grant/ permissions can be given to them so that the Schema they logged on can access those information.

View 4 Replies View Related

How To Get Session / SQL Text Details Causing Excessive Archives Log

May 29, 2013

In my case , the archives are getting generating in excess count, how to get sql text/sid information.

View 2 Replies View Related

Application Express :: Kill Current Session When Another Session With Same User Starts

Nov 19, 2012

I have an urgent requirement to kill an existing session if a new session starts for the same user. I have been reading lot of blogs and posts on the above topic, but could clearly tell me how to do it.

I thought of putting a process in 101 page when login button is pressed to catch this and kill the old session.

View 7 Replies View Related

PL/SQL :: User Session Has Expired And Enable User Without Changing The Password

Aug 13, 2012

User session has expired. I have to enable user without changing the password of the user.

View 1 Replies View Related

Forms :: How To Get Details Of USER

May 26, 2010

I want to save ip address, os username, terminal information at the time of record insertion/updation therefore I am using sys_context function but it gives me error at the time of form compilation.

ERROR:

ORA-00600: internal error code, arguments: [17069],[134386616],[],[],[],[],[],[]

My user has already DBA privilege.

View 12 Replies View Related

How To Check Quota Details For A User

Feb 14, 2013

We have a scenario where we need to get the details of quota details on different tablespaces for a user. Is there any way to get this information directly using some views etc.

I tried with following option.. but not found in this... i think we can get this TOAD some other tools. but i never tried using SQL directly...

SELECT dbms_metadata.get_ddl('USER','SCOTT') FROM dual;

View 4 Replies View Related

Forms :: Trigger To Capture User Details

Jan 16, 2012

I have a table in that i have some columns along with that four columns to capture the user details. but these details must be captured Programmatically.like whenever a user insert or update or delete his credentials must be captured in these columns. but i am not figuring out in which trigger i have to write and how.

View 19 Replies View Related

Find Details Of User Who Modified Structure Of Table?

Aug 3, 2011

I have a small question is it possible to find the details of a user who modified the structure of a table, including what command he ran to change the structure of the table?

View 2 Replies View Related

How To Find CPU Usage By Each User Session

Sep 7, 2011

I can get "CPU used by this session' value from v$sesstat. That is the value in centiseconds used by each session. How to convert the value into a percentage of total CPU resource ?

Or there are some other ways to gain the value. i.e. Percentage of Total CPU usage for each Oracle session.

View 5 Replies View Related

How To Obtain User Session Info

Jan 26, 2007

How do I get my list of user session info? I thought there was a user_session_parameter view or something? Basically, I did an ALTER SESSION ... and want to verify it was set correctly.

View 8 Replies View Related

Server Administration :: PGA Memory For Every User Or Every Session

Mar 18, 2013

I need to ask about PGA memory. Is this memory for every user or every session

i.e. PGA 200M

I have 2 users with 300 connection with one of them. Is 200M for 300 connection or for every connect.

View 2 Replies View Related

Security :: How To Configure End User Open Only One Session

Jun 10, 2011

I want to configure this

my end user open only one session

means one session per one user only

View 8 Replies View Related

Restrict Concurrent User And / Or Session From A Client?

Nov 5, 2012

We have an application with database Oracle 10g.

I want to add a new validation to restrict concurrent user and/or session from a client. (we have almost 60 client firms using the software to enter daily trasnactions). All users from all clients are connecting to the database using a common functional ID.

What I did was:
1) Add a column 'user_logged_in' in the master table for client and update it as Y when user from that client logged on to the system,
2) Insert the application logon details (we can figure out the client details from this) into a global temp table,
3) Create a logoff trigger to update the 'user_logged_in'flag in client master table by using values from global temp table when session logged off and
4) Restrict the users from same client if the flag is 'Y'

But the problem in this case is logoff trigger will not be executed in case if the session got killed or terminated abnormally.

View 3 Replies View Related

Server Administration :: Monitoring User Session And Killing It?

Jun 8, 2010

I am using TOAD to monitor user sessions. I have a user who uses nearly 80% of Overall resources in the mornings. He calls me daily and say that his work is done. But even then the TOAD shows that he is using same resources for some time.

My question is can i kill the session once he confirms his work is done OR do i need to wait till the redologs are cleared.

View 9 Replies View Related

SQL & PL/SQL :: ORA-01001 - User Refresh SSRS Session And Again Run Query

Jan 11, 2012

We have a package procedure called from SSRS , which returns a REFCURSOR to the SSRS.Sometimes it throws the error. The user Refresh the SSRS session and again run the query , the error does not happen

Following is the error number

ORA-01001: invalid cursor

We have not used any static cursor , so this is not happening because we have opened a cursor and not closed it.The Cursor used is REF CURSOR and the output parameter is declared as

---------------
p_ref_cursor OUT SYS_REFCURSOR
----------

The Procedure returns the Select query in the REF CURSOR.

View 7 Replies View Related

Session Restriction - Limit Number Of Open Application Actions By Some Os User?

Sep 17, 2013

,in 11g,is there a way I could limit the number of open application actions by some os user ?We have an application where users are executing the same thing while the last is not yet finished,so we have several same things runninng at the same time executed by the same user.

Can we restrict that somehow through the database or that needs to beĀ  done through application?

View 4 Replies View Related

Application Express :: (X) Process Taking 60% CPU In Two Session (30% Each Session)

Oct 23, 2012

We are using Apex 4.0/Oracle 10gR2/ Hp-Ux, We noticed that there is a process Running in Two Sessions that seems running since 3 Hours using 60% CPU,** 30% given below sql it executes in two Sessions!

declare function x return boolean is begin -- if instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY')>0 then
declare
l_position number := 0;
begin
loop
l_position := instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) ;
exit when instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) = 0 ;

[code]....

View 4 Replies View Related

Grant Select On V$session And Gv$session Directly?

Aug 28, 2013

Instead of giving permission directly to v$session and gv$session to a developer, Is there any other way to do the same?

View 3 Replies View Related

SQL & PL/SQL :: Breakdown Sum Into Details?

Jun 18, 2013

I have to breakdown the sum of qty into each line as single piece ,as example below how to achieve this using sql as i am doing it using a procedure.

CREATE TABLE OT_CUT_ITEM
(
CTI_SYS_ID NUMBER,
CTI_ITEM_CODE VARCHAR2(30 BYTE),
CTI_LEN NUMBER,
CTI_QTY NUMBER
);

[code]....

output required is

CTI_SYS_ID CTI_ITEM_CODE CTI_LEN CTI_QTY
---------- ------------------------------ ---------- ----------
1 A 7000 1
1 A 7000 1
1 A 7000 1
1 A 7000 1
2 B 6000 1

[code]....

View 3 Replies View Related

SQL & PL/SQL :: Summary Column To Details?

Sep 25, 2011

I have one table which has two columns name,qty and it has data like arif,3 pcs i want to display it in 3 lines if the qty is 3 and in 2 lines if the qty is 2 using sql query

View 6 Replies View Related

CPU License Details Required

Aug 23, 2013

In our project we have many instance running with Oracle in one solaris zone. We are in the process of cost reduction so planning to bring the CPU in shared pool and reduce them.

if we can bring all the NUP (Named user Perception) CPU on one shared pool. Will it be cost effective and is there any problems in performing such change.

View 3 Replies View Related

SQL Query Details In AWR Report?

Aug 30, 2012

In AWR Report i found that there are few SQL queries that have full table scans how can we drill about this and find which table have full scan

yes with Explain plan we can do this but is there any other way in Oracle 11g

View 7 Replies View Related

Forms :: Details Should Be Updated From One To Other Table

Mar 19, 2011

when the tables are updated, the following detals must be correct to ensure that the links in the affected tables are in place.

PLUPDATE_NEW(PLUP_SAVE_SEQ field value) must be the same with PLUPDATE_BENEF_NEW (PLUP_NEW_BENEF_SAVE_SEQ field value)
PLUPDATE_OLD(PLUP_SAVE_SEQ field value) must be the same with PLUPDATE_BENEF_OLD (PLUP_OLD_BENEF_SAVE_SEQ field value)?

[Code]....

i tried this code, what should i do in the link for this tables?

View 5 Replies View Related

Forms :: Display Employee Details?

Feb 25, 2013

i want to display employees details when i am passing Deptno and that department employees only display in Oracle Forms

View 16 Replies View Related

SQL & PL/SQL :: Selective Column Details On Runtime

Apr 10, 2011

I have tables dynamically created with dynamic number of columns. There will be 7 columns that would always be fixed with their names and data types. They will always be last 7 columns.

way to write a select statement on those dynamic tables where only those known 7 columns are not selected and I need to select all the rest columns but leave the 7 columns names I know.

View 6 Replies View Related

SQL & PL/SQL :: Execution Details Of DBMS Jobs?

Sep 7, 2010

Under what userid(privileges) does a scheduled DBMS Jos run, is it under the same user that scheduled the job?

Does oracle internally log in(opens a new session) in order to run a scheduled DBMS Job?

some reference websites where I can get some details about how the scheduled jobs are executed?

View 2 Replies View Related

Forms :: F5 Shows Available Block Details

Sep 29, 2010

When I execute my form, on pressing key F5 it displays the all available block names in the form. I want to restrict this.

View 5 Replies View Related

SQL & PL/SQL :: Query - Get Details Of Each Employee In Single Row?

Jun 7, 2012

I have three tables as shown in the image. Need to get the details of each employee in a single row..

EMployee_id BaseSalary Bonus Hike shares

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved