-
SQL> CONN system/oracle@pdb1 Connected. SQL> alter user system identified by oracle12; alter user system identified by oracle12 *...
-
SQL> create tablespace bigtbs datafile '/u01/app/oracle/oradata/bigtbs.dbf' size 20m blocksize 32k; create tablespace bigtbs da...
-
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...
-
Go to the ORACLE_HOME path , there you can find deinstall folder [oracle@dbacentre1 ~]$ cd $ORACLE_HOME [oracle@dbacentre1 dbhome_2]$ c...
-
Jobs Agent History clean up: distribution Use Distribution EXEC dbo.sp_MShistory_cleanup @history_retention = 48 Internally for...
-
Introduction to DMV's and DMF's in SQL Server 2005 The DMVs; newly introduced in SQL Server 2005 gives the database administrat...
-
Example of a statement that retrieves information from INFORMATION_SCHEMA : MYSQL> SELECT TABLE_NAME, TABLE_TYPE, ENG...
-
SYSTEM2 SQL> startup open read only; ORACLE instance started. Total System Global Area 313860096 bytes Fixed Size ...
-
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...
No comments:
Post a Comment