|
| | Script to find invalid synonyms
select *
from dba_synonyms s
where table_owner not in ('SYS', 'SYSTEM')
and db_link is NULL
and table_name not in
(select object_name
from dba_objects o
where o.object_name = s.table_name
and o.owner = s.table_owner
... | | 
More...
07/09/09 | | | | | | | | |
|
| | ld: fatal: file /dev/zero: mmap anon failed
If you get the following error while installing Oracle database server software on SUN Solaris, chances are you're out of swap space or there is not enough RAM:
ld: fatal: file /dev/zero: mmap anon failed
Use these utilities to check the swap space:
swap -s
df -k /tmp
Either get your Unix administrator to add ... | | 
More...
04/09/09 | | | | | | | | |
|
| | Set NLS parameter for session in logon trigger
If you are trying to run something like ALTER SESSION SET in logon trigger you will get ORA-04092 or if you are trying to do it with DBMS_SESSION you will get ORA-06512.
The solution is to create a procedure and then call procedure from the trigger i.e.:
--
-- procedure to set NLS_DATE_FORMAT ... | |
More...
03/31/09 | | | | | | | | |
|
|
|
| | Two databases with the same name on one server
You can run 2 Oracle instances with the same database name. To do that set the following
parameter(s):
Instance 1:
*.lock_name_space=DB1
*.sp_name=DB1
Instance 2:
*.lock_name_space=DB2
*.sp_name=DB2
In your oratab you would have two entries, one for DB1 and another one for DB2. db_name would be the same for both. | | More...
02/17/09 | | | | | | | | |
|
| | Removing directories from the bottom up
Sometimes on Solaris (I only saw this problem happen on ZFS) rm -Rf doesn't work properly, it deletes all the files but doesn't remove the directories. The following error message is displayed:
rm: cannot determine if this is an ancestor of the current working directory
The way around this is:
find . -depth ... | |
More...
01/28/09 | | | | | | | | |
|
| | View wait events for a session
select a.sid, a.event, a.total_waits, a.time_waited, a.average_wait, b.username, b.osuser, b.machine, b.program
from v$session_event a, v$session b
where time_waited > 0
and a.sid = b.sid
and a.sid = 283
order by time_waited; | | More...
01/13/09 | | | | | | | | |
|
| | Getting ORA-04021 when running grant execute on package?
If you are trying to grant execute on a package and getting ORA-04021 'timeout occurred while waiting to lock object' try the following:
Check who else is using the packages:
SQL> select * from v$access where object = 'PACKAGE_NAME';
If you see another session accessing the package ask the user to logout or ... | | More...
10/31/08 | | | | | | | | |
|
<< 1 | 2 | Page 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 >>
|
