-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
There are few ways to calculate end of day i.e when the time is 23:59:59. In the example below it… READ MORE
One can flush the shared pool using the following DDL. SQL> ALTER SYSTEM FLUSH SHARED_POOL; System altered. Using the following… READ MORE
|
Immediately after a successful RDBMS installation (perhaps even including a sample DB instance creation), sqlplus will not start: [oracle@test ~]$… READ MORE
|
To use automatic shared memory management, the value of statistics_level must be set to “typical” or “all”. The parameter can… READ MORE
|
When an java app connects to oracle depending on the driver such as osuser, program in v$session will not be… READ MORE
Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when “oracle” user is not… READ MORE
If one needs to restore archive logs to disk and not apply them, for example in case when cloning a… READ MORE
In 10g there is a new view called DBA_FEATURE_USAGE_STATISTICS which keeps features have been used. Here is description of some… READ MORE
NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns and NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns. One can find… READ MORE
|
The view DBA_ROLES doesn’t have the created date column to display when the role was created, but the information is… READ MORE
This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly therefore… READ MORE
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 