Home
DataBase NoteBook
Home
Oracle
SQL Basics
SQL
Oracle DBA
Oracle Tuning
Oracle Insight
SQL Server
SQL
SQL Server DBA
SQL Server Insight
SISS
Informatica
SAP HANA
Monday, August 24, 2009
Query to identify the SID of current session
6:28 AM
Oracle
,
Oracle-DBA
No comments
select sid from V$mystat where rownum =1;
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Newer Post
Older Post
Home
0 comments:
Post a Comment
Subscribe to:
Post Comments (Atom)
Social Profiles
Popular
Tags
Blog Archives
Error message 402: The data types ntext and varchar are incompatible in the equal to operator.
where clause with ntext in SQL server: I have a column of type ntext in SQL server how can I evaluate it in a WHERE clause. Structu...
SAP HANA
SAP HANA: SAP HANA converges database and application platform capabilities in-memory to transform transactions, analytics, ...
Sysname
About Sysname: The sysname data type is used for table columns, variables, and stored procedure parameters that store object names. The exa...
SSIS: Connect to Oracle - Cannot retrieve the column code page info from the OLE DB Provider
SSIS: Connect to Oracle - Cannot retrieve the column code page info from the OLE DB Provider I have tried to access data in Oracle from...
Error message is: The directory name is invalid in SQL Server
Error Message: in SQL server An error occurred while executing batch. Error message is: The directory name is invalid. Reason: This err...
Schema Binding in SQL server
Schema Binding : Creating a view with the SCHEMABINDING option locks the tables being referred by the view and prevents any changes that ma...
HANA Database Schemas and Database Tables
HANA Database Schemas and Database Tables The below artifacts are major part of the SAP HANA Database. Schemas Table...
Enable xp_cmdshell on a MS SQL Server Instance
Enable xp_cmdshell on a MS SQL Server Instance : xp_cmdshell has the power to make modifications on the outer world of SQL Server. So this ...
User Defined Functions - Informatica
User Defined Functions - Informatica Informatica User Defined Functions are similar to Built-in Functions, where these functions need to be ...
NOLOGGING Vs Redo entries.
Title: NOLOGGING Vs Redo entries. Comments: This document is related to the redo log generation of the scripts in LOGGING mode and the NOL...
About me and Blog !
Hi!!!! I work in Oracle and SQL Server products and have opened this blog to share by day to day experiences.
Note: The opinions expressed herein are my own personal opinions.
Please feel free to comment here.
Karthikeyan Baskaran
OCA
Followers
Month List
Month List
Aug 2013 (3)
May 2013 (8)
May 2012 (1)
Oct 2011 (1)
Sep 2011 (1)
Feb 2011 (2)
Jan 2011 (1)
Dec 2010 (3)
Nov 2010 (1)
Oct 2010 (1)
Sep 2010 (2)
Aug 2010 (3)
Jul 2010 (3)
Jun 2010 (13)
Apr 2010 (2)
Feb 2010 (6)
Jan 2010 (1)
Nov 2009 (1)
Oct 2009 (3)
Sep 2009 (2)
Aug 2009 (9)
Labels
HANA
(1)
HANA_Home
(1)
Informatica
(1)
Oracle
(36)
Oracle - SQL
(8)
Oracle - Tuning
(6)
Oracle Insight
(16)
Oracle-DBA
(11)
Oracle-SQL Basic
(4)
Shell Script
(1)
SQL Server
(20)
SQL Server - SQL
(15)
SQL Server Basic
(1)
SQL Server DBA
(6)
SQL Server Insight
(1)
SSIS
(1)
Blog Archive
►
2013
(11)
►
August
(3)
►
May
(8)
►
2012
(1)
►
May
(1)
►
2011
(5)
►
October
(1)
►
September
(1)
►
February
(2)
►
January
(1)
►
2010
(35)
►
December
(3)
►
November
(1)
►
October
(1)
►
September
(2)
►
August
(3)
►
July
(3)
►
June
(13)
►
April
(2)
►
February
(6)
►
January
(1)
▼
2009
(15)
►
November
(1)
►
October
(3)
►
September
(2)
▼
August
(9)
Multitable Inserts
Table Space Status Script
TRUNCATE Vs Index Status
Identify the redo size of the current session
Query to identify the SID of current session
NOLOGGING Vs Redo entries.
Indexes on two different table space( Associated t...
UNION = OR?
Index scan on Null able column
Blogger templates
Blogger news
Blogroll
0 comments:
Post a Comment