Getting Metadata from Oracle databases !

[rsonnathi]

Hi All,

My focus is to get Capacity and consumption of Oracle databases. Which the best way to do it ? I am focusing on OCI,but how to get the metadata without using sql statements ? For databases we say select * from v$database;But is there any other programatic way to do it.I am really stuck here.I would appreciate if I get help here.

Thank you very much.

---Radha

[sambavan]

If you need to view any of the views then you have no other option other than invoking sqlplus. One of the other ways is you could come up with a script that would go through the

$ORACLE_BASE/oradata/<SID>/ *.* files and $ORACLE_BASE/admin/<SID>/arch/ *.arc
?/rdbms/audit/

to find out the growth rate.


Other than these, I couldn't think of a way.

Sam

[pwoneill]

What would you use OCI for if not for executing SQL statements? You can use OCI from whatever language you're using that has a library, but to get information out of the database you have to write a sql query and have it executed somehow.

[rsonnathi]

pwoneill,

I am not clear enough. What I meant was when I am in my c++ application, if I use any OCI function calls ,do they take care of sql statements rather than I am putting them in my C++ code ? I used SQLServer before and I know that we can used DMO API to get the data from the database without using any sql statements.

Thanks.

[pwoneill]

You use OCI to execute the sql statements and return them to your application. I don't know the exact syntax of the C++ library but it's probablly something like


$c1 = OCIlogon("scott","tiger",$db);
$stmt = OCIparse($c1,"select yourinfo here");
OCIexecute($stmt,OCI_DEFAULT);
while (OCIfetch($stmt)) {
// loop through rows returned
}

that's the library for a scripting language so types and arrays are a lot less strict than c++ but that's the general idea. Parse, Execute, Fetch.

You could also use Pro*C but I'm not sure offhand if it compiles C++ as well as C.

[rcaballe]

Oracle is very strict in the rule Todd said.
RDBMS must be accesed through SQL.
Apparentely SQLServer not :)
The only tool I know don't use SQL is Precise which accesses the SGA (Memory) directly (A hard work)

[kpnmani]

May be u can create a function or procedure in database. then u just call
those procedures.

Have u ever use TODD software try it

[rsonnathi]

Ramon,

"The only tool I know don't use SQL is Precise which accesses the SGA (Memory) directly (A hard work)" ,This is your reply,
Could you give me some more info about the tool that doesn't use SQL ? I would appreciate.

Thanks.

[rcaballe]

About Precise:
[url]http://www.precise.com[/url]

We are evaluating this tool because don't generate extra load to the database.
It has a very cool Repository to track changes.
And it can sample at very high rates, 10 or more samples by second.