select sid from V$mystat where rownum =1;
Monday, August 24, 2009
Subscribe to:
Post Comments (Atom)
Social Profiles
-
The array size is the number of rows fetched (or sent, in the case of inserts, updates, and deletes) by the server at a time. It can have a ...
-
Performance Improvement - Part 2: Hard parse is not bad In previous post, we have seen the soft parsing is doing less operation comparing wi... -
Stored procedure to read the filenames: create procedure spReadFolder @path sysname as begin set nocount on declare @dirfile table( id int...
-
Oracle 9i Result: SQL> drop table t; Table dropped. SQL> create table t (c number); Table created. SQL> create view v1 as select c...
-
The table name and Column names CAN BE case sensitive in oracle, but are not by default. Bydefault, any way you create a table, upper case,...
-
We are using the B-Tree index and our predicate does not use the leading edge of index, in this case we might have a table T with an index o...
-
We are using the B-Tree index and our predicate does not use the leading edge of index, in this case we might have a table T with an index o...
-
Ways to get a Cumulative Sum: Initial setup: Creating the table and populating the table. CREATE TABLE #Sales (DayCount smallint, Sales mon... -
EXECUTE AS and REVERT: The EXECUTE AS and the REVERT are used to change the execution logins. We see the example to change the connection de... -
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 ...
Karthikeyan Baskaran
OCA
Blogger news
Blogroll
0 comments:
Post a Comment