Tag Info

New answers tagged

1

What the SIDs on all the nodes? Is this really the same DATABASE. For example you can have 3 node cluster having a single ASM on all the nodes, but database A is clustered on node1/node2. But database B runs only on the node 3. The database B then is still started and stopped by the Clusterware, but is not clustered. You can also check output from: ps -ef ...


4

Why do you use this view at all for this query? The view collects violations and other stuff, but your query does not care about those at all, just the number of items. The view lists all items regardless of these because of the outer joins, so you basically perform a lot of unnecessary extra work to collect violations and other stuff (the NO_MERGE hint ...


1

You can improve efficiency of your query by (for example) replacing: ,( SELECT /*+ NO_MERGE */ pv.item_id ,count(*) AS cnt FROM policy_violation pv WHERE pv.item_id IS NOT NULL AND pv.quarantine_status = 'QUARANTINED' GROUP BY pv.item_id ) ct1 ,( SELECT /*+ NO_MERGE */ ...


1

From here, it appears that you can use it for the very purposes you describe at no cost. The relevant passage is here License Rights and Restrictions Oracle grants You a nonexclusive, nontransferable, limited license to internally use the Programs, subject to the restrictions stated in this Agreement, only for the purpose of developing, testing, ...


1

Yes you do. If you install the Oracle software you need to pay for it. However numerous exceptions exist including you can use Oracle Express 11g for free your customer may have licencing provisions that apply to you Either way, do not take anything from my answer or anyone else's answer as valid. Oracle licencing is complex and a final word can only ...


1

However oracle keeps making my numbers 22 bytes long This assumption is wrong. Values stored in a NUMBER column take up only as much space as needed. Quote from the manual A NUMBER value requires from 1 to 22 bytes (emphasis mine) This can be validated using the VSIZE() function: create table foo (id number(22), some_value number(22,8)); ...


1

See here ixora. Number has variable length, like string. each digit occupies one nibble (4bits, half byte) NUMBER implementation is platform independent you can validate size of number value in a culumn by calling dump() function PS: Oracle also supports native intergers like PLS_INTEGER, but these can only be used in PL/SQL context only.


0

In order to do RMAN backups you need the SYSDBA or SYSOPER roles. In order to grant those you need to be able log on as a user with those roles: ie the SYS role. There are variations where you use OS authentication or if your OS user is a member of the ORA_DBA group. Easiest is if you can do this: CONNECT / AS SYSDBA from the server then you can run ...


1

There is no reasonable way how to do that. For example till 11gR1 SELinux was not certified to be used with Oracle database. Since 11gR2 this is at least not recommended. Let's assume that you and Oracle DBA are adult, where is the problem then? Oracle is not running with root privs. On the other hand Oracle requires many kernel tunables(sysctl) to be set ...


0

When you use sqlplus a549189/myPassword@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=identityprovisionreport.fmr.com)(PORT=1524))(CONNECT_DATA=(SID=AARCER1)))" then you don't need any tnsnames.ora file. Your entry in tnsnames.ora file should be like this: AARCER1 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= identityprovisionreport.fmr.com)(PORT=1524)) ...



Top 50 recent answers are included