Database Stuff

Repository of Database Related Information, Assets and Knowledge Base covering Oracle, SQLs, Scripts, Performance Tuning etc

Showing posts with label user name. Show all posts

Showing posts with label user name. Show all posts

Oracle: Show current user

Show current user

Show user;

or

Select user from dual;

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: oracle SQL, user name

Older Posts Home

Subscribe to: Posts (Atom)

Labels

oracle SQL oracle database oracle 10g SQL Optimizer user v$session parameter sid sqlplus;database name userid username SET SPOOL SQL Faq SQL Tutorial column imp import initialization optimization oracle DBA oracle hints process rename rename table sizing sql hints statistics status system tables table table locks tablespace temp tablespace user name v$lock v$parameter v$process v$sessmetric v$sql

Blog Archive

▼ 2012 (3)
- ▼ September (3)

► 2010 (3)
- ► September (1)
- ► May (2)

► 2009 (11)
- ► October (2)
- ► September (9)

► 2008 (2)
- ► December (2)

Popular Posts

Oracle: Monitoring progress of import jobs

Code to monitor speed of import jobs: select substr(sql_text,instr(sql_text,'INTO "'),30) table_name, rows_processed...
Oracle: Script to check for table locks

Script to check for Oracle table locks: Display details on which table is being locked by which process/user select s1.username || ...
Oracle: SqlPlus Useful Set Command

Useful SET commands for output formatting and SPOOL: SET TERM OFF -- TERM = ON will display on terminal screen (OFF = show in LOG o...
Oracle: SQLplus Prompt to show user, connection (10g)

SQLplus Prompt to show user, connection (Oracle 10g) run the following in sqlplus: set sqlprompt "_USER'@'_CONNECT_IDENTIFI...
Oracle: Script to display current slow job details

Oracle Script to display slow jobs details column e_dttm format a15 column usr format a10 column hp format 9999999999 select TO_CHAR(...
Oracle: Get database name using sqlplus

Get database name using this sql: select ora_database_name from dual;
Oracle Hints (10G)

Hints for Optimization Approaches and Goals ALL_ROWS The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a statement...
Oracle: Script to display session details

Script to display Oracle session details: column value format a40 column description format a100 SELECT 'AUDITED_CURSORID' AS P...
Oracle: Check which user is holding temp tablespace

Check which user holding temp tablespace SELECT s.username, s.sid, u.TABLESPACE, u.CONTENTS, u.extents, u.blocks FROM v$session s, v$s...
Oracle: List freespace by Tablespaces

Use the following script to get sizing (free,used etc) for tablespaces: -----------------------------------------------------------------...

Pages

Subscribe To

Posts

Posts

All Comments

All Comments

hits counter

Awesome Inc. theme. Powered by Blogger.