centre of excellence for DBA's.Official website www.dbacentre.com
Popular Posts
-
SQL> CONN system/oracle@pdb1 Connected. SQL> alter user system identified by oracle12; alter user system identified by oracle12 *...
-
ORACLE Upgradataion 11.2.0.1.0 to 11.2.0.4.0 download the software Oracle 11.2.0.1.0 from oracle support [root@oranode1 ~]# /u01/app/oracle...
-
SQL> create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 32k; create tablespace bigtbs da...
-
Jobs Agent History clean up: distribution Use Distribution EXEC dbo.sp_MShistory_cleanup @history_retention = 48 Internally for...
-
SYSTEM2 SQL> startup open read only; ORACLE instance started. Total System Global Area 313860096 bytes Fixed Size ...
-
Introduction to DMV's and DMF's in SQL Server 2005 The DMVs; newly introduced in SQL Server 2005 gives the database administrat...
-
SQL> CONN system/oracle@pdb1 Connected. SQL> select name from v$datafile; NAME --------------------------------------------...
-
Power of DBMS_SHARED_POOL Package This article I have tried to explain the power and importance of DBMS_SHARED_POOL package as fo...
-
Issue while connecting to SQLServer Found the error below And I have a look on this C:\Program Files\Microsoft SQL Server\MSSQL10_50.E...
-
set pagesize 100 column file_name format a32 column tablespace_name format a15 column status format a3 trunc column t format 999,999.00...
No comments:
Post a Comment